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: 
jdukes42
‎09-01-2015
  • 11 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Collapsing Consecutive Dates

by Calcite | Level 5 in SAS Programming
‎08-10-2011 09:33 AM
‎08-10-2011 09:33 AM
Art- Thanks. I will take a look at this. Jonathan ... View more

Collapsing Consecutive Dates

by Calcite | Level 5 in SAS Programming
‎08-10-2011 09:03 AM
‎08-10-2011 09:03 AM
Art- The dates range from 2005 to 2010. Thanks again for your interest and help. Jonathan ... View more

Collapsing Consecutive Dates

by Calcite | Level 5 in SAS Programming
‎08-09-2011 05:18 PM
‎08-09-2011 05:18 PM
Hi All, I have a new question regarding collapsing consecutive dates. For my study I am looking at antibiotic prescriptions. I have already determined the patients who would have been given a single primary antibiotic. However, now I have to address those individuals who would fall into the mixed therapy category. For these individuals I want to collapse the start and stop dates for antibiotics given on consecutive dates. In addition to collapsing to a single date, I need to retain the antibiotic given on those dates (see example below). ID RX_1 RX_2 Start_1 Start_2 Stop_1 Stop_2 New_Start New_Stop New_RX_1 New_RX_2 1 1 2 5/2/2001 5/3/2001 5/2/2001 5/3/2001 5/2/2001 5/3/2001 1 2 2 1 3 5/2/2001 5/2/2001 5/2/2001 5/2/2001 5/2/2001 5/2/2001 1 3 However, not all individuals will have multiple treaments that can be collapsed into one set of consecutive dates. In those cases I need a data set that will look something like this ID RX_1 RX_2 Start_1 Start_2 Stop_1 Stop_2 New_Start1 New_Stop1 New_Start2 New_Stop2 New_RX1_1 New_RX1_2 New_RX2_1 New_RX2_2 3 1 2 5/2/2001 5/10/2001 5/2/2001 5/19/2001 5/2/2001 5/2/2001 5/10/2001 5/19/2001 1 2 The overall data set has up to 8 different prescription (RX), start, and stop dates that have to be collapsed. Thanks, Jonathan ... View more

Collapsing Dates

by Calcite | Level 5 in SAS Programming
‎08-05-2011 02:33 PM
‎08-05-2011 02:33 PM
Thank You for the help. Jonathan ... View more

Collapsing Dates

by Calcite | Level 5 in SAS Programming
‎08-05-2011 11:25 AM
‎08-05-2011 11:25 AM
Hi All, I have a question regarding collapsing dates. Currently, I have in my dataset the variables listed in the table below. The way the datacomes to me is that consecutive dates (i.e. Subject 1) are listed in a separate variable.  I would like to collapse the prescription names and prescription dates that are consecutive into one start/stop date and leave those with non-consecutve dates as  separate whenthey are like Subject 3.   How would one accomplish this? Thanks in advance for the help. ID   rx_name_1   rx_name_2   rx_start_dt_1   rx_start_dt_2   rx_stop_dt_1   rx_stop_dt_2   New_Start1   New_Start2   New_Stop1   New_Stop2   1   3   3   2/14/2001   2/15/2001   2/14/2001   2/16/2001   2/14/2001     2/16/2001     2   10   3   2/12/2001   2/13/2001   2/13/2001   2/13/2001   2/12/2001   2/13/2001   2/13/2001   2/13/2001   3   7   7   3/20/2001   3/25/2001   3/20/2001   3/27/2001   3/20/2001   3/25/2001   3/20/2001   3/27/2001   4   3   3   3/20/2001   3/25/2001   3/21/2001   3/22/2001   3/20/2001   3/25/2001   Thanks, Jonathan ... View more

Re: Array to determine Primary Therapy

by Calcite | Level 5 in SAS Programming
‎07-28-2011 10:10 AM
‎07-28-2011 10:10 AM
Art- Thanks once again for taking the time to help me with my SAS trouble. Thanks Jonathan ... View more

Re: Array to determine Primary Therapy

