How to load an aes encrypted sas dataset in visual analytics

[naveenraj]

I am having difficulty loading an AES encrypted dataset created from enterprise guide into SAS visual analytics. Can someone help me

[RW9]

The topic of AES encryption on third party files has been covered several times:

https://communities.sas.com/t5/forums/searchpage/tab/message?filter=labels&q=aes

To my mind this is part of the transfer process, and the file should be un-encrypted as part of your import process, either by IT, through the recieving application, or by you using a tool for the job.  It is not a SAS implementation.  If you really need to do it in SAS then you would call a command line application to un-encrypt the data something like:

x "c:\aesdecrpt c:\your_file.txt c:\outputfile.txt";

And then import the un-encypted file.

[naveenraj]

hi rw9,

This is not my requirement. I have created a dataset through encrypt option present within sas enterprise guide. Now i need to load this dataset into sas visual analytics. We are not using an external file. this is a sas dataset that we created manually

[RW9]

Which raises the question, why are you creating an encrypted file if it is not going outside your control, seems to just add a layer of complexity with no benefit?

[naveenraj]

this was a requirement of my project. 

[Kurt_Bremser]

Have you tried code like this (from http://support.sas.com/documentation/cdl/en/inmsref/67597/HTML/default/viewer.htm#p1qf09ffb3hr02n1bt...😞

libname server1 startserver port=10010 tag='hps';

data server1.prdsale;
    set sashelp.prdsale;
run;

If a dataset is encrypted, you would need to supply the password as a dataset option:

libname server1 startserver port=10010 tag='hps';

data server1.xxxxx;
    set inlib.xxxxx (read=password);
run;

[naveenraj]

HI KurtBremser

My enterprise guide and visual analytics are on differant servers. So how can we write a datastep in sas visual analytics process. Sorry if this is not a valid question. i am new to visual analytics.

Regards,

Naveen

[Kurt_Bremser]

---

naveenraj wrote:

i am new to visual analytics.

---

Which means you know more than me, because I don't have VA at all. I just want to point you in the right direction of the documentation.

If you can't extract the real SAS code for loading a SAS dataset from the interactive tools (so you can insert the encypted dataset name and the datastep option there), you're better off by creating an unencrypted copy of the dataset in EG and then use the VA tools to load that.