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



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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