topic Re: Display Macro Parameters in SAS Programming

Display Macro Parameters

Reeza — Thu, 30 Jul 2015 21:39:16 GMT

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!

Re: Display Macro Parameters

data_null__ — Thu, 30 Jul 2015 22:12:23 GMT

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

Re: Display Macro Parameters

JerryLeBreton — Fri, 31 Jul 2015 07:48:48 GMT

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

Maybe incorporate it into a TITLE.

Re: Display Macro Parameters

RW9 — Fri, 31 Jul 2015 09:01:13 GMT

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?

Re: Display Macro Parameters

Tom — Fri, 31 Jul 2015 10:07:01 GMT

%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 ;

Re: Display Macro Parameters

Reeza — Fri, 31 Jul 2015 15:07:37 GMT

Thanks all!

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