How about this. Data have; input PatientID ATC $ prescription_date:date9. entrance:date9.; format prescription_date entrance date9.; datalines; 1 drugA 07JAN2019 09JAN2019 1 drugA 10FEB2018 09JAN2019 1 drugA 28DEC2018 09JAN2019 1 drugX 06DEC2018 06DEC2018 2 drugB 01OCT2018 07JAN2019 2 drugB 07JAN2019 07JAN2019 3 drugC 09NOV2018 08NOV2018 3 drugC 12DEC2018 08NOV2018 3 drugC 12JAN2019 08NOV2018 ; run; proc sort data=have; by PatientID ATC; run; data want; set have; by PatientID ATC; retain cnt Flag; if first.PatientID then Flag=0; if first.ATC then cnt=0; if prescription_date<=entrance and intck('year',prescription_date,entrance)<=2 then cnt+1; if last.ATC and cnt>=2 and Flag=0 then Flag=1; if last.PatientID then output; keep PatientID Flag; run; ... View more

The OUTPUT statement is allowed in the DO block. SET statement is specifies an input data set in the data step. Not in proc step. ... View more

How about this? data have; do num=100, 101, 3300; output; end; run; data want; set have; temp=mod(num,100); new=ifn(temp=0,num/100,num); drop temp; run; /* If you want to store the result in the same variable again, the following data step is simpler. */ data want; set have; if mod(num,100)=0 then num=num/100; run; ... View more

Yes, that's correct. The datasets in the WORK library are temporary datasets, and the datasets in the other libraries are permanent datasets. ... View more

try this %Macro MDivide(in=, out=, cnt=); data _null_; dsid=open("&in",'I'); if dsid>0 then do; nobs=attrn(dsid,'nlobsf'); call symputx('nobs',nobs); rc=close(dsid); call symputx('div',ceil(nobs/&cnt)); end; run; %do i=1 %to &cnt; %let fstobs=%eval((&i-1)*&div+1); %let getobs=%eval(&i*&div); data &out&i; set &in(firstobs=&fstobs obs=&getobs); run; %end; %Mend; /* example */ %MDivide(in =sashelp.baseball ,out=work.outds ,cnt=10);       ... View more

https://docs.github.com/en/search-github/getting-started-with-searching-on-github/understanding-the-search-syntax This says use "NOT".   This is a SAS community, so ask Github about Github. ... View more

data _null_; dt=lowcase('01JAN2022'); run; or   %let dt=%lowcase(01JAN2022); ... View more