topic Help Split date Character by comma delimeter in SAS Programming

Help Split date Character by comma delimeter

konvickt — Thu, 18 Mar 2021 17:18:57 GMT

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

Re: Help Split date Character by comma delimeter

Reeza — Thu, 18 Mar 2021 17:23:08 GMT

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.;

Re: Help Split date Character by comma delimeter

konvickt — Thu, 18 Mar 2021 17:24:06 GMT

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

Re: Help Split date Character by comma delimeter

konvickt — Thu, 18 Mar 2021 17:58:24 GMT

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

Re: Help Split date Character by comma delimeter

Reeza — Thu, 18 Mar 2021 18:14:01 GMT

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.