Could be an elementary question, but I was provided with data that was in the form of one column and can't figure out how to import it.
In the excel files tags like "age, employement, education, retirement, insurance" are merged, so a cell could look like "30,1,1,0,1".
Any solution would be appreciated :)
importing data that is merged into one column
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Non-normality and collinearity are NOT problems!
- Posts: 3775
- Joined: Wed Sep 17, 2008 2:25 pm
Re: importing data that is merged into one column
Try saving the Excel file as a csv file for a txt file. Drag-and-drop it onto EViews. When going through the screens, unclick "Don't split quoted fields" That should get you most of the way, although there may still be some extraneous quote marks left around.
Re: importing data that is merged into one column
@startz thanks, saving it as a text file allowed me to bypass the problem as eviews is compatible with .txt.
appreciate it a bunch :)
appreciate it a bunch :)
Who is online
Users browsing this forum: No registered users and 13 guests