topic Re: How to create a new column with only "year" from the column contains MM/DD/YYYY? in SAS Programming

How to create a new column with only "year" from the column contains MM/DD/YYYY?

Denali — Fri, 24 Sep 2021 16:04:23 GMT

Hi,

I have a column contains date information (MM/DD/YYYY) as below. How do I create a new column that only contains the "year" from this column? For example, the first row of the new column is 2015, and the next two rows are 2018.

Date

08/18/2015

01/15/2018

10/01/2018

Thank you all in advance!

Re: How to create a new column with only "year" from the column contains MM/DD/YYYY?

PaigeMiller — Fri, 24 Sep 2021 16:33:50 GMT

If these are NUMERIC date values then this should work

data want;
     set have;
     year=year(date);
run;

If these are CHARACTER date values

data want;
     set have;
     date=input(date,mmddyy10.);
     year=year(date);
run;

Re: How to create a new column with only "year" from the column contains MM/DD/YYYY?

ballardw — Fri, 24 Sep 2021 17:26:05 GMT

What will you use that Year value for?

In many cases if the value is an actual SAS date value you would just assign the Year. format for many things.