The topic of AES encryption on third party files has been covered several times:
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.
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
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;
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.