Create Year Column

[DavidPhillips2]

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 · Accepted solution]

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

year=year(datepart(project_start));

[Haikuo]

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.);