topic Re: Proc sql error. Classification error in SAS Programming

Proc sql error. Classification error

Seyllia — Mon, 22 Feb 2021 15:14:51 GMT

Hello, I'm obtaining this error and I don't know what it means or how to trace it back. Any idea?

The raw sql code should work, I'm trying all the parts by separate but nothing.

The error says in spanish: Classification execution problem.

Maybe is related with the column names being repeated or so?

I attatch a screenshot of the log.

Re: Proc sql error. Classification error

Reeza — Mon, 22 Feb 2021 17:03:39 GMT

The SUBSTR() of a date and comparison to the '2019-02-14' formatted date usually isn't correct syntax.
And yes, if you have multiple columns with the same name, that will cause errors.

In the future please post your code and log as text, not as images, it's quite hard to read, and it's much easier to highlight or copy/paste the lines that may be the source of the errors.

@Seyllia wrote:

Hello, I'm obtaining this error and I don't know what it means or how to trace it back. Any idea?

The raw sql code should work, I'm trying all the parts by separate but nothing.

The error says in spanish: Classification execution problem.

Maybe is related with the column names being repeated or so?

I attatch a screenshot of the log.

Re: Proc sql error. Classification error

PGStats — Mon, 22 Feb 2021 19:03:20 GMT

I think your reference to ESTOWN02 in the FROM clause should be replaced with your libname CUENTAS.