Page 1 of 1
first zero is missing
Posted: Thu Jun 06, 2013 10:40 am
by tzutzu
hi guys,
I need your help please. i am trying to import the attached file into a workfile using wfopen command, but instead of having 010, the workfile store as 10.
i am wondering if there is anyway to import the full three digits codes from the file (maybe as a string perhaps)?
Thanks,
Re: first zero is missing
Posted: Thu Jun 06, 2013 11:25 am
by EViews Chris
If you're bringing the file in interactively, just use the combo box on the second page of the import to change the data type of the column from "Number" to "Character".
In a program, you can use a command
wfopen code.xls format=(A)
to do the same thing. (The format option has a list of comma separated column data types where 'A' is alphanumeric, 'F' is (floating point) numeric, and 'D' is date).
Chris
Re: first zero is missing
Posted: Thu Jun 06, 2013 11:47 am
by tzutzu
it works. many thanks Chris
Re: first zero is missing
Posted: Thu Jun 06, 2013 11:59 am
by tzutzu
hi Chris,
i have another question. would it be possible to import the file specify the first column being alphanumeric and the 2nd column being numeric ?
Thank you..
Re: first zero is missing
Posted: Thu Jun 06, 2013 12:56 pm
by EViews Gareth
(The format option has a list of comma separated column data types where 'A' is alphanumeric, 'F' is (floating point) numeric, and 'D' is date).