Como cuantificar un error y guardarlo en una macro en SAS.

[Abelp9]

Good morning, in several SAS programs I have connectors with HANA Studio, these connectors must have a user and a defined password. I'm trying to make a macro so that when the credentials of the first user fail, it will go to the second user and try it with the credentials of the second user because if it tries again with the first user 3 more times and the login data is incorrect , the HANA Studio password is locked. That's why I would need to somehow quantify the first login error in some macro or something, so that if there is such an error it can test the other user using macros and conditionals. Could someone give me a hand on how to do this?

[JosvanderVelden]

Hola Abel,

You will probably have to provide a bit more details.
I assume you're using SAS StudioV available through the menu option "Develop SAS Code".
If yes are you just assigning caslibs to SAP HANA or is your code more complex?


Saludos, Jos