topic Re: How to save MACRO unviewable to anyone?! in SAS Programming

How to save MACRO unviewable to anyone?!

hellohere — Tue, 29 Mar 2022 06:44:56 GMT

Need run code on a server, for security concerns, do not like anyone to see the SAS code.

How to save MACRO encrypted and unviewable to anyone?! Thanks,

Re: How to save MACRO unviewable to anyone?!

hellohere — Tue, 29 Mar 2022 06:48:31 GMT

Also anyway to require a passwd to run a macro?! If passwd does not match, write into log(encrypted, not-directly-readable)?!

Re: How to save MACRO unviewable to anyone?!

japelin — Tue, 29 Mar 2022 07:58:38 GMT

First, the macro code is stored encrypted by specifying the /store secure option to the macro.

Also, specify options such as nosource nosource2 nomlogic nosymbolgen nomprint when executing the macro. Prevent sas code from being output to the log.

This will keep the sas code secret.

libname macout 'C:\temp';
options mstored sasmstore=macout;

%Macro samplemacro /STORE SECURE;
  options nosource nosource2 nomlogic nosymbolgen nomprint;
  /* describe your code below */
%Mend;

Re: How to save MACRO unviewable to anyone?!

Quentin — Tue, 29 Mar 2022 11:02:43 GMT

@hellohere wrote:

Also anyway to require a passwd to run a macro?! If passwd does not match, write into log(encrypted, not-directly-readable)?!

It would be a hack, but I suppose you could have a password= parameter.

Then in the macro definition, something like:

%if &password ne SecretPassword %then %do ;
  %put ERROR: incorrect password, macro exiting ;  
  %return ;
%end ;

Re: How to save MACRO unviewable to anyone?!

yabwon — Tue, 29 Mar 2022 12:01:32 GMT

You could try the GSM (Generate Secure Macros) package:

https://github.com/yabwon/SAS_PACKAGES/blob/main/packages/gsm.md

All the best

Bart

Re: How to save MACRO unviewable to anyone?!

Ksharp — Tue, 29 Mar 2022 12:04:17 GMT

https://communities.sas.com/t5/SAS-Programming/How-to-hide-SAS-macro-source-code/m-p/773087

Re: How to save MACRO unviewable to anyone?!

hellohere — Tue, 29 Mar 2022 13:45:05 GMT

How to download and install the package?!

Re: How to save MACRO unviewable to anyone?!

yabwon — Tue, 29 Mar 2022 13:57:37 GMT

Hi,

Start with reading Readme.md here:

https://github.com/yabwon/SAS_PACKAGES

Then you can check out this presentation:

https://github.com/yabwon/SAS_PACKAGES/blob/main/SPF/Documentation/Getting_Started_with_SAS_Packages.pdf

and eventually watch the recording from BASUG meetup:

https://www.basug.org/videos?wix-vod-video-id=78067e61413d43d3a6951974b3bc3014&wix-vod-comp-id=comp-klv807gt

All the best

Bart

Re: How to save MACRO unviewable to anyone?!

Tom — Tue, 29 Mar 2022 14:20:19 GMT

What possible justification is there for hiding the source code for something that you are going to let people run?

Re: How to save MACRO unviewable to anyone?!

ballardw — Tue, 29 Mar 2022 15:37:44 GMT

Large economy sized hint: What ever approach you use make 100% sure that you have the code saved, backed up, documented where that source is kept, and in multiple places.

We have seen several requests on this forum for "recovering the code" from a "secured" macro because they need to modify it. But the original code has been lost/moved/moved to Texas or similar. The typical approaches won't allow code recovery so the user years later is left unsupported.