topic Re: DATETIME22.3 to year in SAS Procedures

DATETIME22.3 to year

NOA — Thu, 13 Mar 2014 14:50:08 GMT

I am obviously a self taught SAS user and a newbie. Any sort of help is appreciated.

I have a variable called EVENTDATE and according to PROC CONTENTS the format for this variable is DATETIME22.3. I would like to run an analysis using only the year part --not interested about the month, day or time. Can anyone tell me the sas code so I can extract the year so I can run a basic analysis?

Thank you.

Re: DATETIME22.3 to year

RW9 — Thu, 13 Mar 2014 14:57:16 GMT

You could try: year(*)

where the * is replaced by your date variable name.

Re: DATETIME22.3 to year

Reeza — Thu, 13 Mar 2014 14:58:24 GMT

Year= year(datepart(variable));

Or depending on the proc you can simply apply a format to your variable of

format variable dtyear.;

Re: DATETIME22.3 to year

BrunoMueller — Thu, 13 Mar 2014 14:58:44 GMT

There are various ways, using DATEPART and YEAR function or DTYEAR format, see below

data have;
  eventDate = datetime();
  format eventDate datetime22.3; 

  eventYear = year( datepart(eventDate) );
  eventYear_c = put(eventDate, dtyear4.);
run;

Re: DATETIME22.3 to year

NOA — Thu, 13 Mar 2014 15:22:00 GMT

Mr. Bruno Muller thank you. It worked but for some reason the only year the comes out is 2014. I can see in the LOG that my EVENTDATE are all from today.

When i looked in the SQL server database I am using, the dates ranged from 2008-2014. Any idea what might be going on?

Re: DATETIME22.3 to year

BrunoMueller — Thu, 13 Mar 2014 15:31:25 GMT

Just in case the two lines

eventDate = datetime();
format eventDate datetime22.3;

are only for testing purposes, they are not needed in your code

Re: DATETIME22.3 to year

Reeza — Thu, 13 Mar 2014 15:32:28 GMT

Post your code

Re: DATETIME22.3 to year

NOA — Thu, 13 Mar 2014 15:44:39 GMT

I got it to work. Thank you!

Re: DATETIME22.3 to year

Reeza — Thu, 13 Mar 2014 15:51:14 GMT

mark as answered please