I would like to extract the only year from the date as a new variable how do I write the program?
It depends, but usually you would use a data step and the YEAR() function for starters.
You can run the example below.
data year_demo;
set sashelp.stocks;
year = year(date);
run;
@Hope18 wrote:
I would like to extract the only year from the date as a new variable how do I write the program?
It depends, but usually you would use a data step and the YEAR() function for starters.
You can run the example below.
data year_demo;
set sashelp.stocks;
year = year(date);
run;
@Hope18 wrote:
I would like to extract the only year from the date as a new variable how do I write the program?
Thank you guys this was helpful.
It depends on how your date is stored - for example if it's a SAS datetime you can use the date part function http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0rttbu7w62xgzn1damccyuwpld8.htm&... or if it's a character then the substr function http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0n08xougp40i5n1xw7njpcy0a2b.htm&...
If you tell us how it's stored we can give you a concrete example.
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.