Encryption of Bulk Datasets

[vidhya]

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.

[ChrisNZ]

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;

[vidhya]

Thanks chris