I use the method group by to obtain stock volitality from crsp daily stock file. But my problem is that the observations go from 36 thousand to more than 1 billion. And there are many same results, with same lpermno, same fyear and same lstkvol. I couldn't find the reason. Thanks! proc sql; create table exe_ccn_lancmpcrsp as select a.*,std(b.RET)*sqrt(250) as lstkvol "lag annualized stock volitality" from exe_ccn_lancmpllq a left join crspa.DSF b on a.lpermno=b.permno and b.DATE between a.lfybegdt and a.lfyenddt group by a.lpermno,a.fyear having sum(b.RET is not missing)>1; quit;   ... View more

I tried all the solutions on the internet and failed. Hope you could help me with the case. The url link of the data: http://scholar.rhsmith.umd.edu/sites/default/files/sbrown/files/pins_vdj_ann.sas7bdat.gz?m=1467366849 My code: libname pinlib "E:\data\PIN_Stephen_Brown"; filename target "%sysfunc(pathname(pinlib))/test.sas7bdat"; filename fromzip ZIP "E:\data\PIN_Stephen_Brown\test.sas7bdat.gz"; data _null_; infile fromzip lrecl=256 recfm=F length=length eof=eof unbuf; file target lrecl=256 recfm=N; input; put _infile_ $varying256. length; return; eof: stop; run; It reports the error message as : ERROR: The file "E:\data\PIN_Stephen_Brown\test.sas7bdat.gz" exists and is not a zip file. The output file must be a zip file. I appreciate your help very much if you could help me with this case. Your comment is awaiting moderation. ... View more