data have;   input ID $ psa1 psa2 psa3 psadate1 :mmddyy10. psadate2 :mmddyy10. psadate3 :mmddyy10.; format psadate: mmddyy10.;   datalines; 1 0.1 0.1 1.5 3/05/2020 08/31/2020 08/05/2021 2 0.2 . . 3/05/2021 . . 3 3.3 0.1 . 3/05/2022 08/31/2022 . 4 0.2 0.5 5.5 3/05/2021 08/31/2021 08/05/2022 ; run;     /*mindate[i] carray the earliest date of psa GE 0.2;*/ data have1; set have; array pvalue psa1 - psa3 ; array pdate psadate1 - psadate3; array mindate mindt_psa1 - mindt_psa3;  mindate[1] = ifn(pvalue[1] GE 0.2, pdate[1], .);   do i = 2 to dim(pvalue);  if pvalue[i] GE 0.2 then mindate[i] = min(of mindate[i-1], pdate[i]) ; else mindate[i] = mindate[i-1];   end; format mindt_psa: MMDDYY10.; run;   /*minevent[i] carray the earliest BCR event date;*/   data have2; set have1; array pvalue psa1 - psa3 ; array pdate psadate1 - psadate3; array minevnet minevt_psa1 - minevt_psa3;   minevnet[1] = .; minevnet[2] = ifn(pvalue[1] GE 0.2 and pvalue[2] GE 0.2 , pdate[1], .);   do i = 3 to dim(pvalue);  if pvalue[i-1] GE 0.2  and pvalue[i] GE 0.2 then minevnet[i] = min(of minevnet[i-1], pdate[i-1]) ; else minevnet[i] = minevnet[i-1];   end; format minevt_psa: MMDDYY10.; run;   ... View more

You need using SAS (Unicode Support) to run your code.  ... View more

https://communities.sas.com/t5/SAS-Programming/Find-and-replace-line-feeds-0A-x-within-a-CSV-file/m-p/703783 ... View more

Using Powershell answered by ChatGPT:  Import-Csv -Path "C:\path\to\csv\file.csv" | Select-Object -First 500 | Export-Csv -Path "C:\path\to\csv\first500.csv" -NoTypeInformation ... View more

data have2 (drop=i); set have; by DummyID; if (first.DummyID or not last.DummyID) then do i = 1 to 1 + (first.DummyID and not last.DummyID); set have (keep=Enroll_beg_dt rename=(Enroll_beg_dt=nextval) ); end; if last.DummyID then nextval = .; run; data have3; set have2; dur = Enroll_end_dt - Enroll_beg_dt + 1; gap = nextval - Enroll_beg_dt; run; proc summary data = have3 nway; class DummyID; output out=want (DROP = _FREQ_ _TYPE_) max(gap)=maxgap sum(dur)=sumdur ; run; ... View more

How about this? data have1;   input a b c;   cards; 1 2 3 ; data have2;   input b c a;   cards; 4 5 6 ; proc sql; create table c as select * from have1 where 0 union select * from have2 ; quit; ... View more

How about combining Queries with Set Operators? Proc sql; create table anotinb as select * from A except select * from B; quit; proc sql;   create table bothinab as    select * from a    intersect    select * from b; quit; ... View more

In  your  browser,  move your mouse to the correspond EXCEL file icon, right click mouse,  and select 'Copy link address'.   Then you can copy the full url from clipbord. ... View more