topic SAS Macro in title statement in SAS Programming

SAS Macro in title statement

jeremy4 — Tue, 31 Mar 2020 11:45:24 GMT

Hi,

I have currently got the following code below, but can someone please help me change the text that I have currently got highlighted in red, so that the title for each month of my results will be included, so that it should say "February 2020 - Differences between open date and register" and "January 2020 - Differences between open date and register"? Thanks!

Code

%macro monthly_check(month_yyyy,startdt,enddt);

data &month_yyyy. ;

set test;

where "&startdt."d <= OPEN_DATE <= "&enddt."d;

Difference = intck('MONTH',OPEN_DATE,REGISTER);

run;

proc freq data=&month_yyyy. ;

title '&month_yyyy. - Differences between open date and register';

table Difference;

run;

title;

%mend monthly_check;

%monthly_check(February2020,01Feb2020,29Feb2020);

%monthly_check(January2020,01Jan2020,31Jan2020);

Re: SAS Macro in title statement

Kurt_Bremser — Tue, 31 Mar 2020 11:51:50 GMT

If you want macro variables to resolve, you need to use double quotes; single quotes prevent any resolution of macro triggers.

Re: SAS Macro in title statement

Patrick — Tue, 31 Mar 2020 11:54:11 GMT

For macro variables to resolve they need to be in double quotes.

%macro monthly_check(month_yyyy,startdt,enddt);
  data &month_yyyy.;
    set test;
    where "&startdt."d <= OPEN_DATE <= "&enddt."d;
    Difference = intck('MONTH',OPEN_DATE,REGISTER);
  run;

  title "&month_yyyy. - Differences between open date and register";
  proc freq data=&month_yyyy.;
    table Difference;
  run;
  title;
%mend monthly_check;

%monthly_check(February2020,01Feb2020,29Feb2020);
%monthly_check(January2020,01Jan2020,31Jan2020);