data one;
input id $;
/* create formatting to preserve leading zeros in excel */
cid  =  ' = " '  ||  id  ||  ' " ';
cards;
00123
12398
01234
00034
;
run;
data one (drop=id);
      set one;
run;
ods listing close;
ods csv file='lead0.csv' ;
      proc print data=one noobs;
      run;
ods csv close;
2 comments:
Just curious: How did you get this info? The other workaround, at least for native xls, is to put a "'" in front of the number. For example, "10" is set as "'10".
This tip was tremendously helpful. Thank you!
Post a Comment