%let startYear ="1Jul2015:0:0:0"dt; %let newstarYear=%sysfunc(putn(%sysfunc(intnx(dtyear,&startYear,1,s)),datetime19.)); %put &newstarYear; ... View more

If date1 of 3 or more later record in each ID is larger than date2, in such condition, you could try hash.   data want;    if 0 then set have(keep=id date1);    if _n_=1 then do;     declare hash h(dataset:'have(keep=id date1 rename=(date1=_date1))',multidata:'y');     declare hiter hi('h');       h.definekey('id');       h.definedata('_date1');       h.definedone();     end;     set have;     by id notsorted;     if first.id then do;        rc=hi.setcur();        do while (rc=0);          if _date1>date2 then do;            temp=_date1;                  goto day;          end;          rc=hi.next();     end;     day: day=temp-date2;     end;     drop temp _date1 rc; run;   ... View more

In order to count 5% of outliers, you first have to calculate 97.5% and 2.5% quantile, x value which is greater than 97.5% quantile or less than 2.5% quantile is identified as outlier, then count frequence.    %let N = 100; data CN(keep=x); call streaminit(12345); do i = 1 to &N; if rand("Normal", 100, 16) then x = rand("Normal", 100, 4); else x = rand("Normal"); output; end; run;   proc univariate data=cn; var x; output out=outlier pctlpts=2.5 97.5 pctlpre=x pctlname=pct25 pct975; run;   data want; set cn; if _n_=1 then set outlier; if x>xpct975 or x<xpct25 then flag=1; else flag=0; run; proc freq data=want; table flag; run; ... View more

If I understand you correctly, you could try this: data test_dxcheck; set have; length flag $100; retain flag; array dx DX5-DX9; do i=1 to dim(dx); if dx(i)=:'493' then flag=catx(' ',flag,vname(dx(i))); end; drop i; run; ... View more

data have; input date : anydtdte.; format date mmddyys10.; cards; 12/10/2014 1/1/2015 9/30/2015 ; ... View more

Here is regular expression. data have; infile cards missover; input id phone &$200.; _phone=prxchange('s/(^\d+,\d+).*/$1/',-1,phone); cards; 1 0112976555559,2955940123,4072948756,4071453259 2 4072564138 3 3051485236,4078596321,4072483516 4 1254862,4075847456 ; ... View more