I do a Proc Report and write the report out to Excel as below.
I name the sheet "MyReportA". However SAS is adding more text to this so the label becomes "My ReportA 1 - Detailed and or summary.....".
Anyone know how to stop this extra text appending onto the label?
ods _all_ close;
ods listing;
ods tagsets.excelxp file="c:\Test.xls";
ods tagsets.excelxp options( sheet_label="MyReportA");
ods _all_ close;
ods listing;
That is really weird.
ods proclabel=' ';
ods tagsets.excelxp file="c:\Test.xls";
ods tagsets.excelxp options( sheet_NAME ="MyReportA");
proc report nowd contents=' ';
That is really weird.
ods proclabel=' ';
ods tagsets.excelxp file="c:\Test.xls";
ods tagsets.excelxp options( sheet_NAME ="MyReportA");
proc report nowd contents=' ';
That's great thanks. Its the contents= "" that does the trick.
And if printing multipe reports to multiple tabs then using sheet_name was indeed necessary instead of sheet_label.
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.