topic years and days conversion in SAS Programming

years and days conversion

dr_101 — Tue, 05 Feb 2019 04:25:11 GMT

Hi,

if i ve been typing this in my code:

where time >224 days;

what if i want time less than 5 years for my analysis. how to code that?

thanks.

Patrick — Tue, 05 Feb 2019 04:49:43 GMT

where time >224 days

...is not valid SAS code.

Please post your actual code. Also tell us what's actually stored in variable TIME - SAS TIME, DATE or DATETIME value or something else? If you don't understand what I'm asking you for then have a read here: http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm

FredrikE — Tue, 05 Feb 2019 07:55:07 GMT

Hi!

Check out the INTNX function, it will certainly help you 🙂

Something like INTNX( 'year', time, -5 )

//Fredrik