topic DATE in New SAS User

DATE

bweeks59 — Wed, 03 Jun 2020 12:55:38 GMT

How do I pull the 4 digit year out of this 25MAY2015:00:00:00 in SAS?

I want to create a column year with the year of the transaction

I tried several different combos...

format year YEAR4.;

year = substr(transact_date,5,4);

Then I changed year to transact_year

23OCT2018:00:00:00.00000 is the transact_date in the results and it gives me 1975 as the year

Any ideas?

Re: DATE

novinosrin — Wed, 03 Jun 2020 13:07:06 GMT

Assuming your datetime value is numeric,

 year = year(datepart(transact_date));

You could also consider just formatting the datetime numeric value of transact_date to display only the year values by using dtyear format

format  transact_date dtyear.;

Re: DATE

novinosrin — Wed, 03 Jun 2020 13:03:23 GMT

And if your datetime value is char, then

year=year(input(transact_date,date9.));

Re: DATE

Kurt_Bremser — Wed, 03 Jun 2020 13:07:51 GMT

year = input(put(transact_date,dtyear4.),4.);

if you have a SAS datetime value.

Re: DATE

Tom — Wed, 03 Jun 2020 13:12:46 GMT

SAS stores dates as number of days and datetimes as number of seconds.

The YEAR format is for DATE values, not DATETIME values. If you try to use it with a date value well into the future since there a 86,400 seconds in a single day.

The SUBSTR() function is for character values, not numeric values. If you try to apply it to a numeric value SAS will first convert the number to a string using the BEST12. format.

If you convert the datetime value to a datevalue you can use the YEAR format to display it as the year number. Or you could use the YEAR() function to extract the year as a number in years.

data want;
  set have (rename=(transact_date=transact_datetime));
  transact_date=datepart(transact_datetime);
  transact_year=year(transact_date);
  format transact_date date9.;
run;

Re: DATE

bweeks59 — Wed, 03 Jun 2020 13:13:53 GMT

Thanks for the quick reply, I will try the methods you have listed and let you know how it goes.

Re: DATE

bweeks59 — Wed, 03 Jun 2020 13:16:05 GMT

Yes the date is a SAS datetime value, I am working on a few methods to see which one produces the required result and will let you know if i have success:-) Thanks a bunch

Re: DATE

bweeks59 — Wed, 03 Jun 2020 13:35:32 GMT

This worked and fast too:-) thanks so much for everyone's help....