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
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));
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));
Thanks for your reply , but it tried before this and it did not work. it gave me null for the whole column...
See my changed post adding DATEPART. Please confirm if your variable is in DATETIME or DATE format.
many thanks ir worked well.
thanks it is solved
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.