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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.