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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.