Help Split date Character by comma delimeter

[konvickt]

Hi There, 

Have a dataset and want to split the date column to only contain the Date and create another column that has the time.

Currently, it is a character variable  and 03/17/2021,11:00am

I need it to be split as

Date                      Time

03/17/2021             11:00am

Thanks

[Reeza]

SCAN()

date =scan(originalVar, 1, ",");
time = scan(originalVar, 2, ",");

date_sas = input(date, mmddyy10.);
time_sas = input(time, time.);
format date_sas mmddyy10. time_sas time8.;

[konvickt]

Thank you so much for the reply. Will give it a try 

[konvickt · Accepted solution]

Hi Reeza, am getting a syntax error on time asking for format when I put in time_sas=input(time,time)
Error expecting a format name
Error Syntax error, statement will be ingnored

[Reeza]

For starters you missed the period, it is required. It may not be the correct informat either, see the informat documentation to one that matches your current format.