Thanks for the suggestions. I wanted to come back and say that I have also had success using     data want1; set attempt_nov; time_created1= timepart(DTAttempt); date_created1 = datepart(DTAttempt); week1=week(date_created1); format date_created1 mmddyy10. time_created1 time.; run; ... View more

Hi, I tried to use this suggestion to read in data that came to me like this 6/28/2021 22:51 6/28/2021 23:41 6/29/2021 2:18 6/29/2021 5:35 6/29/2021 2:13 I modified the string to be 1,9 and the date to be mmddyy but no luck   Any suggestions? TIA   ... View more