topic Re: yearCutoff in SAS Programming

yearCutoff

ysyeda — Thu, 24 Nov 2016 22:45:31 GMT

options yearcutoff=1920;

data test;

datea='01jan19'd;

dateb='01jan20'd;

year=dateb-datea;

run;

a. 0

b. -1

c.1

d.99

Which one is the correct answer

Reeza — Thu, 24 Nov 2016 23:24:49 GMT

None of the above, though I suppose it depends on the question which you have not provided. It helps...

Easiest way to answer this question is to run the code.

options yearcutoff=1920;
data test;
datea='01jan19'd;
dateb='01jan20'd;
year=dateb-datea;
format datea dateb date9.;
run;

proc print data=test;
run;

And the output:

                             Obs        datea        dateb     year

                             1     01JAN2019    01JAN1920    -36160

PGStats — Thu, 24 Nov 2016 23:33:05 GMT

Hint : datea and dateb are SAS dates, not years. SAS internal representation of dates is the number of days since 01JAN1960.