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.        ... View more

Dear SAS experts,   I'm running multiple models in macro and I have to create combined table of results. I added this statement to my macro thinking that I will just simply merge the outputs from different models and then start working on the table.   ods output solutionf;   The problem is that the name of the dependent variable is in different output modelinfo, so I added this statement to my model   ods output modelinfo; ods output solutionf;   I'm trying to figure out how to merge these two for all of the models I'm running in macro such that my table with final results would indicate estimates for each of the dependent variables correctly, but I can't find anything.   Or maybe my line of thinking is incorrect and there are other (I assume more optimal) ways to do that?    Thank you in advance!    ... View more

Dear SAS experts, may I ask for your help again...   I need to run mixed models with hundreds of metabolites as the outcomes. I created this macro variable:   193 %put &biomarker; XXLVLDLP XXLVLDLL XXLVLDLPL XXLVLDLC XXLVLDLCE   Proc mixed for each of the metabolites individually works   proc mixed data=met method=ML; class final_id bmi_cat; model XXLVLDLP=bmi_cat gw cohort/ solution ddfm=satterthwaite cl alpha=0.001; random intercept time/ subject=final_id type=un; repeated /subject=final_id type=ar(1); run;   Macro for proc glm works too.   %macro glm; proc glm data=met; model &biomarker=maternal_age/ clparm noint; ods output ParameterEstimates=dPara; quit; run; %mend glm;   But when I try to run this macro for proc mixed    %macro mixed; proc mixed data=met method=ML; class final_id bmi_cat; model &biomarker = bmi_cat gw cohort/ solution ddfm=satterthwaite cl alpha=0.001; random intercept time/ subject=final_id type=un; repeated /subject=final_id type=ar(1); run; %mend mixed;   it gives me this mistake   1 proc mixed data=met method=ML; class final_id bmi_cat; model &biomarker = bmi_cat gw - 22 200 1 ! cohort/ solution ddfm=satterthwaite cl alpha=0.001; random intercept time/ subject=final_id 1 ! type=un; repeated /subject=final_id type=ar(1); ods output solutionf=a; run; NOTE: Line generated by the macro variable "BIOMARKER". 1 XXLVLDLP XXLVLDLL XXLVLDLPL XXLVLDLC XXLVLDLCE -------- 73 ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, *, -, /, :, @, _CHARACTER_, _CHAR_, _NUMERIC_, |. ERROR 200-322: The symbol is not recognized and will be ignored.   I would really appreciate if you could let me know what I'm doing wrong...        ... View more