topic Re: Macro for pairwise comparisons connecting letter with PROC MIXED in SAS Programming

Macro for pairwise comparisons connecting letter with PROC MIXED

Mccracken — Wed, 28 Aug 2024 16:27:28 GMT

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;

Week	Weight	Connecting Letter
4	28.8693	A
12	30.959	AB
16	33.7827	B
20	40.0923	C

Re: Macro for pairwise comparisons connecting letter with PROC MIXED

PaigeMiller — Wed, 28 Aug 2024 17:03:49 GMT

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.

Re: Macro for pairwise comparisons connecting letter with PROC MIXED

Mccracken — Wed, 28 Aug 2024 17:07:56 GMT

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.

Re: Macro for pairwise comparisons connecting letter with PROC MIXED

PaigeMiller — Wed, 28 Aug 2024 17:16:40 GMT

PROC MIXED plus PROC PLM

https://communities.sas.com/t5/Statistical-Procedures/how-to-get-pdmix800-sas-for-letter-displays-of-pairwise-mean/m-p/83560#M4023