by Calcite | Level 5 in SAS Programming
‎07-27-2011 04:40 PM
‎07-27-2011 04:40 PM
Data New;       Set Old; Array Order[10] RX_order_1-RX_order_10; Array Three[10] RX_72_1-RX_72_10; Array Day[10] RX_day_1-RX_day_10; DO i=1 to 10; If Three=0 and Day GE 10 then do; The goal is use the order variable to determine the earliest therapy that meets the criteria Example 1 Criteria  1:  Taken with 72 hours of admission RX1_72=0 RX2_72=0 Criteria 2: Therapy taken for 10 days RX1_days  > 10 days RX2_days > 10 days Both RX1 and RX2 meet criteria Criteria 3: Earliest Taken Therapy RX1_order=1  RX2_order=1 RX1_order=RX2_order Action: Both RX1 and RX2 are listed as the Primary Therapy Example 2 Criteria  1:  Taken with 72 hours of admission RX1_72=0 RX1_72=0 Criteria 2: Therapy taken for 10 days RX1_days < 10 days RX2_days>10 days RX2_days  meets criteria Criteria 3: Earliest Taken Therapy RX2_order=2 Action:  RX2 is listed as Primary Therapy Example Criteria  1:  Taken with 72 hours of admission RX1_72=0 RX1_72=0 Criteria 2: Therapy taken for 10 days RX1_days >10 days RX2_days < 10 days RX1_days meets the criteria Criteria 3: Earliest Taken Therapy RX1_order=1   is the lowest ranked order Action:  RX1 is listed as the Primary Therapy Criteria  Three only matters because I have ten therapies whose order variable can rank from 1 to 10. ... View more

Array to determine Primary Therapy

by Calcite | Level 5 in SAS Programming
‎07-27-2011 02:33 PM
‎07-27-2011 02:33 PM
Art-      ID 1 was a typo.  However, I should indicate that the order variable was created by ranking the start date of each therapy. If RX_1 and RX_2 had the same start date then both would have an order of 1. If the RX_2 was started after RX_1 then the value would be 2. ID RX1_order RX2_order RX1_days RX2_days RX1_72 RX2_72 RX1_Prime RX2_prime 1 1 1 10 8 0 0 0 1 2 1 1 4 17 1 1 1 1 3 1 2 13 15 0 0 0 1 4 2 1 5 20 1 0 1 0 5 1 2 2 10 1 1 1 0 ... View more

Array to determine Primary Therapy

by Calcite | Level 5 in SAS Programming
‎07-27-2011 01:48 PM
‎07-27-2011 01:48 PM
Hello All, I have a wide data set containing the information on 10 prescription drugs taken by patients(RX_1-RX_10). The data set contains the order in which the drugs were taken (order), the number of days on that particular prescription (days), and whether the patient was started on the drug within 72hrs of admission to the hospital(_72 0=Yes, 1=No). I want to use this data to determine whether the drug was their primary therapy (Prime 0=Yes, 1=No). To be considered a patients primary therapy they must have taken the therapy within 72hrs of admission and been on the therapy for greater than or equal to 10 days. Additionally, it must be the earliest taken therapy. So if a patient took two different drugs within 72hrs of admission but took the first ordered drug for 1 day and the second ordered drug for 10 days then the primary therapy would be the second drug (See Small Example Data Set Below). ID RX1_order RX2_order RX1_days RX2_days RX1_72 RX2_72 RX1_Prime RX2_prime 1 1 1 10 8 0 0 0 0 2 1 1 4 17 1 1 1 1 3 1 2 13 15 0 0 0 1 4 2 1 5 20 1 0 1 0 5 1 2 2 10 1 0 1 0 Thanks, Jonathan ... View more

Array to substitute in Date

by Calcite | Level 5 in SAS Programming
‎07-25-2011 04:01 PM
‎07-25-2011 04:01 PM
Art297,      Thank you for the swift reply and help. Jonathan ... View more

Array to substitute in Date

by Calcite | Level 5 in SAS Programming
‎07-25-2011 02:47 PM
‎07-25-2011 02:47 PM
Hi All, I have a wide data set containing drug names and start dates. For each individual I want to transfer the start dates for each drug into a new variable. In cases where the drug is the same I want to use the earliest date as the new start date. See example below . How can this be done using an array? RX_1 RX_2 RX_3 Start_1 Start_2 Start_3 New_dt1 New_dt2 New_dt3 1 1 2 2 01/20/05 01/29/05 1/30/05 01/20/05 01/29/05 1/29/05 2 1 2 3 01/20/05 01/20/05 1/21/05 01/20/05 01/20/05 1/21/05 Thanks, Jonathan ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links