DATA Step, Macro, Functions and more

Display Macro Parameters

Accepted Solution Solved
Reply
Super User
Posts: 19,768
Accepted Solution

Display Macro Parameters

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!


Accepted Solutions
Solution
‎07-31-2015 06:07 AM
Super User
Super User
Posts: 7,035

Re: Display Macro Parameters

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

View solution in original post


All Replies
Respected Advisor
Posts: 3,799

Re: Display Macro Parameters

ODS TEXT = %sysfunc(quote(Years &fiscal_year));
Frequent Contributor
Posts: 85

Re: Display Macro Parameters

Posted in reply to data_null__

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

Maybe incorporate it into a TITLE.

Super User
Super User
Posts: 7,942

Re: Display Macro Parameters

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?

Super User
Posts: 19,768

Re: Display Macro Parameters

Thanks all!

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

Solution
‎07-31-2015 06:07 AM
Super User
Super User
Posts: 7,035

Re: Display Macro Parameters

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 297 views
  • 6 likes
  • 5 in conversation