topic Re: SAS DATES in SAS Procedures

SAS DATES

robertrao — Wed, 29 May 2013 16:43:44 GMT

Hi ,

How can i extracct the year from

1)date10. (2012-11-20)

Using substring or is there any other logic??

I want 2012

Thanks

Re: SAS DATES

ballardw — Wed, 29 May 2013 17:20:29 GMT

if the value is an actual SAS date with format date10. , or actually any format,

then

year = year(datevariablename);

There are functions to pull month, day of month, day of week, quarter as well from the date values.

Re: SAS DATES

robertrao — Wed, 29 May 2013 17:28:53 GMT

Hi,

Thanks so much for the information

I have the datevariablename as numeric

when i do

year=year( datevariablename) i get year variable as charecter.How is that happening? i was expecting year variable to be numeric too since the parent was numeric

Thanks

Re: SAS DATES

Reeza — Wed, 29 May 2013 17:42:32 GMT

Because you made a mistake somewhere.

Post your full code.

Re: SAS DATES

robertrao — Wed, 29 May 2013 17:48:35 GMT

Hi,

DATE beow is numeric

data WANT;

set have;

year=year(DATE);

run;

Re: SAS DATES

Haikuo — Wed, 29 May 2013 17:55:42 GMT

Run this:

proc contents data=want;

run;

Then post the results.

Re: SAS DATES

Astounding — Wed, 29 May 2013 17:58:30 GMT

Most likely, YEAR is already in your data set before you started. So you can't change it to numeric. But you could drop it:

data want;

set have (drop=year);

year = year(date);

run;

Re: SAS DATES

robertrao — Wed, 29 May 2013 18:12:56 GMT

Thanks for the help. I got it. I have used put function and forgot to rerun the code

Sorry for the trouble

Re: SAS DATES

robertrao — Wed, 29 May 2013 18:15:31 GMT

Now I have the year variable under which there are 2011,2010, 2012 and so on.

how can i use the proc report to get only the particular years report????

without subsetting in the original dataset

Regards

Re: SAS DATES

Tom — Wed, 29 May 2013 20:58:31 GMT

Look of the WHERE statement. It is not limited to PROC REPORT.