I did not check and I am not sure that's possible. The data are stored in web-based application that's custom built for us and it's password protected. ... View more

that's what I wondered but I thought that maybe someone had a better answer. I appreciate your time looking into this.  ... View more

Data example in Excel that's currently in character  ID EnSur Grp Age Bar Test Date 1 2 3 9 12 100 1/15/2018 2 1 0 8 2 80 2/6/2018 3 2 1 9 11 95 6/4/2017   I want the same variable names displaying the same values but they should be numeric:  ID EnSur Grp Age Bar Test Date 1 2 3 9 12 100 1/15/2018 2 1 0 8 2 80 2/6/2018 3 2 1 9 11 95 6/4/2017   I also need to do this import quarterly. I can only download the data from the web-based system into excel.  ... View more

I can only import the data into excel, even after I save the excel file as CSV and import into SAS the formats sill remain the same (character). ... View more

here's a bigger fake dataset. I would expect the final dataset to have one line per ID with calculated variables PDC (number of days covered by all drugs/180 days=PDC)      ID NDC Filldate1 Supply1 Filldate2 Supply2 Filldate3 Supply3 Filldate4 Supply4 Filldate5 Supply5 Filldate6 Supply6 Filldate7 Supply7 1 10 1/1/2013 30 2/2/2013 60 4/6/2013 30                 1 35 1/1/2013 30 3/5/2013 30 8/6/2013 60                 1 68 5/5/2013 60 8/10/2013 60 10/1/2013 60                 2 50 1/7/2013 30 2/8/2013 30 3/11/2013 30                 2 60 4/5/2013 30 4/29/2013 30 6/3/2013 30 7/3/2013 30 8/21/2013 3         2 70 3/11/2013 28 4/17/2013 28 6/3/2013 16 7/17/2013 33 8/21/2013 33 9/19/2013 33 11/12/2013 33 2 80 9/30/2013 30 10/24/2013 30 12/2/2013 30                                                 ... View more

You're right, I apologize for that, it's my first time posting and I have been looking at this forever. I should have just posted my last posting first.    Can any one please help/provide me with code example that i can work off?  I really appropriate it.   ... View more

This would be in SAS after run all the code i have right now, so there would be 3 separate datasets for one ID with 3 different drugs and I want to calculate the score from all those 3 separate datasets but I need to figure out how to concatenate the datasets to count the overlaping days, the problem is that each of those variables have the same name so when I merge them in the last step, Step 3, it only transfers data from one drug with the data values and assigns missing values to the other drugs, therefore, i can figure out the overplaping days with the code. My data in SAS before i run any of my SAS codes looks something like this:    ID NCD (drug)  filldate1 Supply1 filldate2 Supply2   filldate3     Supplly3 1  10                 1/1/2013  30        2/2/2013   60        4/6/2013      30 1  35                 1/1/2013  30        3/5/2013   30        8/6/2013      60 1   68                5/5/2013  60        8/10/2013  60       10/1/2013    60 2   50                2/2/2013  30        5/10/2013  30       11/1/2013     30   Here's what i want to do:  1. Figure out the number of days per person each drug covers during a 180 day period 2. Calculate the numbers of days overlapping for each person for all their drugs combined, then calculate the score for Total of days covered for all drugs /180 days   ... View more