Proc sql error. Classification error

[Seyllia]

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.

[Reeza]

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.

---

[PGStats]

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