topic Re: SAS EG - Substract year from DATE9 variable in SAS Enterprise Guide

SAS EG - Substract year from DATE9 variable

user34567 — Thu, 02 May 2024 08:39:56 GMT

Hi,

In my dataset I have a date (document_date) listed in format DATE9. I would like to add an additional column which gives you the YEAR of 'document_date'. I've tried the following things, but it is not giving me the year. What am I doing wrong?

1. Add a computed column YEAR(t1.document_date) in format YEAR4 --> gives me 17JUL1965

2. Add t1.document_date as an additional column and give it format YEAR4 --> the output is the same as the input

Thank you in advance.

Re: SAS EG - Substract year from DATE9 variable

Patrick — Thu, 02 May 2024 09:06:26 GMT

Your 2nd options sounds like something that should work.

data have;
  document_date='25Feb2024'd;
run;

proc sql;
  select 
    document_date
    ,document_date as document_date_2 format=date9.
    ,document_date as document_date_3 format=year4.
  from have
  ;
quit;

Re: SAS EG - Substract year from DATE9 variable

Kurt_Bremser — Thu, 02 May 2024 09:31:12 GMT

Both the YEAR function and the YEAR format expect an input value which represents a SAS date. SAS stores dates as counts of days, with 1960-01-01 being day zero.

Since the result of the YEAR function is not a SAS date, but the year number, applying the DATE format to the result will interpret this number as a count of days and come up with a year of 1965 for the value of 2024.

For the display of a year value like the number 2024, no format is needed. It's just a 4-digit number, unless you reached so far into the future that you went past 9999.

Re: SAS EG - Substract year from DATE9 variable

user34567 — Thu, 02 May 2024 10:43:19 GMT

Hi @Kurt_Bremser,

Thank you for your explanation. I've set the format to 'none' and now it indeed works!