https://communities.sas.com/t5/SAS-Enterprise-Guide/Como-cuantificar-un-error-y-guardarlo-en-una-macro-en-SAS/m-p/852749#M41970 Hola Abel,<BR /><BR />You will probably have to provide a bit more details.<BR />I assume you're using SAS StudioV available through the menu option "Develop SAS Code".<BR />If yes are you just assigning caslibs to SAP HANA or is your code more complex?<BR /><BR /><BR />Saludos, Jos Mon, 09 Jan 2023 10:21:38 GMT JosvanderVelden 2023-01-09T10:21:38Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Como-cuantificar-un-error-y-guardarlo-en-una-macro-en-SAS/m-p/852247#M41960 <P><SPAN class="jCAhz ChMk0b"><SPAN class="ryNqvb">Good morning, in several SAS programs I have connectors with HANA Studio, these connectors must have a user and a defined password.</SPAN></SPAN> <SPAN class="jCAhz ChMk0b"><SPAN class="ryNqvb">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</SPAN></SPAN> <SPAN class="jCAhz ChMk0b"><SPAN class="ryNqvb">, the HANA Studio password is locked.</SPAN></SPAN> <SPAN class="jCAhz ChMk0b"><SPAN class="ryNqvb">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.</SPAN></SPAN> <SPAN class="jCAhz ChMk0b"><SPAN class="ryNqvb">Could someone give me a hand on how to do this?</SPAN></SPAN></P> Thu, 05 Jan 2023 10:09:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Como-cuantificar-un-error-y-guardarlo-en-una-macro-en-SAS/m-p/852247#M41960 Abelp9 2023-01-05T10:09:32Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Como-cuantificar-un-error-y-guardarlo-en-una-macro-en-SAS/m-p/852749#M41970 Hola Abel,<BR /><BR />You will probably have to provide a bit more details.<BR />I assume you're using SAS StudioV available through the menu option "Develop SAS Code".<BR />If yes are you just assigning caslibs to SAP HANA or is your code more complex?<BR /><BR /><BR />Saludos, Jos Mon, 09 Jan 2023 10:21:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Como-cuantificar-un-error-y-guardarlo-en-una-macro-en-SAS/m-p/852749#M41970 JosvanderVelden 2023-01-09T10:21:38Z