topic Re: macro code for mixed model in SAS Programming

macro code for mixed model

peiy5920 — Sun, 24 May 2020 16:40:16 GMT

Hi,

My table like this

outcomes intervention time for control time for intervention p

Beta(s.e.) Beta(s.e.) Beta(s.e.)

SCE

SCMT

my sas code is

proc mixed data=Scores covtest;
class Subject_ID;
model SCE=intervention time intervention*time/solution;
random intercept /subject=Subject_ID;
run;

I want to use macro to create the table. I checked the ODS table names in mixed mode, but I still have no idea that how to start. Can someone give me some suggestions? Thanks in advance.

Re: macro code for mixed model

ChrisNZ — Mon, 25 May 2020 02:30:58 GMT

Your explanations are unclear. To me at least. What data do you have? What data do you want? What do you want to automate?

Re: macro code for mixed model

blueskyxyz — Mon, 25 May 2020 10:22:36 GMT

/*take an example*/ data heart; set sashelp.heart; subject=strip(put(_n_,best.)); if n(AgeAtDeath,AgeAtStart)=2 then livetime=AgeAtDeath-AgeAtStart+1; run; ***1.to see which stat you need to output in log and result window; ods trace on; proc mixed data=heart covtest; class Weight_Status BP_Status Subject; model livetime=Weight_Status BP_Status Weight_Status*BP_Status/solution; random intercept /subject=Subject; run; ods trace off; ***2.output the datasets; ods output Tests3=Tests3 ClassLevels=ClassLevels; proc mixed data=heart covtest; class Weight_Status BP_Status Subject; model livetime=Weight_Status BP_Status Weight_Status*BP_Status/solution; random intercept /subject=Subject; run; ***use macro; %macro mixed(var=); ods output Tests3=Tests3 ClassLevels=ClassLevels; proc mixed data=heart covtest; class Weight_Status BP_Status Subject; model &var=Weight_Status BP_Status Weight_Status*BP_Status/solution; random intercept /subject=Subject; run; %mend; %mixed(var=a); %mixed(var=b);

Re: macro code for mixed model

blueskyxyz — Mon, 25 May 2020 10:30:58 GMT

reference : https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_mixed_sect031.htm

some advices:
1.see the example in the user guide
2. list the statistics you need and sample datasets

Re: macro code for mixed model

peiy5920 — Wed, 27 May 2020 20:22:46 GMT

Thank you for your examples. It is helpful!

Re: macro code for mixed model

peiy5920 — Wed, 27 May 2020 20:24:01 GMT

Thank you for your information.

Re: macro code for mixed model

peiy5920 — Wed, 27 May 2020 20:27:46 GMT

I already solved my problem. I will try to put more detailed information about my question. I'm sorry.

Re: macro code for mixed model

blueskyxyz — Thu, 28 May 2020 05:14:48 GMT

😊 welcome.