topic Re: SASMSTORE in SAS Programming

SASMSTORE

Anuz — Fri, 29 Oct 2021 14:18:10 GMT

Hi,

I have inherited some code. The team and coders are no longer around.

I am trying to figure out details of the complied macros that is used. This is what I have

options mstored sasmstore=anscloc;

%conn_ab;

How can I find out the location of the sasmstore - anscloc or what is the code included in the macro conn_ab ?

From what I can see conn_ab is setting some values for a connection.

Without running the macro the subsequent code fails which is a load to Hadoop.

Can anyone help with the above please ? Thank you,

Re: SASMSTORE

ballardw — Fri, 29 Oct 2021 14:54:41 GMT

@Anuz wrote:

Hi,

I have inherited some code. The team and coders are no longer around.

I am trying to figure out details of the complied macros that is used. This is what I have

options mstored sasmstore=anscloc;

%conn_ab;

How can I find out the location of the sasmstore - anscloc or what is the code included in the macro conn_ab ?

From what I can see conn_ab is setting some values for a connection.

Without running the macro the subsequent code fails which is a load to Hadoop.

Can anyone help with the above please ? Thank you,

In your statements ANSCLOC would be the name of a LIBRARY. If you did not inherit any code assigning the ANSCLOC library this might be a tad difficult to find. The specified library should have a Catalog named SASMACR with the compiled versions of the macros.

The note is likely of interest: http://support.sas.com/kb/22/352.html If whoever compiled the macros and did not use the SOURCE option you are not likely to find the code used.

Re: SASMSTORE

Reeza — Fri, 29 Oct 2021 17:18:02 GMT

Often programmers store code with the same name as the macro. If you haven't already try searching your file system for a file called %conn_ab.

Re: SASMSTORE

Anuz — Sat, 30 Oct 2021 19:29:02 GMT

@Reeza - Unfortunately the code is not available. I can only assume once they compiled the macro they didn't save it. Already searched for it.

Re: SASMSTORE

Anuz — Sat, 30 Oct 2021 19:31:10 GMT

@ballardw with some digging I found the location of the complied macro.

It was listed in SAShelp.vslib. Don't know yet how to find the source code.

Re: SASMSTORE

SASKiwi — Mon, 01 Nov 2021 00:11:17 GMT

What are the Hadoop load error messages? What should give you some clues as to what the macro is doing. I'm guessing that it is hiding a user account / password along with possibly a complete connection string. Looking at what may be missing from the Hadoop load code might help too.