data sample; input count; datalines; 1.99999 2.0005 99.0001 1023.9999999 104 ; run; data smpl2; set sample; cc=(scan(count,2,".")); if cc="" then dcount=0; else dcount=length(cc); drop cc; run;
... View more
proc sort data=first; by cusip date_crsp ; run; proc sort data=second; by cusip date_crsp ; run; data final; merge first(in=a) second; by cusip date_crsp ; if a; run; it works
... View more
use full code proc sort data=dsn; by id date; run; data dsn22; set dsn; by id date; if first.date then cnt=1; else cnt+1; if cnt <=2; drop cnt; run;
... View more
