topic Re: Import txt to sas in SAS Programming

Import txt to sas

LanMin — Mon, 02 Dec 2013 19:50:03 GMT

Dear all,

attached is a sample of my data (my real data has over 100,000 row). when I use sas ->file ->import data wizard, after importing successfully, variable cusip lose the leading zeros,

e.g., the first observation has a cusip =00036020, after import, it cusip =36020,

how could I fix this? (note: I have many observations, so I can't do it manually).

thanks for your time !

Lan

Re: Import txt to sas

ballardw — Mon, 02 Dec 2013 20:10:12 GMT

You have two basic choices, one is to leave cuspid as numeric and assign and appropriate format such as Z8.0 to display with leading zeroes. Or import the data as a string. When proc import runs it generates data step code that appears in the log that can be modified. Either use F4 to recall the code to the program editor or copy from the log. The INFORMAT and FORMAT for your cuspid are likely defaulting to a best32. format. Change those lines to be informat cuspid $8. , remove the $ that will appear after the variable in the INPUT statement, save and run the modified code.

Re: Import txt to sas

Astounding — Mon, 02 Dec 2013 20:19:41 GMT

Another possibility would be to take the already-imported variable and convert the data after the fact:

data want;

set have;

cuspid_char = put(cuspid, z8.);

drop cuspid;

rename cuspid_char = cuspid;

run;

Re: Import txt to sas

LanMin — Tue, 03 Dec 2013 16:13:37 GMT

thank you so much!

Lan

Re: Import txt to sas

LanMin — Tue, 03 Dec 2013 16:14:30 GMT

thank you so much!!!!

Lan