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: 
kp2519
‎10-10-2019
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to calculate length of drug supply of mutiple fill dates

by Calcite | Level 5 in SAS Programming
‎10-10-2019 02:47 PM
‎10-10-2019 02:47 PM
Hi thanks for the suggestion for the data structure and management, It was really helpful with the data set.  Can you explain the lag function a little bit i am alittle confused. Maybe i also did not present my question as clearly as i wanted as well. From your suggestions this is where i am at now .   I sorted the data for mbr_id and fill_date and i created a flag for those who have suboxone and opioid.  From here how would i use the lag function to calculate if the opioid claim is rejected if its 30 days +days supply of my last suboxone fill? thanks for all the help it, ive learned alot      Have mbr_id fill_date days sub_flag   1 06Jan2018 15.000 suboxone 1 20Jan2018 15.000 suboxone 1 03Feb2018 15.000 suboxone 1 23Feb2018 3.000 opioid   1 24Feb2018 15.000 suboxone 1 24May2018 7.000 suboxone 2 03Apr2018 5.000 suboxone 2 07Apr2018 30.000 suboxone 2 02May2018 30.000 opioid           want         mbr_id fill_date days sub_flag reject_flag 1 06Jan2018 15.000 suboxone 1 20Jan2018 15.000 suboxone 1 03Feb2018 15.000 suboxone 1 23Feb2018 3.000 opioid 1 1 24Feb2018 15.000 suboxone 1 24May2018 7.000 suboxone 2 03Apr2018 5.000 suboxone 2 07Apr2018 30.000 suboxone 2 02Sep2018 30.000 opioid 0 ... View more

Re: How to calculate length of drug supply of mutiple fill dates

by Calcite | Level 5 in SAS Programming
‎10-08-2019 11:59 PM
‎10-08-2019 11:59 PM
I am trying to see the impact if their is a rule implemented would reject any opioid claim if it was filled within 30 days plus days supply of the suboxone. My idea was first to get all the claims of suboxone and calculate the what the end date is. Then merge the list in of all the other opioid claim and create a flag to see how many rejected claims would be from subsequent claims... Is my thought process right or would you have a better idea working with the data structure ... View more

How to calculate length of drug supply of mutiple fill dates

by Calcite | Level 5 in SAS Programming
‎10-08-2019 06:46 PM
‎10-08-2019 06:46 PM
Hi I am working with medical claims data with members have multiple different fills and supply according to the fills. I want to add each fill length to the fill date to create new field called end date. I having trouble running an array for this situation. I sorted my data and transposed but my array isnt working. Hoping to get help on how to solve this issues. Would appreciate any help!   data array_trial; set have; array end_date{3} end_date1-end_date3; array fill{3} fill_date1-fill_date3; array supply{26} days_supply1-days_supply3; do ii=1 to 3; script{ii}=0; end; do ii=1 to 26; do i=1 to 26; script{ii}= intnx('DTDAY',fill{i},supply{i}); drop i ii; end; end; run;     What i currently have is :   Have     Mbr_ID Fill_date Days_supply 1234 10/10/2019 20 1234 10/30/2019 30 1234 11/12/2019 20 1235 10/11/2019 20 1235 10/12/2019 30 1235 11/13/2019 20   want                   mbr_id fill_date1 fill_date2 fill_date3 days_supply1 days_supply2 days_supply3 end_date1 end_date2 end_date3 1234 10/10/2019 10/30/2019 11/12/2019 20 30 20 10/30/2109 x   1235 10/11/2019 10/12/2019 11/13/2019 20 30 20       ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-10-2019 06:08 PM
Quick links