topic Re: How to convert to Datetime? in SAS Procedures

How to convert to Datetime?

ren2010 — Fri, 24 Sep 2010 17:47:52 GMT

My code is below, and I am trying to convert a MMDDYY var to DATETIME19.,but getting unreasonable value. example:

data _null_;
x=today();
put x= date.;
put x1= datetime.;
run;

This code produces the following:

X=12/01/2010
X1=01JAN60:04:02:23

is there any way to avoid the non valid value of X1?
Please help

Re: How to convert to Datetime?

Tim_SAS — Fri, 24 Sep 2010 18:02:33 GMT

The today() function returns a date value, not a datetime value. Use the datetime() function instead.

http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a000200627.htm Message was edited by: Tim@SAS

Re: How to convert to Datetime?

RickM — Fri, 24 Sep 2010 18:04:01 GMT

Date variables are days since 1/1/1960. Datetime variables are seconds since 1/1/1960. So lets say x=2. If we display x with a date format we would ge two days past 1/1/1960 (1/3/1960). If we display x with a datetime format we get two seconds past midnight on 1/1/1960 00:00:02.

Re: How to convert to Datetime?

art297 — Fri, 24 Sep 2010 18:07:40 GMT

You already have the answer you needed. Now, if you want to learn more about working with dates, times and datetimes in SAS, take a look at:

http://www2.sas.com/proceedings/sugi25/25/btu/25p058.pdf

HTH,
Art