topic Generate aq table with LSMEANS and SEM in Statistical Procedures

Generate aq table with LSMEANS and SEM

bionazm — Wed, 26 Jun 2024 16:36:49 GMT

I would like to generate a table with Lsmeans, SEM, and the P-value for a Proc GLM used for an experiment with 4 treatments. I am not sure what syntax to use.

Re: Generate aq table with LSMEANS and SEM

ballardw — Wed, 26 Jun 2024 17:37:48 GMT

Start by sharing your current code for Proc GLM.

Then tell which variables/effects you want LSMEANS output for and which specific P-values. The procedure can create multiple p-values depending on requests.

If this is to be a single "table" then likely that means creating output data set(s) and combining and selecting.

Re: Generate aq table with LSMEANS and SEM

bionazm — Mon, 01 Jul 2024 15:42:02 GMT

Thanks for getting back to me!

The experimental design has 4 increased doses of a supplement (0, 5, 10, and 20%) in poultry with 10 animals/pen and 5 pens/treatment.

Here the syntax I used:

proc GLM;
Class Pen TRT Sex;
Model par1 par2 par3 par4 =TRT;
lsmeans TRT/ pdiff;
means SHB / t lines;
run;

proc GLM;

Model par1 par2 par3 par4 =TRT TRT*TRT;

Run;

I am interested in having a table such this:

Parameter	Lsmean TRT	SEM	P-value	Linear	Quadratic
	0	5	10	20
par1
par2
par3
par4

Thanks!