LuckyLucks
asked on
leading zeros truncated after exporting to csv from sas dataset
Hi
I have a sas data set with a column thats 25 chars. When exporting to csv and then opening in excel I lose the leading zeros. How to prevent this? I would need code for proc print format. And how do I automatically get the rest of the fields w/o formatting each one
?
I have a sas data set with a column thats 25 chars. When exporting to csv and then opening in excel I lose the leading zeros. How to prevent this? I would need code for proc print format. And how do I automatically get the rest of the fields w/o formatting each one
?
ASKER
Exel will truncate leading zeros so cant use those.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Slight typo
Pay attention to the Text qualifier if you have any funny
characters (that is single or double quotes) in your data.
The Data preview should show the first few rows divided up
into columns with vertical bars.
Click Next
Ian
Pay attention to the Text qualifier if you have any funny
characters (that is single or double quotes) in your data.
The Data preview should show the first few rows divided up
into columns with vertical bars.
Click Next
Ian
and did you try the import wizard by going to File->Import Data.