topic extract the year from the data variable in SAS Programming

extract the year from the data variable

ali_far — Sat, 08 Jul 2017 06:55:16 GMT

Hi every one,

I have tried many ways to extrat the year from the date variable of my data set.however. non of them works(substr statement etc)

i even change the format of variable.

note: the format of the varibale in the manual book is shown : Text (7) (YYYY-MM)

variable what i want

data_of_brith year

01APR24:00:00:00 24

01AUG25:00:00:00 25

01DEC32:00:00:00 32

...

my code:

data want;
set have;
year = input(substr(data_of_brith, 6), 2.);
run;

the result are: 82, 61, 46 instead of 24, 25, 32 that i was expecting!!!!!

your hepl will be really appreciated

Re: extract the year from the data variable

SASKiwi — Sat, 08 Jul 2017 07:26:01 GMT

Use the YEAR function which includes century as well to avoid confusion. Your post isn't clear but it looks like your birthdate variable is a datetime. If so you need to add DATEPART:

year = year(datepart(data_of_brith));

Re: extract the year from the data variable

ali_far — Sat, 08 Jul 2017 07:24:56 GMT

Thanks for your reply , but it tried before this and it did not work. it gave me null for the whole column...

Re: extract the year from the data variable

SASKiwi — Sat, 08 Jul 2017 07:28:08 GMT

See my changed post adding DATEPART. Please confirm if your variable is in DATETIME or DATE format.

Re: extract the year from the data variable

Kurt_Bremser — Sat, 08 Jul 2017 07:34:14 GMT

Post the log of the failed step.

Re: extract the year from the data variable

ali_far — Sat, 08 Jul 2017 07:46:45 GMT

many thanks ir worked well.

Re: extract the year from the data variable

ali_far — Sat, 08 Jul 2017 07:47:27 GMT

thanks it is solved