Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to load an aes encrypted sas dataset in visual analytics

Reply
Contributor
Posts: 54

How to load an aes encrypted sas dataset in visual analytics

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

Super User
Super User
Posts: 7,720

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

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.

Contributor
Posts: 54

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

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

Super User
Super User
Posts: 7,720

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

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?

Contributor
Posts: 54

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

this was a requirement of my project. 

Super User
Posts: 7,436

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

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;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 54

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

HI 

 

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

Super User
Posts: 7,436

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


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 7 replies
  • 409 views
  • 0 likes
  • 3 in conversation