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,
first zero is missing
Moderators: EViews Gareth, EViews Moderator
first zero is missing
- Attachments
-
- code.xls
- (48 KiB) Downloaded 369 times
-
- EViews Developer
- Posts: 161
- Joined: Wed Sep 17, 2008 10:39 am
Re: first zero is missing
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
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
it works. many thanks Chris
Re: first zero is missing
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..
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..
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13308
- Joined: Tue Sep 16, 2008 5:38 pm
Re: first zero is missing
EViews Chris wrote: (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).
Follow us on Twitter @IHSEViews
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 7 guests