BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Palucci
Fluorite | Level 6

Is it possible to save the result of proc print in excel format as export and not in html?

  
proc print data=diff n noobs sumlabel='Titak' grandtotal_label='Grand Total';
   sum Custmer Price Sold ;
1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Something like 

 

ods html close;
ods excel file = "S:\SASPC\PNC\class.xlsx";

proc print data = sashelp.class;
run;

ods excel close;
ods html;

View solution in original post

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

Yes. Use the ODS Excel Destination. 

 

Plenty of examples online 🙂

PeterClemmensen
Tourmaline | Level 20

Something like 

 

ods html close;
ods excel file = "S:\SASPC\PNC\class.xlsx";

proc print data = sashelp.class;
run;

ods excel close;
ods html;
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 7287 views
  • 0 likes
  • 2 in conversation