topic Re: Adding formats to Macro in SAS Programming

Adding formats to Macro

hwangnyc — Tue, 14 Aug 2018 12:54:34 GMT

Hi Everyone,

I have a a variable called FiscalYear and it's formatted:

value FYF
1 = "FY16"
2 = "FY17"
3 = "FY18"
4 = "FY19"
5 = "Older Than FY16"

I have a simple macro:

%let FYMacro = 3;

I want the the title to display for the format:

title "Hospital Report for &FYMacro";

The result I get is:

Hospital Report for 3

What I want is:

Hospital Report for FY18

Any suggestions would be greatly appreciated! Thank you!

Re: Adding formats to Macro

PaigeMiller — Tue, 14 Aug 2018 12:57:12 GMT

title "Hospital Report for %sysfunc(putn(&fymacro,fyf.))";

Re: Adding formats to Macro

Patrick — Tue, 14 Aug 2018 13:02:15 GMT

@hwangnyc

There are also options to use by-group processing and have individual titels created by by-group - but you haven't given us enough detail to propose such an approach.

Below code shows an approach to achieve what you've asked for.

proc format;
  value fyf
    1 = "FY16"
    2 = "FY17"
    3 = "FY18"
    4 = "FY19"
    5 = "Older Than FY16"
  ;
run;

%let FYMacro = 3;

title "Hospital Report for %sysfunc(putn(&FYMacro,fyf.))";
proc print data=sashelp.class;
run;

Re: Adding formats to Macro

data_null__ — Tue, 14 Aug 2018 13:58:33 GMT

There may be a situation where you need to deal with the trailing blanks. I have not been able to figure a way other than another %SYSFUNC.

Re: Adding formats to Macro

FreelanceReinh — Tue, 14 Aug 2018 14:33:44 GMT

%CMPRES is a bit shorter:

%cmpres(%sysfunc(putn(&FYMacro,fyf)))