topic Re: Is there an option to add the N statistic onto PROC MIXED? in Statistical Procedures

Is there an option to add the N statistic onto PROC MIXED?

Buzzy_Bee — Wed, 08 Sep 2021 20:14:21 GMT

On this instructional document about PROC MIXED:

https://www.pharmasug.org/proceedings/2021/SA/PharmaSUG-2021-SA-062.pdf

They demonstrate the example below to create an output that shows Least Square Means and columns for Estimate, Standard Error, DF, Lower and Upper. I need all of those, but I also want the N statistic. Does anyone know if there is an option that can be added in so I can get N on this output please? Thanks.

ods output lsmeans=pb_lsmean diffs=pb_lsdiff;
 proc mixed data=qlqc2 method=reml covtest empirical;
by param;
class subjid trt visit;
model chg=base trt visit trt*visit;
random intercept/ subject=subjid;
repeated visit/ subject=subjid type=ar(1);
lsmeans trt*visit/ cl pdiff;
 run;

Re: Is there an option to add the N statistic onto PROC MIXED?

data_null__ — Wed, 08 Sep 2021 20:42:37 GMT

Consider displaying Univariate(PROC MEANS) and MIXED statistics in rows.

Re: Is there an option to add the N statistic onto PROC MIXED?

Rick_SAS — Wed, 08 Sep 2021 20:44:56 GMT

Add the NObs table to your ODS OUTPUT statement:

ods output lsmeans=pb_lsmean diffs=pb_lsdiff nobs=pb_nobs;

Re: Is there an option to add the N statistic onto PROC MIXED?

Buzzy_Bee — Thu, 09 Sep 2021 07:57:16 GMT

That only shows me the number of observations in the data set though, which Proc Mixed already does by default. What I mean is, I need the N statistic. So in the LSM table where it shows Treatment Drug A and the Estimate, DF etc, I need an N column in there that would tell me there were say 100 for Drug A, and 120 for Drug B.
The Proc Means procedure shows N, so currently I'm creating a Proc Mixed followed by Proc Means to generate all of the statistics I need. But I wanted to create a nice, tidy table that shows them all together that I can easily copy and paste onto an MS Word document.

Re: Is there an option to add the N statistic onto PROC MIXED?

Buzzy_Bee — Thu, 09 Sep 2021 07:59:24 GMT

I'm not sure what you mean by this. Industry convention requires statistics to be shown in tables where each statistic has a vertical column that displays the results and the treatments are listed horizontally in the table. If I displayed it vertically, no one would be able to read it or use in their reports.

Re: Is there an option to add the N statistic onto PROC MIXED?

SteveDenham — Wed, 22 Sep 2021 18:39:19 GMT

You are going to have to merge the PROC MEANS output with the PROC MIXED output. PROC SQL is probably the best tool for that.

SteveDenham