How to Determine Alternatives to Rejected Drugs within Time Window

tennis1 — Thu, 21 Nov 2019 22:33:19 GMT

For the target drugs in the GPI column, I’d like to know if an alternative drug (column I)
was filled within 7 days of the target drug reject.

data WORK.MESSAGE;
   infile datalines;
   input fill_date GPI Alt_1 Alt_2 Alt_3 etc.;
 datalines; 
6/1/19 A B C D              
 6/25/19 E F              
 5/14/19 G H B C D F Y Z                 
 ;;;;

I can isolate the claims that were rejected, but am not sure how to extract the alternatives within the time frame. Thanks in advance!

Re: How to Determine Alternatives to Rejected Drugs within Time Window

ballardw — Thu, 21 Nov 2019 23:21:28 GMT

Please show what you expect the result to look like.

And please make sure that your data step generates a data set that you expect. What appears to be posted will only have one record. Datalines should not be on the line with "datalines;" as well.

You might be able to use WHICHC to find which variable has a value but from the scrambled data step you posted I don't see any likely candidates for the "gpi" to be found.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

topic How to Determine Alternatives to Rejected Drugs within Time Window in New SAS User

How to Determine Alternatives to Rejected Drugs within Time Window

Re: How to Determine Alternatives to Rejected Drugs within Time Window