cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
stefaniloran
‎04-18-2019
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: insert rows that are duplicated using a BY variable

by Calcite | Level 5 in SAS Programming
‎04-18-2019 03:37 PM
‎04-18-2019 03:37 PM
Inpatient events are determined by admit/discharge dates. Assume that the example is already sorted by the admit date descending. One idea I just had (thanks to your reply) is to start by defining all the INP discharge events in a separate table and then join to the full timeline to pick out the top 5 events for that patient_id that occur after the INP event... ... View more

insert rows that are duplicated using a BY variable

by Calcite | Level 5 in SAS Programming
‎04-18-2019 02:45 PM
‎04-18-2019 02:45 PM
I have used a data step to create a timeline of patient events. I now want to go back and create a table that records the first 5 events after every inpatient discharge. This will intentionally duplicate rows:   HAVE patient_id facility_type facility_id timeline_id position_id 1 INP A 1 1 1 SNF A 2 2 1 HHA A 3 3 1 INP B 4 1 1 HHA B 5 2 1 HOS B 6 3 2 INP A 1 1 2 HHA A 2 2 2 HOS A 3 3 2 INP B 4 1 2 HOM B 5 2 2 HOS B 6 3   WANT patient_id facility_type facility_id timeline_id position_id 1 INP A 1 1 1 SNF A 2 2 1 HHA A 3 3 1 INP A 4 4 /*new row*/ 1 HHA A 5 5 /*new row*/ 1 HOS A 6 6 /*new row*/ 1 INP B 4 1 1 HHA B 5 2 1 HOS B 6 3 2 INP A 1 1 2 HHA A 2 2 2 HOS A 3 3 2 INP A 4 4 /*new row*/ 2 HOM A 5 5 /*new row*/ 2 HOS A 6 6 /*new row*/ 2 INP B 4 1 2 HOM B 5 2 2 HOS B 6 3   Using version 7.15 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-18-2019 07:45 PM
Quick links