topic Informat anydtdte - issue in SAS Enterprise Guide

Informat anydtdte - issue

NN — Tue, 02 Aug 2011 19:22:38 GMT

Hi,

We are working on a 9.2 - EG installation. i was trying the following code.

data a;

format a date9. b date9.;

a=input('01-Apr-19',anydtdte9.);

b=input('01-Apr-20',anydtdte9.);

run;

the output that i get is

a=01apr2019

b=01apr1920

Why is it that for the first date the year comes as 2019 but for the second date the year comes as 1920. Any suggestions would be helpful.

Informat anydtdte - issue

Reeza — Tue, 02 Aug 2011 19:30:13 GMT

Look up the option yearcutoff

The default is 1920 which you need to change for your dates.

Informat anydtdte - issue

art297 — Tue, 02 Aug 2011 19:53:30 GMT

Reeza already told you about the yearcytoff option for 2-digit years. Date9. expects DDMMMYY(YY) characters. In your example was 01 at the beginning representing day or year?

Informat anydtdte - issue

NN — Wed, 03 Aug 2011 07:19:48 GMT

Reeza,

Thanks a lot..

Art,

The 01 represented the day.