topic Re: Create Year Column in SAS Programming

Create Year Column

DavidPhillips2 — Tue, 24 Nov 2015 15:54:23 GMT

I am trying to save the numeric year as a column based off of a data column.

In a datastep I have

Year = year(Project_Start);

Oddly the year returns blank. In the log there is this line:

NOTE: Invalid argument to function YEAR(1772409600) at line 80 column 9.

Reeza — Tue, 24 Nov 2015 15:59:17 GMT

Is project_start a datetime? If so, use the datepart function to take the date part first.

year=year(datepart(project_start));

Haikuo — Tue, 24 Nov 2015 16:11:48 GMT

Most likely you are dealing with a date-time value instead of date. Try this:

Year = year(datepart(Project_Start));

Or this:

Year=input(put(Project_Start,dtyear4.),4.);