How to use absorb statement properly. ?

Phil_NZ — Wed, 05 May 2021 05:42:26 GMT

Hi all SAS Users,

When facing the problem of

Number of levels for some effects > 32767

when using proc GLM, after reading this white document, I think it is good to use the absorb statement because from the description, I understand:

absorb id;
class time;

and

class id time;

will generate the same result (just the difference that the former will not display the statistics for dummy id).

I try to apply to my case as below:

proc glm data=merge_treat_con;
    ABSORB TYPE;
    class yr;
    model wROE= pt TOT_ASS_TUR wFIRM_SIZE LNGDP UNEMPLOYMENT INFLATION 
		 wLEVERAGE yr/solution ss3;
run;
quit;

while TYPE is a character variable and yr is a numeric variable.

Some examples of Type is as below:

And SAS announced a warning

WARNING: Formatted ABSORB values not sorted in ascending sequence.

I am wondering what is the fix for this issue? I really appreciate if you can give it a look.

Many thanks and warmest regards.

Re: How to use absorb statement properly. ?

ChrisNZ — Wed, 05 May 2021 07:19:18 GMT

Have you seen this Usage Note?

topic How to use absorb statement properly. ? in SAS Programming

How to use absorb statement properly. ?

Re: How to use absorb statement properly. ?