topic split date date into multiple variables in SAS Programming

split date date into multiple variables

radha009 — Tue, 15 Oct 2019 21:51:26 GMT

want to split data "Oct 15 2019 12:00 AM EDT - Oct 15 2019 11:59 PM EDT" into two columns

column 1: Oct 15 2019 12:00 AM EDT

Column 2: Oct 15 2019 11:59 PM EDT

Re: split date date into multiple variables

novinosrin — Tue, 15 Oct 2019 21:53:27 GMT

data have;
date='Oct 15 2019 12:00 AM EDT - Oct 15 2019 11:59 PM EDT';
run;

data want;
set have;
date1=scan(date,1,'-');
date2=scan(date,-1,'-');
run;