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.
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.);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.