Help using Base SAS procedures

Reg:Export Data to Excel but formats are missing

Reply
N/A
Posts: 0

Reg:Export Data to Excel but formats are missing

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
Super User
Posts: 9,671

Re: Reg:Export Data to Excel but formats are missing

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
Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 0 likes
  • 2 in conversation