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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.