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
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;
Dive into keynotes, announcements and breakthroughs on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!