topic Encryption of Bulk Datasets in SAS Programming

Encryption of Bulk Datasets

vidhya — Wed, 11 Apr 2018 15:52:17 GMT

Hi Team,

I need to encrypt bulk SAS dataset of new server. The SAS dataset version is 9.2. Any expert help me on this.

Re: Encryption of Bulk Datasets

ChrisNZ — Thu, 12 Apr 2018 00:26:41 GMT

You need to recreate the tables if you encrypt them.

So one data step for each table is pretty much your only option.

Maybe something like:

data _null_;  
   set SASHELP.VSTABLE; 
   where LIBNAME='WORK';
   call execute(catt('data NEWLIB.', MEMNAME, '(encrypt=); set WORK.', MEMNAME, ';run;'));
run;

Re: Encryption of Bulk Datasets

vidhya — Thu, 12 Apr 2018 16:49:56 GMT

Thanks chris