I have two variables in this dateset.
column A column B
2016-12-09T09:45 22NOV2016:00:50:07
column A is charactor variable. column B is numeric.
Each variable I have about 200 obs.
I need to not only consider the date, but also the time.
For some obs, that have same date, so I also need to compare time.
There are ISO-formats for this type of date and datetime notation:
data have;
input col_a :$16. col_b :datetime19.;
format col_b datetime19.;
cards;
2016-12-09T09:45 22NOV2016:00:50:07
;
run;
data want;
set have;
col_a_num = input(col_a,e8601dt19.);
format col_a_num datetime19.;
run;
There are ISO-formats for this type of date and datetime notation:
data have;
input col_a :$16. col_b :datetime19.;
format col_b datetime19.;
cards;
2016-12-09T09:45 22NOV2016:00:50:07
;
run;
data want;
set have;
col_a_num = input(col_a,e8601dt19.);
format col_a_num datetime19.;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: