topic Re: Macro within a Macro in SAS Programming

Macro within a Macro

saslove — Mon, 10 Dec 2018 21:11:07 GMT

I need to read in the number of treatment groups and the unique count associated with each treatment in a macro. This unique number of cohort will be my denominator at a later step to create an adverse event table.

proc sort data=adae out=adae_subs (keep=subject cohort) nodupkey; by subject; run;
proc freq data=adae_subs nlevels noprint;
tables cohort/out=cohortct outcum;
run;

data cohortct;
set cohortct;
rename count=cohortct;
run;

proc sql;
select distinct cohort
into :coh1 - :coh3
from cohortct;
quit;

%macro coh(coh=,num=);
data test;
set cohortct;
where cohort="&coh.";
call symputx ("cohortct&num.",COHORTCT);
run;
%mend coh;
%coh (coh=&coh1,num=a);%coh (coh=&cohb,num=b);%coh (coh=&cohc,num=c);
%put &cohortcta;%put &cohortctb;%put &cohortctc;

I get the following warning

WARNING: Apparent symbolic reference COHORTCTB not resolved.

Re: Macro within a Macro

r_behata — Mon, 10 Dec 2018 21:31:39 GMT

Post the log.

Is the macro call %coh (coh=&cohb,num=b) resulting in any records in the dataset test ?

Re: Macro within a Macro

Reeza — Mon, 10 Dec 2018 22:02:33 GMT

Macro variable scope. Look at the third aprameter in CALL SYMPUTX() and use it to define your macro variables as global macro variables.

You may also want to look into CALL EXECUTE.

@saslove wrote:

I need to read in the number of treatment groups and the unique count associated with each treatment in a macro. This unique number of cohort will be my denominator at a later step to create an adverse event table.

proc sort data=adae out=adae_subs (keep=subject cohort) nodupkey; by subject; run;
proc freq data=adae_subs nlevels noprint;
tables cohort/out=cohortct outcum;
run;

data cohortct;
set cohortct;
rename count=cohortct;
run;

proc sql;
select distinct cohort
into :coh1 - :coh3
from cohortct;
quit;

%macro coh(coh=,num=);
data test;
set cohortct;
where cohort="&coh.";
call symputx ("cohortct&num.",COHORTCT);
run;
%mend coh;
%coh (coh=&coh1,num=a);%coh (coh=&cohb,num=b);%coh (coh=&cohc,num=c);
%put &cohortcta;%put &cohortctb;%put &cohortctc;

I get the following warning

WARNING: Apparent symbolic reference COHORTCTB not resolved.

Re: Macro within a Macro

Kurt_Bremser — Mon, 10 Dec 2018 22:02:49 GMT

I guess you also get a WARNING for cohb, as that macro variable is never defined in your code; I think you wanted to use coh2 instead. Same with cohc, which should be coh3.

Re: Macro within a Macro

Reeza — Mon, 10 Dec 2018 22:09:11 GMT

Should your macro calls be &cohb or &coh2?
It seems like you may be mixing counters?

Re: Macro within a Macro

ShiroAmada — Tue, 11 Dec 2018 00:24:04 GMT

In this statement call symputx ("cohortct&num.",COHORTCT);

COHORTCT is a variable that does not exist in your proc freq output dataset named COHORTCT


data adae_subs ;
set sashelp.class(rename=(weight=cohort));
run;


proc freq data=adae_subs nlevels noprint;
tables cohort/out=cohortct(rename=(count=cohortct)) outcum;
run;