I am trying to designate character variables to specific date intervals yet it only produces numerical and does not read quoted statements. I did create a new date variable and was going to do the designations. Please help. Thanks Data work.date_of_Death; set work.eclrsvs_fludata_new_NoDupkey; death_date=input(Dt_Of_death,yymmdd10.); format death_date mmddyy10.; if Death_date le 08/01/2020 then Week_No = "2031"; Else if Death_date le 08/08/2020 then Week_No = "2032"; Else if Death_date le 08/15/2020 then Week_No = "2033"; Else if Death_date le 08/22/2020 then Week_No = "2034"; Else if Death_date le 08/29/2020 then Week_No = "2035"; run;
... View more
