topic Re: how to consider or get fixed effects information to obtain dependent variables. in SAS Programming

how to consider or get fixed effects information to obtain dependent variables.

JKCho — Fri, 19 Jul 2019 18:04:58 GMT

proc surveyreg data=crdsimple;
class sic fyear idvc ids loss;
model rating = logat roa lev idvc ids loss/ solution;

run;

data crd2;
set crdsimple;
rtmade = 16.8313718 -0.9310491*logat-1.0102761*roa+0.7764174*lev-2.4251711*idvc-0.4183952*ids+1.5549358*loss ;
run;

Hi!

What I am doing here is 1) to get coefficient estimates and 2) use these estimate to obtain dependent variables.

Since I used 2 fixed effect(sic and fyear), I may need to reconsider these 2 when calculating dependent variables again.

However, there is no output statement showing fixed effects and wonder how one can obtain dependent variables with fixed effects?

Simply, I need intercept so used proc survey instead of proc glm and, so far, I am satisfied with the outcome.

Calculated ratings(rtmade) are fairly similar to real ratings given in general and this makes me think that I need to consider fixed effects!!

Does anyone know how to consider fixed effects?

Plus, I have yearly effects and more... I may need a good and simple coding to put these effects. If not, I should put each year's effect manually, which is not recommended at all. (like this... If year=1999 then rtmade+some number for 1999... and do this multiple times)

Re: how to consider or get fixed effects information to obtain dependent variables.

PaigeMiller — Fri, 19 Jul 2019 18:20:37 GMT

Do you mean: how to use fixed effects to PREDICT dependent variables?

Do you mean how you can use SIC and FYEAR since they are categorical ?

Re: how to consider or get fixed effects information to obtain dependent variables.

JKCho — Fri, 19 Jul 2019 18:24:09 GMT

Sorry for this confusion.

I mean the second.
They are categorical so I need to add more effects by each SIC and each FYEAR after my getting DV value from my equation of RTMADE. I simply want to retrieve the values of each categorical effects.

Re: how to consider or get fixed effects information to obtain dependent variables.

PaigeMiller — Fri, 19 Jul 2019 18:29:36 GMT

You add SIC and FYEAR into the MODEL statement, since your code has already placed them into the CLASS statement.

Re: how to consider or get fixed effects information to obtain dependent variables.

JKCho — Fri, 19 Jul 2019 18:37:32 GMT

wow... that is it...
I was so curious...why it didn't have the info.
Besides, Do you also know by any change the coding to put these categorical effects?

Cuz I currently do not know it. I am thinking of doing like.... if year=1999 then rtmade+some number of 1999's year effect ... and do this multiple times)

Re: how to consider or get fixed effects information to obtain dependent variables.

PaigeMiller — Fri, 19 Jul 2019 18:42:17 GMT

Each year, and each SIC should have a regression coefficient estimated, which you can view with the SOLUTION option to the MODEL statement.

Re: how to consider or get fixed effects information to obtain dependent variables.

JKCho — Fri, 19 Jul 2019 18:58:04 GMT

My previous question was not that clear I intended.
I meant if there is a better code to put these coefficients in the equation,

rtmade = 16.8313718 -0.9310491*logat-1.0102761*roa+0.7764174*lev-2.4251711*idvc-0.4183952*ids+1.5549358*loss

to obtain ratings(there are many missing ratings so I needed to obtain coefficients to estimate dependent variables). However, there are so many categories. I simply asked if I can make another code instead of writing each SIC and FYEAR coefficients on my equation.

Re: how to consider or get fixed effects information to obtain dependent variables.

PaigeMiller — Fri, 19 Jul 2019 21:27:05 GMT

I have never done this with PROC SURVEYREG, but it works in PROC GLM and PROC REG, so I'm guessing it will work in PROC SURVEYREG. You add to the data set CRDSIMPLE records which contain the values you want to predict at (values of logat roa lev idvc ids loss sic fyear) but leave the dependent variable RATING missing. Then when you request predicted values from SURVEYREG with the OUTPUT command, the predicted RATINGS for all records (the ones which have a non-missing Y and the ones which have a missing Y) will be in this output data set.

Re: how to consider or get fixed effects information to obtain dependent variables.

JKCho — Sat, 20 Jul 2019 05:45:58 GMT

output p=pred was the one I want and proc scoring too. Thank you for your help!!!!