EViews.com

Hi

I want to import a text file into a table object using the command


However, the text for

02

is imported as

2

and

im

as

NA

(see picture below). How can this be imported direcly as a text string?

Thomas

You need to treat the first column as string during the import wizard.

Normally, EViews would automatically determine this, but the row that had character data in the first column was too far down the file and beyond the point in which EViews stops checking for data type.

Specifically, on page 4 of 5, you'll need to change the column data type to Character (click on the first column, then select "Character" as the Data type in the dropdown):


The associated captured command will also tell you how to do it programmatically:


The "types=" argument is what tells EViews to treat the first column as character data.

hi

thanks for your reply!

i tried your command, but it does not work.....



can you please take a second look at it?
Thomas

Oops, sorry - I forgot you were trying to create a Table instead of just a workfile.

Here's the command for importing your text file with the first column as text instead of a number:


EViews created this command for me when I did the following:

1. Open a workfile
2. File menu->Import->Table from file... and selected your text file.
3. Clicked Next until I got to "Step 3 of 4" in the import table wizard.
4. Clicked on the first column (in the bottom preview) and then changed the data type to "Character" in the Data type dropdown. Click Next.
6. Entered "MyTable" as the name of the table. Click Finish.
7. Switched to the Capture window to see the generated command.

Steve

Great Steve, that worked, thanks!
Thomas