topic Re: How to send over a macro to share without exposing the codings?! in SAS Programming

How to send over a macro to share without exposing the codings?!

hellohere — Mon, 29 Jul 2024 15:44:17 GMT

Say need to let someone at another city to run a home-made SAS macro, AND does not want to expose the coding

details, HOW TO DO IT?! Thanks,

Re: How to send over a macro to share without exposing the codings?!

hellohere — Mon, 29 Jul 2024 16:11:37 GMT

First is this feasible, to send over without code exposing?

Second, if yes, how to do it?!

The guy is using the same SAS platform.

Re: How to send over a macro to share without exposing the codings?!

ChrisHemedinger — Mon, 29 Jul 2024 16:18:52 GMT

Others might chime in with some best practices, but basically you can use the STORE and SECURE options for compiling a macro to a SAS catalog file that you can share. The SECURE option prevents the user from seeing the source code.

Documentation about these options here.

Re: How to send over a macro to share without exposing the codings?!

ballardw — Mon, 29 Jul 2024 16:42:35 GMT

Don't lose your source code. We've had several requests for recovering the code from such secure compiled macros and that has been a no-go.

Compiled macro catalogs are also version specific to a great extent. If you compile the code with SAS 9.4.7 and the other person is using 9.4.4 it may not run. Or on a different OS.

Re: How to send over a macro to share without exposing the codings?!

Reeza — Mon, 29 Jul 2024 16:44:30 GMT

Compile macro with secure and store options - see example 5 in documentation.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1nypovnwon4uyn159rst8pgzqrl.htm#p05y391rq3drjgn1pv40fng2kc3u

To share the compiled macro

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/n0sjezyl65z1cpn1b6mqfo8115h2.htm

Paper with more info

https://www.mwsug.org/proceedings/2011/appdev/MWSUG-2011-AD13.pdf