Hi All,
I have 10 data sets for county Segment and 10 data sets for state segment wise.
Need to export all datasets into 1 Excel file through ODS HTML according to segment wise on sheets.
Earlier using below code: (creating multiple excel files instead of Sheets);
/*COUNTRY WISE STATS*/
options nodate pageno=1 linesize=100 pagesize=100;
ods html file="D:\xxxxx\yyyyy\Country_Stats.xls";
proc sql;
title1 " Country - 1 Segment DQ Points ";
Title2 " ";
select * from Country_1_segment;
quit;
proc sql;
title1 " Country - 2 Segment DQ Points ";
Title2 " ";
select * from Country_2_segment;
quit;
proc sql;
title1 " Country - 3 Segment DQ Points ";
Title2 " ";
select * from Country_3_segment;
quit;
ods html close;
/*STATE WISE STATS*/
ods html file="D:\xxxxx\yyyyy\State_Stats.xls";
proc sql;
title1 " STATE - 1 Segment DQ Points ";
Title2 " ";
select * from STATE_1_segment;
quit;
proc sql;
title1 " STATE - 2 Segment DQ Points ";
Title2 " ";
select * from STATE_2_segment;
quit;
proc sql;
title1 " STATE - 3 Segment DQ Points ";
Title2 " ";
select * from STATE_3_segment;
quit;
ods html close;
Looking for Country wise information in one sheet, State wise information is on another sheet IN ONE EXCEL FILE
ods listing close;
ods tagsets.ExcelXP path=" " file = " "
options(sheet_interval = "none" sheetname = "Country ");
----
----
----
options(sheet_interval = "none" sheetname = "State");
---
---
---
ods tagsets.ExcelXP close;
ods listing;
Thank You,
From your code, every select query output created a new sheet in excel file, but I need 10 select quires under Country into one sheet and remain 10 select query output
into another. (20 select statements create 20 sheets instead of 2 sheets).
Have you tried changing the options for the ods tagsets.excelxp? MadhuKorni has given you your answer:
options(sheet_interval="none");
Then just proc report your data out and it should all appear on the same page.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.