Hi!
I have 2 cases in which I have 0 values in my dataset -
Case 1 -
Member Diagnosis Date Location Cost
1 dx1 8/3/2016 ER 5000
1 dx1 8/3/2016 ER 3652
1 dx1 8/3/2016 ER 0
Case 2 -
Member Diagnosis Date Location Cost
2 dx2 8/3/2016 Inpatient 7000
2 dx3 8/3/2016 ER 0
In Case 1, I want to delete the 0 observation since it is a duplicate of the one before it, except for the cost.
In Case 2, I don't want to delete the 0 value since it is unique.
This is what I want my output to look like -
Member Diagnosis Date Location Cost
1 dx1 8/3/2016 ER 5000
1 dx1 8/3/2016 ER 3652
2 dx2 8/3/2016 Inpatient 7000
2 dx3 8/3/2016 ER 0
What is the best way ot go about doing this? Thank you!
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
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.