Programming the statistical procedures from SAS

Extract year from a date

Reply
New Contributor
Posts: 4

Extract year from a date

I would like to extract the only year from the date as a new variable how do I write the program?

Super User
Posts: 23,722

Re: Extract year from a date

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?


 

New Contributor
Posts: 4

Re: Extract year from a date

Thank you guys this was helpful.

Frequent Contributor
Posts: 103

Re: Extract year from a date

@Hope18 You could close the thread by marking @Reeza 's answer as accepted solution

Valued Guide
Posts: 593

Re: Extract year from a date

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.

Ask a Question
Discussion stats
  • 4 replies
  • 169 views
  • 0 likes
  • 4 in conversation