Hello,   I know that is not the answer  because i didn't understood correctly what you meen with 30 days. But...... Maybe it help you    best regards,   /* order the data */ proc sort data=have; by id date; run; /* get the patient ids */ data idS; set have; by id date; format date prev_date date9. days 8.; retain confirmation 'N' total_days 0; if first.id then do; confirmation='N'; total_days=0; end; prev_date=lag1(date); days=intck('DAY',prev_date,date); if strip(disease) ne '' then confirmation='Y'; if confirmation eq 'Y' then total_days=sum(total_days,days); *if last.id and confirmation eq 'Y' and total_days ge 30 then output; *keep id; run; data want; merge ids(in=a) have(in=b); by id; if a and b; run;   ... View more

Hello, This litle script will help you to find any informat in the future %let STR_TO_FIND=%str(2/8/2015 0:00:00); data find_informat;     length source $ 100;     format result datetime.;     set sashelp.vformat;     where fmttype eq "I";     source_str="&STR_TO_FIND.";     result=inputn(source_str,fmtname);     if result ne .;     keep source_str result fmtname; run; Best regards, ... View more

Hello, There is so many ways to acomplish the desired output, here another example data _null_;       length list $ 200;       tickets="A202;A104;A021;A124;";       count=0;       list="";       do j=1 to count(tickets,";")+1;             elem=strip(scan(tickets,j,";"));             if findw(list,elem,' ', 'R') eq 0 and elem ne "" then do;                   list=catx(" ",list,elem);                   count=count+1;             end;       end;       put count=; run; ... View more

How about using HttpRequestObject (Ajax) to interact with SAS and using Sessions to keep the Variable Value between interactions? See links bellow with the puzzle parts: https://support.sas.com/resources/papers/proceedings10/014-2010.pdf SAS Stored Processes: Sessions ... View more