topic Using PROC SQL and need to do YEAR(DATE) AS BID_YEAR in SAS Programming

Using PROC SQL and need to do YEAR(DATE) AS BID_YEAR

TMiller16 — Mon, 21 Nov 2016 17:28:55 GMT

I am using EG and PROC SQL to pull the YEAR from a Date field.

So I used:

YEAR(Field_Name) AS BID_YEAR

did the same thing for MONTH, however I am getting this error:

NOTE: Invalid argument to function YEAR. Missing values may be generated.

NOTE: Invalid argument to function MONTH. Missing values may be generated.

So, how does this need to be written?

Re: Using PROC SQL and need to do YEAR(DATE) AS BID_YEAR

mkeintz — Mon, 21 Nov 2016 17:37:08 GMT

Are you sure that the field has no missing values?

Re: Using PROC SQL and need to do YEAR(DATE) AS BID_YEAR

PGStats — Mon, 21 Nov 2016 17:40:52 GMT

Your date variable is probably a SAS datetime, and not a SAS date. Try YEAR(DATEPART(field_name)) as BID_YEAR;

Re: Using PROC SQL and need to do YEAR(DATE) AS BID_YEAR

TMiller16 — Mon, 21 Nov 2016 17:41:12 GMT

Yes, it is coming from an access db, and I checked, it is a date field and there are dates in the tbl. I even went back to make sure I was using the correct syntax and I am

MONTH(BD.BID_DATE) AS BID_MONTH

So I am at a loss...

Re: Using PROC SQL and need to do YEAR(DATE) AS BID_YEAR

TMiller16 — Mon, 21 Nov 2016 17:43:40 GMT

As I was thinking about it, I had to do that for another calculation, so that was the issue! Thank you!!