topic Re: Help with managing GLM output results in SAS Programming

Help with managing GLM output results

kayne — Wed, 29 Jul 2015 16:04:06 GMT

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).

Re: Help with managing GLM output results

Reeza — Wed, 29 Jul 2015 16:50:04 GMT

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.

Re: Help with managing GLM output results

kayne — Thu, 30 Jul 2015 03:14:25 GMT

Hi Reeza,

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