BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phil_NZ
Barite | Level 11

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:

Phil_NZ_0-1620193122098.png

 

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.

 

 

 

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION
1 REPLY 1

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 757 views
  • 1 like
  • 2 in conversation