OK, not sure what you mean by pseudo code, but here is more background: Original tables------------------ SERIAL CF_WRKR CF_WRKR2 BEG_DATE END_DATE 3333 none . 03/01/2020 03/30/2020 4564 none BCF45G6 03/01/2020 03/30/2020 Output desired ----------- SERIAL CF_WRKR CF_WRKR2 BEG_DATE END_DATE 3333 VGD5T67 VGD5T67 02/01/2020 03/30/2020 4564 BCF45G6 BCF45G6 03/01/2020 03/30/2020 /*Note the date change for 3333 that now should start at Feb1 instead of March 1 to pull its latest ID that is no more there in March (person was discontinued after Feb)*/ The code below is the code where I have a date range top pull ID information for March. For all the IDs this is the code that pulls them up. So my column CF_WRKR2 displays all the IDs that show up in the system for March 2020. For ID 3333, I still get a 'none' assigned (it's the only one for which it happens). So for that 3333 ID, I can't use the same date range anymore like below, instead I have to pull it from February 2020. SO I don't want to bother this code, I want to change the date for that case in the code I have sent previously. -------------------------------- FULL CODE -------------------------------- proc sql; &EDR; create table WRKR as Select distinct a.* FROM (select * from connection to edr_civ (SELECT c.SERIAL_NUM_IDENTIF as casenum ,PGM.PGM_CODE ,PGM.CASE_ID ,PGM.ID as pgmID ,PGM_DETL.stat_code as pgmStat ,STAFF.COUNTY_CODE ,staff_wrkr.pos_ID ,staff_wrkr.wrkr_num_identif as CF_WRKR2 ,PGM_ASSIGN.PGM_ID as paID ,PGM_ASSIGN.POS_ID as paPoID ,PGM_ASSIGN.BEG_DATE as paBeg ,PGM_ASSIGN.END_DATE as paEnd ,POS.ID ,PGM_DETL.BEG_DATE as pdBeg ,PGM_DETL.END_DATE as pdEnd ,PGM_DETL.stat_code as statcode ,STAFF_POS_ASSIGN.BEG_DATE as spobgdt ,STAFF_POS_ASSIGN.END_DATE as spoendt From dbo. [case] as c inner join dbo.pgm on c.id = pgm.case_id inner join dbo.PGM_DETL on PGM.ID = PGM_DETL.PGM_ID inner join dbo.PGM_ASSIGN on PGM_ASSIGN.PGM_ID = pgm.ID inner join dbo.POS on POS.ID = PGM_ASSIGN.POS_ID inner join dbo.staff_wrkr on POS.ID = staff_wrkr.POS_ID inner join dbo.STAFF_POS_ASSIGN on STAFF_POS_ASSIGN.POS_ID = POS.ID inner join dbo.STAFF on STAFF.ID =STAFF_POS_ASSIGN.STAFF_ID WHERE pgm.pgm_code = 'FS' /* AND PGM_DETL.stat_code = 'DS' */ AND STAFF.COUNTY_CODE = '33' AND PGM_ASSIGN.END_DATE >= '03/01/2020' AND PGM_ASSIGN.END_DATE >= STAFF_POS_ASSIGN.BEG_DATE AND STAFF_POS_ASSIGN.END_DATE >='03/01/2020' AND STAFF_POS_ASSIGN.END_DATE >= PGM_ASSIGN.BEG_DATE AND PGM_ASSIGN.BEG_DATE <= '04/01/2020' AND STAFF_POS_ASSIGN.BEG_DATE <= '04/01/2020' ORDER BY casenum, paID, paEnd desc) as a); disconnect from edr_civ; Quit; ... View more

This would have been a good idea, but my issue is that I'm trying to tell the machine, if the serial 3333 appears then I don't want you to search from March 1st anymore, but from February 1st instead. Makes sense? So I don't think I should do case WHEN (tc.serial = '3333') and (wr.paEnd >= "01FEB2020"d) then ... with the 'and' because February does not exist in the date range I selected upstream in the code. Makes sense? That's why I'm trying with THEN... But maybe SAS thinks differently? Thoughts? ... View more

Thank you, I'll check in on your suggestions. To answer your question, when I look at the top of the column to see it's type, the  "01FEB2020"d says type: DATE That's why I was wondering if I have to do some kind of transformation of that date type into a character value? Thoughts?  ... View more