Hello everyone,   I was wondering if I could get some assistance and to be honest I don't really know where to start. I have data like below and what I would like to determine is the last stage an individual completed. The stages should be completed in order from start to end and no individual in my data should have an end date because no one has completed the process.   In some instances, individuals have dates that occur out of order for example id 001, 002, 004 etc. and I do not want to exclude those individuals but maybe use a different flag variable to identify those people.   What I would like to do is create a flag for where the person stopped. So for instance, id 007 made it through to review complete but did not make it to health date. Therefore, the last stage that person completed was review complete. I would flag that person as being stopped at review complete. The overall goal is to get a count of how many people got stopped in each stage. Any help would be greatly appreciated.   ID Start Review Review Complete Health date Health date end End 001 10/11/2019 . . 10/24/2019 10/24/2019 . 002 11/14/2019 . . 11/15/2019 11/15/2019 . 003 10/24/2019 10/29/2019 10/29/2019 11/20/2019 11/20/2019 . 004 01/08/2019 . . 02/19/2019 . . 005 08/16/2019 08/16/2019 09/27/2019 09/20/2019 09/20/2019 . 006 02/11/2019 . . . . . 007 02/12/2019 02/13/2019 02/13/2019 . . .   ... View more

I have data like below: Incomplete Incomplete_pct Stalled Stalled_pct Unbegun Unbegun_pct Complete Complete_pct 19751            3.24179          37591   6.16992       146644 24.06911          405276      66.51916 But I would like for my data to look like this:   STATUS       COUNT PERCENT Incomplete   19751         3.2 Stalled          37591         6.2 Unbegun     146644       24.1 Complete     405276      66.5   I was able to create the table I want using the code below. My question is I feel there should be an easier way. Any suggestions?   proc transpose data = test1 out = test2 (rename=col1=COUNTS _name_ =STATUS)); var incomplete stalled unbegun complete; run; proc transpose data = test1 out = test3 (rename=col1=PERCENT _name_ =STATUS_2)); var incomplete_pct stalled_pct unbegun_pct complete_pct; run;   data combine;      merge test2 test3;      format counts comma8.0 percent 8.1; run; ... View more

I have six main variables which are: ddate rdate rcompdate mdate mpdate hdate each variable is associated with a number of days as in the table below   ID ddate rdate rcompdate mdate mpdate hdate 1 642 2 74           61        61 3 614   I would like to flag the variables when they fall within a certain number of days for each of the main variables (example in the table below) the range is 0-6  7-30  31-90  91-180  gt181 ID ddate rdate rcompdate mdate mpdate hdate ddate_0to6 ddate_7to30 ddate_31to90 ddate_91to180 ddate_gt181 1 642                                                                                                                                                                     1 2 74 61 61                                                                                                                     1 3 614                                                                                                                                                                     1   I can flag one of the variables such as DDate using the code below. In order to flag my other main variables such as(rdate rcomdate .....) I would have to write the could below several times. Is there anyway I could do this without having to repeat the code below six times?   data flag; set import; If 0 le ddate le 6 then ddate_0to6 =1; If 7 le ddate le 30 then ddate_7to30 =1; If 31 le ddate le 90 then ddate_31to90 =1; If 91 le ddate le 180 then ddate_91to180 =1; If ddate ge 181 then ddate_gt181 =1; run; ... View more

I have the following data below. I would like to choose the obs where first_year eq 1. I would like my data set to look like the table below could someone assist me with this?   data data1; infile datalines delimiter = ','; input customerid $ year regdate:mmddyy10. completedate:mmddyy10. first_ssn last_ssn first_year last_year; format regdate completedate mmddyy10.; datalines; 100, 2019,04/30/2019, 01/24/2018, 1,0,1,0 100,2018,12/31/2018,12/16/2019, 0,0,0,0 100,2018,11/30/2018,12/16/2019, 0,0,0,1 100,2019, 08/31/2019,12/16/2019,0,0,1,0 ; run; customerid year regdate completedate first_ssn last_ssn first_year last_year 100 2019 4/30/2019 1/24/2018 1 0 1 0 100 2019 8/31/2019 12/16/2019 0 0 1 0 ... View more

I have the following sample two datasets which I would like to merge together by ID  and add the following flags:    completeyr would be flagged if regcomplete is between startdate and enddate  completegrace would be flagged if regcomplete is between extdate and startdate noncompliant would be flagged if the two conditions above are not met    In certain instances an ID can be flagged for completeyr and completegrace, in which case I would like to use the completeyr flag. Can anyone assist me with this? Below is an example of how I would like the data to look. If the complete data were represented there would be several other Id's and the other flag columns would have flags.      data data1; infile datalines delimiter = ','; input ID $ REPORT_ORDER $ ENTERDATE:mmddyy10. MONYR:monyy7. STARTDATE:mmddyy10. ENDDATE:mmddyy10. EXTDATE:mmddyy10.; format ENTERDATE STARTDATE ENDDATE EXTDATE mmddyy10. MONYR:monyy7.; datalines; 100,7,04/30/2019,APR2019,04/30/2018,04/30/2019,01/31/2018 100,11,08/31/2019,AUG2019,08/31/2018,08/31/2019,05/31/2018 100,3,12/31/2018,DEC2018,12/31/2017,12/31/2018,09/30/2017 100,5,02/28/2019,FEB2019,02/28/2018,02/28/2019,11/30/2017 100,4,01/31/2019,JAN2019,01/31/2018,01/31/2019,10/31/2017 100,10,07/31/2019,JUL2019,07/31/2018,07/31/2019,04/30/2018 200,9,06/30/2019,JUN2019,06/30/2018,06/30/2019,03/31/2018 200,6,03/31/2019,MAR2019,03/31/2018,03/31/2019,12/31/2017 200,8,05/31/2019,MAY2019,05/31/2018,05/31/2019,02/28/2018 200,2,11/30/2018,NOV2018,11/30/2017,11/30/2018,08/31/2017 200,1,10/31/2018,OCT2018,10/31/2017,10/31/2018,07/31/2017 200,13,10/31/2019,OCT2019,10/31/2018,10/31/2019,07/31/2018 200,12,09/30/2019,SEP2019,09/30/2018,09/30/2019,06/30/2018 ; run; data data2; infile datalines delimiter = ','; input ID $ MONYR:monyy7. REGCOMPLETE:mmddyy10.; format MONYR monyy7. REGCOMPLETE mmddyy10.; datalines; 100,DEC2017,12/08/2017 100,DEC2018,12/03/2018 100,OCT2019,10/24/2019 200,JUL2018,07/25/2018 ; run;       ID REPORT_ORDER ENTERDATE MONYR STARTDATE ENDDATE EXTDATE REGCOMPLETE COMPLETEYR COMPLETEGRACE NONCOMPLIANT 100 3 12/31/2018 Dec-18 12/31/2017 12/31/2018 9/30/2017 12/3/2018 1     100 10 7/31/2019 Jul-19 7/31/2018 7/31/2019 4/30/2018 7/25/2018 1     200 13 10/31/2019 Oct-19 10/31/2018 10/31/2019 7/31/2018 10/24/2018 1     ... View more