I would like to use the ODS tagsets sheet_interval option with a macro variable to create separate sheets for a frequency of each variable within the macro. For example, here I want separate tabs showing the values by year and state for "make," "model," and "color": %LET varlist = make model color;
ODS tagsets.ExcelXP BODY = "C:\Mypath\myfile.xml";
ODS tagsets.ExcelXP options(sheet_interval='&varlist' absolute_column_width=&COL width_fudge='0.6' embedded_titles='Yes' sheet_name="");
PROC SURVEYFREQ DATA=mydata; TABLES year*state*(&varlist) / ROW CL;
WEIGHT mywgt;
RUN;
ODS tagsets.ExcelXP CLOSE; Right now, this code gives my a file with a separate tab for every table combination (e.g.one tab for the "make" table where year=2011 and state=alabama; one for the "make" table where year=2011 and state=alaska; etc.). Ideally, it would separate JUST on the macro variables so one "make" tab will have the cross-sections of every make by year and state - three tabs in total. Can someone help me see what I'm doing wrong? Thanks! I'm using SAS 9.4.
... View more