topic Re: Selecting one admission per year in SAS Programming

Selecting one admission per year

analyst_work — Thu, 02 May 2019 17:35:11 GMT

I need to limit one admission per year, there can be multiple admissions for that one patient. I want to look across all admissions and then select one admission per year. Thank you!

Patient C	Adm 1	14-Jan-16	Include first admission
Patient C	Adm 2	6-May-17	Include (more than 365 days)
Patient C	Adm 3	5-Jun-17	Exclude (less than 365 days from Adm 2)
Patient D	Adm 1	14-Jan-16	Include first admission
Patient D	Adm 2	6-Jan-17	Exclude (less than 365 days from Adm 1)
Patient D	Adm 3	5-Jun-17	Include (more than 365 days from Adm 1)

Re: Selecting one admission per year

PeterClemmensen — Thu, 02 May 2019 17:29:02 GMT

You have two different date variables here. What dates are to be considered? The to date from adm1 and the from date from adm2?

Re: Selecting one admission per year

analyst_work — Thu, 02 May 2019 17:35:41 GMT

Updated the table above. Thanks!

Re: Selecting one admission per year

novinosrin — Thu, 02 May 2019 17:47:28 GMT

~~Hi @analyst_work Please review~~

~~Patient D~~	~~Adm 1~~	~~12-Jan-16~~	~~14-Jan-16~~	~~Include first admission~~
~~Patient D~~	~~Adm 2~~	~~6-May-17~~	~~6-Jan-17~~	~~Exclude (less than 365 days from Adm 1)~~

~~How is the number of days between 14-Jan-16 and 6-May-17 is less than 365?~~

EDITED: Please ignore this post

Re: Selecting one admission per year

analyst_work — Thu, 02 May 2019 17:37:20 GMT

Please see updated table above. Thanks!

Re: Selecting one admission per year

novinosrin — Thu, 02 May 2019 17:40:49 GMT

Hi @analyst_work Thank you



data have;
infile cards truncover;
input patient & $20. adm & $6. date :date9.;*  out_date :date9.;
format date date9.  ;*out_date date9.;
cards;
Patient C	Adm 1	14-Jan-16	Include first admission
Patient C	Adm 2	6-May-17	Include (more than 365 days)
Patient C	Adm 3	5-Jun-17	Exclude (less than 365 days from Adm 2)
Patient D	Adm 1	14-Jan-16	Include first admission
Patient D	Adm 2	6-Jan-17	Exclude (less than 365 days from Adm 1)
Patient D	Adm 3	5-Jun-17	Include (more than 365 days from Adm 1)
;




data want;
set have;
by patient;
retain d;
if first.patient then do; d=date;f=1;end;
else if intck('day',d,date)>365 then do;
d=date;
f=1;
end;
if f;
drop f d;
run;

Re: Selecting one admission per year

ballardw — Thu, 02 May 2019 17:51:24 GMT

@analyst_work wrote:

I need to limit one admission per year, there can be multiple admissions for that one patient. I want to look across all admissions and then select one admission per year. Thank you!

Patient C Adm 1 14-Jan-16 Include first admission

Patient C Adm 2 6-May-17 Include (more than 365 days)

Patient C Adm 3 5-Jun-17 Exclude (less than 365 days from Adm 2)

Patient D Adm 1 14-Jan-16 Include first admission

Patient D Adm 2 6-Jan-17 Exclude (less than 365 days from Adm 1)

Patient D Adm 3 5-Jun-17 Include (more than 365 days from Adm 1)

Any other rules? Is this supposed to be a random selection? First within period?

And do you actually have SAS date values or are your values currently character values that resemble dates?