BookmarkSubscribeRSS Feed
marilyn934
Calcite | Level 5
I need to figure out the earliest diagnosis that a patient has given that each patient has many encounters and 10 diagnosis codes for each encounter. The catch is that we only want to look at certain diagnosis codes. Does anyone have any ideas? I already sorted by PatientID and encdate. Just looking at diag1 isn't too difficult. It's after that things get sticky 😐
1 REPLY 1
Doc_Duke
Rhodochrosite | Level 12
use PROC TRANSPOSE to convert from one row per encounter to one row per diagnosis. then you can treat it as you would diag1.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 1 reply
  • 806 views
  • 0 likes
  • 2 in conversation