BookmarkSubscribeRSS Feed
Natalie
Calcite | Level 5

Dear all,

My Statistician showed me yesterday a very strange behavior of the PROC GENMOD and using the BY-variable.

When calculating LS-means, the PROC GENMOD showed combinations, which were not available in the one particular BY-Group in our input data set.

The output below shows for year=2009 three machines G1, G2 and G3, although in the raw data, in the year 2009 for the BY-GROUP STRATA=2 only G2 and G3 were available.

genmod-by.png

When applying WHERE-Statement to the input data set, PROC GENMOD worked fine.

genmod-where.png

Does anyone have an idea, how this behavior could be explained?

(The input data set and PROC GEMNOD calls are attached.)

Thank you in advance,

Natalie

4 REPLIES 4
SteveDenham
Jade | Level 19

I do not get the results presented for the by strata analysis.  My strata=2 analysis using by group processing looks exactly like the where strata=2 analysis, and like the results you present.  Could this be platform dependent?  I am running SAS 9.3 (32 bit) on a Windows XP platform.

Steve Denham

Natalie
Calcite | Level 5


Dear Steve,

thanks, that's interesting, I'm using SAS 9.2 on Windows (XP).

So it might be a bug in 9.2 version?

Natalie

SteveDenham
Jade | Level 19

I concur that it is a 9.2 problem.  I ran it on the same machine using SAS 9.2 and duplicated your output  The estimates and standard errors are correct in value, but are mislabeled throughout.  I looked at the problem notes, and it appears there were some problems with the.aggregate option when using by=, but it looked like that was an 8.2 problem that had been fixed going forward.  You really need to get in touch with Tech Support on this one.  There may be a hotfix available.

Steve Denham

Natalie
Calcite | Level 5

Hi Steve,

You are right, it's the 9.2 problem.

I contacted the SAS technical support and they replied that unfortenatley there is no hotfix available for 9.2.

But apparently the problem is solved in 9.3 version.

Natalie

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1366 views
  • 0 likes
  • 2 in conversation