Hi i am having a dataset in this while exporting the dataset in to excel my formats are not coming .how can i do this.
for example in Date and percentages it was missing.
date result
jun09 12.3%
How can i bring the same in Excel as the formats are in SAS it should be expoerted in to excel
Have you format the variable in the dataset forever?
Such as:
[pre]
filename area1 DDE 'excel|c:\[Op.xls]Sheet1!r2c2:r50c20';
filename area2 DDE 'excel|c:\[Op.xls]Sheet1!r2c30:r50c40';
data temp;
set sashelp.class;
format weight height dollar12.2;
run;
data _null_;
set temp;
file area1;
put name sex height weight;
file area2;
put name sex height weight;
run;
[/pre]