Thank you so much. I am almost there! I have some dates that were appended with a (1) or a (2). I just need to strip that off before adding the year. Everything else is working! the anydtdte21. the "21" is what fixed the last error I was having. K- ... View more

Sorry, code here... data Spring21.DC2; set Spring21.chcdata_catcomb; NewDate = input(catt(scan(Date,2,","),",2005"),anydtdte.); /* DOW = dow(y); */ proc contents data=spring21.DC2; run; ... View more

Thanks Reeza, I do have the year in a different column (2005). I attached the file. I tried this code and got the NewDate variable, but only got what I believe is a julian date (19449) in the cells that have a repeated date... Wednesday, Apr 13(1) and Wednesday, Apr 13(2) -- The DOW returned an error. -- data Spring21.DC2; set Spring21.chcdata_catcomb; NewDate = input(catt(scan(Date,2,","),",2005"),anydtdte.); /* DOW = dow(y); */ proc contents data=spring21.DrewC2; run; ... View more