Hi,
I am trying to create an excel report that breaks down the records by Name.
E.g.
Name ABC:
Result set 1
Name DEF"
Result set 2:
This code gets me the result set by Name but exports to a multi sheet .xls file. Is there anyway I can put it all into one excel file.
ods listing close;
ods tagsets.ExcelXP BODY ='test.xls'
style=Printer;
proc sort data=testFinal; by Name; run;
proc report data=testFinal nowd STYLE(REPORT)={Rules=none }
style(header) = {background=#99CCFF font_face=Arial};
BY Name;
column START_DATE numberofcall numberofpeople sucessrate Name;
DEFINE Team_Code_1 / ORDER 'Type' MISSING;
BREAK AFTER Name/ summarize;
quit;
ods tagsets.ExcelXP close;
Hi,
options (sheet_interval=none).
Options for the tagset are here: Base SAS: Quick Reference for TAGSETS.EXCELXP Tagset
Hi,
options (sheet_interval=none).
Options for the tagset are here: Base SAS: Quick Reference for TAGSETS.EXCELXP Tagset
Thanks for the tagsets link
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.