topic How to load an aes encrypted sas dataset in visual analytics in SAS Visual Analytics

How to load an aes encrypted sas dataset in visual analytics

naveenraj — Tue, 19 Apr 2016 09:01:33 GMT

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

Re: How to load an aes encrypted sas dataset in visual analytics

RW9 — Tue, 19 Apr 2016 09:08:01 GMT

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.

Re: How to load an aes encrypted sas dataset in visual analytics

naveenraj — Tue, 19 Apr 2016 09:11:18 GMT

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

Re: How to load an aes encrypted sas dataset in visual analytics

Kurt_Bremser — Tue, 19 Apr 2016 09:13:47 GMT

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

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;

Re: How to load an aes encrypted sas dataset in visual analytics

naveenraj — Tue, 19 Apr 2016 11:26:35 GMT

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

Re: How to load an aes encrypted sas dataset in visual analytics

Kurt_Bremser — Tue, 19 Apr 2016 11:51:47 GMT

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.

Re: How to load an aes encrypted sas dataset in visual analytics

RW9 — Tue, 19 Apr 2016 12:07:59 GMT

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?

Re: How to load an aes encrypted sas dataset in visual analytics

naveenraj — Tue, 19 Apr 2016 12:12:01 GMT

this was a requirement of my project.