first zero is missing

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

tzutzu
Posts: 15
Joined: Sun Apr 22, 2012 2:11 pm

first zero is missing

Postby tzutzu » Thu Jun 06, 2013 10:40 am

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,
Attachments
code.xls
(48 KiB) Downloaded 184 times

EViews Chris
EViews Developer
Posts: 161
Joined: Wed Sep 17, 2008 10:39 am

Re: first zero is missing

Postby EViews Chris » Thu Jun 06, 2013 11:25 am

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

tzutzu
Posts: 15
Joined: Sun Apr 22, 2012 2:11 pm

Re: first zero is missing

Postby tzutzu » Thu Jun 06, 2013 11:47 am

it works. many thanks Chris

tzutzu
Posts: 15
Joined: Sun Apr 22, 2012 2:11 pm

Re: first zero is missing

Postby tzutzu » Thu Jun 06, 2013 11:59 am

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..

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12316
Joined: Tue Sep 16, 2008 5:38 pm

Re: first zero is missing

Postby EViews Gareth » Thu Jun 06, 2013 12:56 pm

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 5 guests