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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.