Link to home
Start Free TrialLog in
Avatar of LuckyLucks
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
?
Avatar of knsp
knsp

Here is some more info  with some options  http://www.ats.ucla.edu/stat/sas/faq/rwxls8.htm

and did you try the import wizard by going to File->Import Data.
Avatar of LuckyLucks

ASKER

Exel will truncate leading zeros so cant use those.
ASKER CERTIFIED SOLUTION
Avatar of theartfuldazzler
theartfuldazzler
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Ian
Ian
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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