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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.