DATA Step, Macro, Functions and more

yearCutoff

Reply
Occasional Contributor
Posts: 8

yearCutoff

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

 

 

 

Yasmin Syeda
Super User
Posts: 17,749

Re: yearCutoff

[ Edited ]

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
   

 

Respected Advisor
Posts: 4,641

Re: yearCutoff

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

PG
Ask a Question
Discussion stats
  • 2 replies
  • 186 views
  • 0 likes
  • 3 in conversation