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-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

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
  • 797 views
  • 2 likes
  • 2 in conversation