How do you code for research firms in SAS using compustat data?

Start with example code?

Best,

Joost

Hi! I am trying to get to 71,732 firm-year observations from NYSE and AMEX from 1962-1991 and I am coming up short. I thought potentially including research firms coded fyr=0 would add to the observations which did but not significantly enough. I am at 67,272 observations and not sure where I’m going wrong. Any help would be great! Thanks!

Here is my code:

data sasdata.trial;
set comp1.funda;
where INDFMT = ‘INDL’ AND DATAFMT = ‘STD’ AND POPSRC = ‘D’ AND CONSOL = ‘C’ AND (1961<fyear<1992)
and (exchg=11 or exchg=12) and fyr>=0;
KEEP gvkey sich fyear prcc_c csho ceq tstkp dvpa ni dvp datadate
msa recta dvc at cusip exchg;
run;

hi,

I didn’t check this, but it could be that the exchg variable is the current exchange the firm is listed on. If a firm was trading on Nyse or Amex and got delisted, that exchg variable may be set to something else (even for firm-years when it was listed there). Other than that I wouldn’t know because the exchg is basically the only constraint of the query.

Hope this helps,

Joost