BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Mccracken
Calcite | Level 5

I have biomarker data from a group of subjects repeatedly sampled over time. I'm using PROC MIXED for the model, and Tukeys as a post hoc. How would I generate a connecting letters report from the Differences of Least Squares Means? I've seen macros for PROC GLIMMIX like %MULTI, and connecting lines. Does anyone know of a macro or script that will work with PROC MIXED instead? 

proc mixed data=data;
class age sex tp name;
model biomarker = age sex age*sex;
repeated  TP /  type=CSH r rcorr subject= name;
LSMEANS age / pdiff adjust=TUKEY;
LSMEANS age*sex / pdiff adjust=TUKEY;
LSMEANS sex / pdiff adjust=TUKEY;
run;
WeekWeightConnecting Letter
428.8693A
1230.959AB
1633.7827B
2040.0923C
1 ACCEPTED SOLUTION
3 REPLIES 3
PaigeMiller
Diamond | Level 26

You favorite internet search engine will find this:

 

A SAS macro for generating letter displays of pairwise mean ...

 

I don't know if it matches your problem as my company's firewall won't let me access it.

--
Paige Miller
Mccracken
Calcite | Level 5

Yes, I'm trying to find a macro like that but for PROC MIXED. According to the paper that macro only works with PROC GLIMMIX and I have to use PROC MIXED since I have repeating measures. 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 385 views
  • 2 likes
  • 2 in conversation