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]
Ksharp
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.