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;