topic Re: Calculating patietn days for each month using start and end dates in New SAS User

Calculating patietn days for each month using start and end dates

simkinm2 — Mon, 26 Aug 2019 15:25:42 GMT

I have some data in the following format

data testdate;
input admit_date discharge_date;
date = input(chardate,yymmdd10.);
return;
datalines;

6/29/2019 8/26/2019

12/27/2018 4/3/2019

;

I need to determine the number of patient days someone was admitted per month. For example,for the first row there would be 1 day for June 2019, 31 for July 2019, and 26 for August 2019. I have about 800 records and would love a way to automate this if possible. Thanks in advance!

Re: Calculating patietn days for each month using start and end dates

novinosrin — Mon, 26 Aug 2019 15:52:31 GMT

Hello @simkinm2 You didn't show us your expected output structure, but the logic is clear though

  
data testdate;
   input admit_date :mmddyy10. discharge_date :mmddyy10.;
   format _all_ mmddyy10.;
datalines;
6/29/2019    8/26/2019
12/27/2018   4/3/2019
;
data want;
set testdate;
d =admit_date;
do while(d<discharge_date);
 month_year=put(d,monyy7.);
 if month(d)=month(admit_date) then days=intnx('mon',d,0,'e')-d+1;
 else if month(d)=month(discharge_date) then days=day(discharge_date);
 else days=day(intnx('mon',d,0,'e'));
 output;
 d=intnx('mon',d,1);
end;
drop d;
run;

Re: Calculating patietn days for each month using start and end dates

Ksharp — Tue, 27 Aug 2019 11:58:36 GMT

  
data testdate;
   input admit_date :mmddyy10. discharge_date :mmddyy10.;
   format _all_ mmddyy10.;
datalines;
6/29/2019    8/26/2019
12/27/2018   4/3/2019
;
data temp;
 set testdate;
 n+1;
 do date=admit_date+1 to discharge_date;
  output;
 end;
run;
proc summary data=temp ;
by n date;
format date monyy7.;
output out=want ;
run;

Re: Calculating patietn days for each month using start and end dates

novinosrin — Tue, 27 Aug 2019 11:59:59 GMT

@Ksharp slick idea Sir 🙂 Nice and neat!