ods tagsets.excelxp
file='c:\temp\sheetname.xls';
%let override_sheetname=;
proc report data=sashelp.class nowindows missing;
columns age sex name weight height;
define age / order;
compute before age;
title = 'Age is ' || put(age, 2.);
call symput('override_sheetname', title);
endcomp;
break after age / page;
run;
%symdel override_sheetname / nowarn;
ods tagsets.excelxp close;
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.