topic Macro variable as a predictor in SAS Programming

Macro variable as a predictor

Polina_UH — Wed, 20 May 2020 12:39:09 GMT

Dear all,

I'm trying to run multiple models in a macro using macro variable as a predictor. However, instead of 14 models I get one model with 14 predictors plus covariates. Here is my code:

%let biomarker = TotalC nonHDLC RemnantC VLDLC ClinicalLDLC LDLC HDLC TotalTG VLDLTG LDLTG HDLTG TotalPL VLDLPL LDLPL;

%macro poisson ;
proc genmod data = met;
ods output ParameterEstimates=parm;
model comorbidity = &biomarker gestational_age birth_year child_sex/ alpha=0.0017 dist=poisson; run;
%mend poisson;

%poisson

Here is my output:

I would really appreciate an advice how to modify my code to obtain 14 models with each of the biomarkers as a separate predictor plus covariates.

Re: Macro variable as a predictor

PaigeMiller — Wed, 20 May 2020 12:46:38 GMT

You need a macro %DO loop.

%let biomarker = TotalC nonHDLC RemnantC VLDLC ClinicalLDLC LDLC HDLC TotalTG VLDLTG LDLTG HDLTG TotalPL VLDLPL LDLPL;

%macro poisson ;
     %do i=1 %to %sysfunc(countw(&biomarker));
        %let thisvar=%scan(&biomarker,&i,%str( ));
        proc genmod data = met;   
        ods output ParameterEstimates=parm&i;
        model comorbidity = &thisvar gestational_age birth_year child_sex/ alpha=0.0017 dist=poisson;
        run;
    %end;
%mend poisson;
%poisson

Re: Macro variable as a predictor

Polina_UH — Wed, 20 May 2020 12:52:47 GMT

Thank you so much, it worked!