topic Re: Getting the YY only from DATE() in SAS Programming

Getting the YY only from DATE()

deleted_user — Tue, 17 Nov 2009 06:29:24 GMT

Hi all

I am trying to get the YY part of the YEAR() function and write it out to a dataset but cannot get this done.

This is my code:

DATA XXX;
YR = YEAR(DATE());
FORMAT YR $04.;
YRF = SUBSTR(YR,3,2);

FILE MERGED;
PUT @001 RECORDH $01.
@002 MTH 2.
@004 YRF $02.
;

But this only writes out a blank - what am i missing?

Thanks!

Re: Getting the YY only from DATE()

Peter_C — Tue, 17 Nov 2009 08:32:58 GMT

use the year format with length 2, like[pre] put @4 date year2. ;[/pre]
PeterC

Re: Getting the YY only from DATE()

Doc_Duke — Tue, 17 Nov 2009 16:21:29 GMT

Peter has a solution, but your problem is that you have mixed up numeric and character data types. You should have gotten lots of warnings about converting numeric to character or vice-versa.

The YEAR function returns a numeric value. If you rewrote as

DATA XXX;
LENGTH yrf $ 2;
YRF = PUT(YEAR(DATE()),year2.);

FILE MERGED;
PUT @001 RECORDH $01.
@002 MTH 2.
@004 YRF $02.
;

it should work (though you are missing other parts of your code).

Re: Getting the YY only from DATE()

Peter_C — Tue, 17 Nov 2009 20:15:30 GMT

needs minor revision (cannot apply the year format to the value returned by the year() function)[pre]YRF = PUT(DATEvariable,year2.);[/pre] But that dateVariable could be formatted in the put statement, since the string variable is not used elsewhere.
I would not use this routine with the date function, but that is just my personal preference. I don't often have to prepare programs to run where date() might return a different year from the year in constant &sysdate. (Does one of the BI servers create that situation?)
PeterC