SASMSTORE

[Anuz]

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, 

[ballardw]

---

@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.

[Anuz]

@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. 

[Reeza]

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.

[Anuz]

@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. 

[SASKiwi]

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.