topic Re: How to display the current year in character data type in SAS Procedures

How to display the current year in character data type

deleted_user — Fri, 14 Aug 2009 08:39:17 GMT

Hi,

I have encountered a problem in sas data integration studio which has been bugging me for some time.

I have a column called year which is a derived dated field that shows the current year.

Then i encountered a strange thing

if my column is a numeric data type and i do this -> YEAR(Date()) -> I get 2009

if my column is a character data type and i do this -> PUT(YEAR(Date(), year4.) -> I get 1965

It's so strange, so I like to find out how can I displayed 2009 in character data type?

Thanks.

Yours Sincerely,
helphelp

Re: How to display the current year in character data type

LOK — Fri, 14 Aug 2009 09:13:23 GMT

Hi,

Try This

in place of
PUT(YEAR(Date(), year4.)

keep
put(year(date),4.);

Re: How to display the current year in character data type

GertNissen — Fri, 14 Aug 2009 09:29:30 GMT

It's not strange

YEAR(Date()) will return 2009 as you write

But PUT(YEAR(Date()), year4.)

is the same as

PUT(2009,year4.)

Remember that year4. will display the year that is 2009 DAYS since 1960 - and 1965 is 2009 DAYS since 1960.

Just use PUT(date(), year4.)

Re: How to display the current year in character data type

LOK — Fri, 14 Aug 2009 09:51:01 GMT

Hi,
you cen use any one of the following

PUT(YEAR(DATE), 4.)

PUT(DATE, YEAR4.)

Re: How to display the current year in character data type

deleted_user — Mon, 17 Aug 2009 01:24:49 GMT

Hi,

Thanks for the people out there that is helping me

one last clarification

PUT(YEAR(Date()) , year4.) return '1965'

PUT(YEAR(Date()), 4.) return '2009'

are there actually equivalent?

Thanks

Yours Sincerely,
helphelp

Re: How to display the current year in character data type

sbb — Mon, 17 Aug 2009 03:13:42 GMT

They are not equivalent. The YEARw. (you used YEAR4.) format takes a SAS DATE variable and displays the year-portion. So, your code took the SAS numeric variable value 2009 (which represents the date 19MAY1965) and displayed only the year for that date.

Also, the YEAR() function takes a SAS DATE numeric variable and extracts the year-portion, assigning the value to a variable, as you used it.

The link below provides useful SAS Base DOC reference on this topic.

Scott Barry
SBBWorks, Inc.

Dates, Times, and Intervals
About SAS Date, Time, and Datetime Values
http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a002200738.htm