macro code for mixed model

[peiy5920]

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

SM

SP

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.

[ChrisNZ]

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

[peiy5920]

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

[blueskyxyz · Accepted solution]

/*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);

[peiy5920]

Thank you for your examples. It is helpful!

[blueskyxyz]

😊 welcome.

[blueskyxyz]

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

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

[peiy5920]

Thank you for your information.