topic Re: DateTime in SAS Programming

DateTime

liyongkai800 — Mon, 03 Dec 2018 14:40:12 GMT

Say I have a variable 'ReadTime' with the format datetime22.3, how to add the where statement to get the subset.

say I have

data want;

set exist;

where readtime>'01DEC2018:00:40:00.000';

run;

Then sas reports 'WHERE clause operator requires compatible variables'. Any idea? Thanks.

Re: DateTime

novinosrin — Mon, 03 Dec 2018 14:43:59 GMT

will this work?


data want;

set exist;

where readtime>'01DEC2018:00:40:00.000'dt

run;

Re: DateTime

liyongkai800 — Mon, 03 Dec 2018 14:47:07 GMT

Though I've no idea why simply add 'dt then it works lol, it works indeed. Thanks.

Re: DateTime

liyongkai800 — Mon, 03 Dec 2018 14:49:08 GMT

Yes, it works.

Re: DateTime

novinosrin — Mon, 03 Dec 2018 14:51:26 GMT

Thank you @liyongkai800

Re: DateTime

Kurt_Bremser — Mon, 03 Dec 2018 14:56:59 GMT

@liyongkai800 wrote:
Though I've no idea why simply add 'dt then it works lol, it works indeed. Thanks.

See here:

Date, Time, and Datetime Constants

Re: DateTime

RW9 — Mon, 03 Dec 2018 14:57:06 GMT

Look at the manual on the topic named literals. It is system for passing in character data in a specific format, which SAS can convert on the fly. So a suffix of:

'ddmmmyyyy'd    = date in form ddmmmyyyy
dt              = date time as given in the example
'...'n          = named literal of a column from third party software such as 
                  Excel where name may not be SAS conformant.

Re: DateTime

liyongkai800 — Mon, 03 Dec 2018 19:22:06 GMT

Very informative, thanks.

Re: DateTime

VarunD — Wed, 19 Dec 2018 15:48:26 GMT

Hi,

I am trying to compare a datetime variable using the following expression

where eff_dt>'01DEC2018:00:00:00.000'dt

but it is throwing me an error

I tried

where eff_dt > today( )

but this didn't work either.

Format of eff_dt is DateTime22.3 and values are like 31DEC2199:00:00:00.000

What am I doing wrong here ?

Thanks

Varun

Re: DateTime

novinosrin — Wed, 19 Dec 2018 15:57:48 GMT

ok, If your eff_dt is a datetime variable i.e the internal value is stored in seconds and you want to compare with today() an integer date, You would need to extract the the integer date from the datetime value using datepart

For example

if datepart(eff_dt)>today() ;/*assuming your eff_dt is a datetime value*/

if both are date values, i.e the internal value is stored as integers as the number of days from jan1,1960 you could use

if eff_dt>today() /*both being date values with integers*/

HTH & Regards!

Re: DateTime

VarunD — Wed, 19 Dec 2018 16:16:00 GMT

This worked !

You are a life saver. Thanks a ton.

Varun