topic Re: How to extract YEAR data from yymmddn8 in SAS Programming

How to extract YEAR data from yymmddn8

Songchan — Wed, 19 Sep 2018 16:27:55 GMT

Hi guys,

I want exact only YEAR data from a date format like yymmddn8. How can I do it? I tried the following codes, but it didn't work.

I would appreciate your helps very much!

data year01;set year 
year=substr(date,1,4);
yr=mdy(year);
format yr yyn4.;
run;

novinosrin — Wed, 19 Sep 2018 16:32:10 GMT

year function?

year=year(date);

This assumes your date is a numeric sas date variable

Songchan — Wed, 19 Sep 2018 16:38:33 GMT

Thank you so much!

ballardw — Wed, 19 Sep 2018 20:45:25 GMT

Or don't create an additional variable and just use the YEAR4. Format for your date variable in any procedure.