Hello -  Try the code below.  Assuming your date field is called "date", you can create a new field called "date_want"  Basically, the input function will convert your data from character, to the numeric date field.  Since your data is currently in yyyy.mm.dd, we need to define that format for SAS with yymmdd10. (10 total characters, in yymmdd order).  the Scan function is taking all the records before the space, between your date and what looks like the time.     data want; set have; date_want = input(scan(date,1," "),yymmdd10.); format date_want mmddyy10.; run;   RESULT date date_want 2021.04.19 9:03 04/19/2021 2021.04.21 7:22 04/21/2021 ... View more