topic Re: PROC GLM and number of levels >32767 in Statistical Procedures

PROC GLM and number of levels >32767

Phil_NZ — Thu, 18 Feb 2021 22:46:13 GMT

Hi all, today, when I try to run a regression by using PROC GLM, I face this problem

ERROR: Number of levels for some effects > 32767.

My code is

libname input 'C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\datasas' access=readonly;
proc copy inlib=input outlib=work mt=data;
run;

proc glm data=work.merge_treat_con;
    class type yr;
    model wtot_ass_tur = pt type yr/solution ss3;
run;
quit;

I am wondering what does this mean regarding the word "levels" mean in this error? And how come we overcome this limitation or any alternative solution?

Warmest regards.

Re: PROC GLM and number of levels >32767

StatDave — Thu, 18 Feb 2021 22:55:19 GMT

The "levels" of a variable just means the distinct values of the variable in the data. From this and your previous post about "fixed effects" I assume you mean a model which avoids estimation of parameters for the many levels in that variable. You can do that using the ABSORB statement. Details on this and other fixed effects models are in the book "Fixed Effects Regression Methods for Longitudinal Data Using SAS" (Allison, P., SAS Institute, 2005).

Re: PROC GLM and number of levels >32767

Phil_NZ — Thu, 18 Feb 2021 23:09:59 GMT

Hi @StatDave

Thank you for your reply. However,is there any accessible source online for this book (like SAS documents) or I need to buy this book, I try to search from my school's library but there is no book like this available.

I did search via your link previously from this discussion(https://communities.sas.com/t5/Statistical-Procedures/Fixed-effect-regressions/td-p/171442)

but it does not work now

Warm regards.

Re: PROC GLM and number of levels >32767

Reeza — Thu, 18 Feb 2021 23:06:51 GMT

CLASS statement is for categorical variables. It's saying one of your categorical variables, type or YR has more than 32k unique values which means it's likely not categorical and doesn't belong in the CLASS statement.

When learning a procedure, first work through the examples in the documentation, then search on lexjansen.com for that procedure and the term workshop or tutorial to learn about it.

Re: PROC GLM and number of levels >32767

StatDave — Fri, 19 Feb 2021 00:05:20 GMT

I believe you can still find it if you do an internet search

Re: PROC GLM and number of levels >32767

Phil_NZ — Sun, 21 Feb 2021 22:08:36 GMT

Hi @StatDave

I promise that I already searched for a while but there is no pdf version available.

Is there any help from the SAS community...I really want to learn and broaden my knowledge.

Warmest regards.

Re: PROC GLM and number of levels >32767

Reeza — Mon, 22 Feb 2021 16:43:00 GMT

Is this not the correct book?
https://www.amazon.com/Fixed-Effects-Regression-Methods-Longitudinal/dp/1590475682

Re: PROC GLM and number of levels >32767

StatDave — Mon, 22 Feb 2021 17:12:38 GMT

That's the one.