topic Re: Encrypt in data step in SAS Enterprise Guide

Encrypt in data step

Harris — Fri, 28 Sep 2018 13:16:57 GMT

Hi,

I have SAS 9.4 and Enterprise guide 7.15 HF3. When I try to make encrypted data, I get error message pop-up window with text:

"The open data operation failed. The following error occured.

[Error] Invalid ENCRYPTKEY value for WORK.SALARY.DATA."

There is no errors in log.

I use example from sas support data step pages, option ENCRYPTKEY.

data salary(encrypt=aes encryptkey=green);
   input name $ yrsal bonuspct;
   datalines;
Muriel    34567  3.2
Bjorn     74644  2.5
Freda     38755  4.1
Benny     29855  3.5
Agnetha   70998  4.1
; 
run;

If I do run same code in basic SAS, there isn't any errors.

Is this bug in Enterprise Guide or something else?

Regars,

Harri S

Re: Encrypt in data step

jebjur — Fri, 28 Sep 2018 13:30:15 GMT

Enterprise guide does not yet support aes-encrypted data sets. It is on our list to add in a future release. A workaround is to create a view based on the encrypted data set, which will allow you to open it in Eguide.

data encrypt_salary(encrypt=aes encryptkey=green);
input name $ yrsal bonuspct;
datalines;
Muriel 34567 3.2
Bjorn 74644 2.5
Freda 38755 4.1
Benny 29855 3.5
Agnetha 70998 4.1
;

data encrypt_salaryV / view=encrypt_salaryV;
set encrypt_salary(encryptkey=green);
run;

Re: Encrypt in data step

Kurt_Bremser — Fri, 28 Sep 2018 13:32:57 GMT

The error happens because EG tries to open the dataset for display, but does not have the key value. You need to run proc print to see the data:

proc print data=work.salary (encrypt=aes encryptkey=green);
run;

It might be a good idea if EG gleaned the encryptkey from the log (as it retrieves the dataset name anyway) and used it to open the dataset.

(note that EG does not have a direct viewtable window like Base SAS, which asks for the key, but actually sends a SQL request - or similar - via the IOM bridge).

Possible material for a SASWare Ballot request: "Add the ability to open encrypted datasets by asking for the key"

Re: Encrypt in data step

VDD — Fri, 28 Sep 2018 13:33:25 GMT

try setting encrypt = yes.

data salary(encrypt=aes encryptkey=green);

Re: Encrypt in data step

Kurt_Bremser — Fri, 28 Sep 2018 13:33:41 GMT

OK, no Ballot idea needed 😉