topic Re: Debug error in SAS Programming

Debug error

YannRC — Thu, 14 Aug 2025 11:21:54 GMT

Hi,

Someone can help me. Why I have a synthax error. I'm surprised to see that Datepart is not colored in Blue. My variable is in date format.

It's a FEDSQL

Re: Debug error

LinusH — Thu, 14 Aug 2025 14:30:56 GMT

You must not have a space between <DATE> and your constant.

Re: Debug error

YannRC — Thu, 14 Aug 2025 15:02:39 GMT

It's the same result without space. I remove also all the space. Same error.

😭

Re: Debug error

Tom — Thu, 14 Aug 2025 15:47:12 GMT

What type of library engine is being used by the OA libref you mentioned in your code snippet? Perhaps FEDSQL is having trouble pushing your WHERE clause into an external database?

NOTE: If the variable has DATE values why are you trying to run DATEPART() function on it? That only works when the variable has DATETIME values (what other languages call TIMESTAMP values). DATE values in SAS are number of days since 1960 and DATETIME values are number of seconds. So passing a DATE value to the DATEPART() function will result in the date of 01JAN1960 (or possibly 31DEC1959 if the date was before 1960).

Re: Debug error

SASKiwi — Thu, 14 Aug 2025 20:03:39 GMT

You are using SAS SQL so the correct way to define a date constant in SAS SQL is: '15Jul2025'd

Re: Debug error

LinusH — Fri, 15 Aug 2025 06:02:30 GMT

"It's a FEDSQL"

No it's not, you have "proc sql;" in your program.

If you wish to use FedSQL syntax you actually need to use the FedSQL procedure.

Re: Debug error

jennifertaylor — Tue, 19 Aug 2025 04:57:21 GMT

In FedSQL, the function DATEPART() is not valid, which is why you are getting a syntax error. If your column REPONSE_DATE is already stored as a DATE, you can directly compare it using WHERE t1.REPONSE_DATE = DATE '2025-07-15'. If it is a DATETIME, you should first cast it to a DATE and then compare, for example WHERE CAST(t1.REPONSE_DATE AS DATE) = DATE '2025-07-15'. This will fix your error and run correctly.

Re: Debug error

LinusH — Tue, 19 Aug 2025 07:33:19 GMT