topic Re: Help with date in SAS Procedures

Help with date

pp2014 — Thu, 08 May 2014 17:45:36 GMT

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?

stat_sas — Thu, 08 May 2014 18:31:15 GMT

You can try this.

data have;

dt="201405";

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

run;

proc print data=have;

run;

jenrscott827 — Thu, 08 May 2014 19:30:08 GMT

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

This is what I do.

PGStats — Thu, 08 May 2014 20:22:48 GMT

Or year = floor(Date/100);

This is what I would do.