DATA Step, Macro, Functions and more

i want to export two datasets into excel within single work sheet

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

i want to export two datasets into excel within single work sheet

i have two datasets for example sashelp.class1 sashelp.class2;
now i want to export these two datasets into excel within single work sheet.

sheet1 contains  sashelp.class1 data and sashelp.class2 data.


Accepted Solutions
Solution
‎09-10-2017 11:38 PM
Super User
Posts: 19,855

Re: i want to export two datasets into excel within single work sheet

Posted in reply to Kusuma001

ODS Excel file='myfile.xlsx" options(sheet_interval='none');

 

proc print data=SASHELP.class;

proc print data=SASHELP.air;

run;

 

ods excel close;

View solution in original post


All Replies
Solution
‎09-10-2017 11:38 PM
Super User
Posts: 19,855

Re: i want to export two datasets into excel within single work sheet

Posted in reply to Kusuma001

ODS Excel file='myfile.xlsx" options(sheet_interval='none');

 

proc print data=SASHELP.class;

proc print data=SASHELP.air;

run;

 

ods excel close;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 2 in conversation