Hi
I am still plugging away on the readmits program and I figured it out but I want to remove multiple readmits for the same patient's episode. If I use the following code, it works but it removes all entries for a chart number when really I only want to remove when the same chartno with the same admit date is duplicated. So if the same chart number had a different admit date I don't want it removed.
data single dup;
set temp;
by chartno;
if first.chartno and last.chartno then output single;
else output dup;
run;
So is it possible to do have a first observation with two fields like first.chartno admdate and last.chartno admdate? Thanks.
I hope, this will help you
data single dup;
set temp;
by chartno admit_date;
if first.admit_date then output single;
else output dup;
run;
Thanks,
jagadish
Please try
data single dup;
set temp;
by chartno admit_date;
if first.admit_date and last.admit_date then output single;
else output dup;
run;
Thanks,
Jagadish
Thanks so much Jagadish but that didn't work. I had a case with 3 readmits noted for one chart number, 2 were the same admit date and the third wasn't but the code wiped out all but one.
Any other suggestions? Thanks so much.
I hope, this will help you
data single dup;
set temp;
by chartno admit_date;
if first.admit_date then output single;
else output dup;
run;
Thanks,
jagadish
Hi
Thanks so much, that seems to have worked!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.