Issue with proc panel reference level result -

[sjpark]

Hello SAS users,

It should have been here..but I uploaded it like below

https://communities.sas.com/t5/SAS-Studio/Issue-with-proc-panel-reference-level-result-being-generat...

thanks in advance.

[sjpark]

Hello, SAS Community.

I am conducting an analysis on interactions with a moderating effect between categorical variables which is being implemented through an interaction term(CEOHOME*EvalDummy). However, I am encountering an issue where only one interaction with reference level all results are being generated. Typically, in a panel regression model, the reference category is omitted in the results, but in my model, no. I would appreciate any assistance on how to solve this issue.

here's my code.

DATA IMPORT1;

SET IMPORT;

career_M=career;

academic_M=academic;

ceoterm_M=ceoterm*evaldummy;

ceoage_M=ceoage*evaldummy;

ceosex_M=ceosex;

ceohome_M=ceohome;

RUN;

PROC SORT DATA=IMPORT1;

BY entityname YEAR;

RUN;

PROC PANEL DATA=IMPORT1;

ID  entityname YEAR;

CLASS CAREER academic CEOHOME CEOSEX TYPE;

MODEL 'eval_100'N= career academic ceohome ceoterm ceoage ceosex  

career*evaldummy academic*evaldummy ceohome*evaldummy ceoterm_m ceoage_m ceosex*evaldummy 

evaldummy type comemp comasset_ln comage/RANONE;

RUN;

Thank you.

[sjpark]

I WILL USE DATA SET WHICH CAN BE USED EASILY.

[Kurt_Bremser]

But you should post your example data as a DATA step with DATALINES. Such a piece of code can easily be copy/pasted into the program editor and submitted (and leave no questions about real content and variable attributes), while the Excel file needs to be downloaded (which is often prohibited in corporate environments for security reasons), then uploaded to the SAS environment, and finally imported (where the vagaries of PROC IMPORT often cause the dataset to be different from yours).

[Kurt_Bremser]

No problem, I merged your posts in here.