Display Macro Parameters

[Reeza]

I have several user specified macro parameters that I'd like to supply on the final report for documentation purposes. Some of fields have embedded single quotes so I can't default switch to single quotes easily.

Eg.

%let fiscal_year = "2014/15" "2013/14";

I'm struggling with how to pass this to my output, which is ODS Tagsets.ExcelXP.

Currently trying

ODS TEXT ="Years" &fiscal_year;

Any help appreciated!

[data_null__]

ODS TEXT = %sysfunc(quote(Years &fiscal_year));

[JerryLeBreton]

Except I don't think ODS TEXT= is supported by  ExcelXP.

Maybe incorporate it into a TITLE.

[RW9]

I agree, don't think ODS Text works for that tagset.  Titles also appear only in the print preview, so maybe not useful.

One suggestion I have is this.  The macro variables are stored in the SASHELP.VMACRO dataset.  Why not proc report this, putting a where clause on for the macro's you want to, then proc report your other data to the same sheet.  Hence two proc reports one sheet?

[Reeza]

Thanks all!

Tom and Data _null_'s solution work and the title is in the worksheet.

[Tom · Accepted solution]

%let fiscal_year = "2014/15" "2013/14";

ods tagsets.excelxp file='C:\TEMP\text.xls'

  options( embedded_titles='yes' embedded_footnotes='yes' )

;

title1 %sysfunc(quote(Fiscal Year &fiscal_year));

proc print data=sashelp.class; run;

ods tagsets.excelxp close ;