BookmarkSubscribeRSS Feed
pp2014
Fluorite | Level 6

I have date which is numeric format. I want the year from that.  I am getting blank value.

my date1 variable is yymmn6.  format.  For example if I have date1 = 201405,  I should get 2014, but I get blank value for year.

Can anybody help me, please?

3 REPLIES 3
stat_sas
Ammonite | Level 13

You can try this.

data have;

dt="201405";

yr=year(input(dt,yymmn6.));

run;

proc print data=have;

run;

jenrscott827
Calcite | Level 5

input(put(Date,6.),4.)

This is what I do. 

PGStats
Opal | Level 21

Or year = floor(Date/100);

This is what I would do.

PG

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1071 views
  • 0 likes
  • 4 in conversation