Help with managing GLM output results

[kayne]

Hi guys!

I have been tasked to create macros to run PROC GENMOD (given macro name as %genmod) in iterations so as to allow SAS to select variables for me.

%if i=1;

%do &genmod &until &pvalue>0.05....

Essentially, i will obtain the final type3 wald results after all the iterations. However, I will love to obtain and see the type3 wald results for each iterations as well.

I have been pulling my hair to figure how to incorporate a macro/data step. I tried to manipulate ODS OUTPUT but still fail to obtain a favourable result.

Thank you in advance for your help, kind person(s).

[Reeza · Accepted solution]

Have you figured out how to capture the data for a single iteration?

Once you have that then add an append to your loop so you keep the table for reach iteration.

[kayne]

Hi Reeza,

Do I attach the PROC APPEND code inside the GLM macro or the GLM LOOP macro?