About jiaxinyang

PaigeMiller · ‎10-28-2019

You have class variables that are not in the model. Delete the CLASS statement, try it again. OR Add the class variables into the model, and get rid of the BY statement, try it again.

jiaxinyang · ‎10-09-2019

The codes worked. Thanks a lot.

PGStats · ‎10-02-2019

Try something like this: proc sql; create table want as select * from myDataset group by sid2d, fyear having count(*) >= 10; quit;

jiaxinyang · ‎10-02-2019

Hi Paige Miller, I wasn't able to use NMISS as I cannot find any similar examples. Here are what I have in my dataset. The year identifier -- fyear, the company identifier -- gvkey and the variable interested -- txt. I want the sum of txt over a five year period (year t to year t-4) and require at least three consecutive years of non-missing data. Could you please let me know what codes I need to use or give me some examples I can refer to? Thanks a lot. Jiaxin

Online Status	Offline
Date Last Visited	‎11-07-2019 12:34 PM

Find the residuals from a firm fixed effects regression

Re: sum of a variable for each firm over a five-year window

Re: sum of a variable for each firm over a five-year window

Re: sum of a variable for each firm over a five-year window

Re: sum of a variable for each firm over a five-year window

sum of a variable for each firm over a five-year window

Re: SUM a variable with BY command over a five-year horizon

Eliminate observations for certain conditions

Re: SUM a variable with BY command over a five-year horizon

Re: SUM a variable with BY command over a five-year horizon

Re: Find the residuals from a firm fixed effects regression

Re: sum of a variable for each firm over a five-year window

Re: Eliminate observations for certain conditions

Re: SUM a variable with BY command over a five-year horizon