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,
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.
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.
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.
Compile macro with secure and store options - see example 5 in documentation.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.