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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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: