- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi all, I am new to hashing/encypting data. Is there a non-reversible hashing function? I need to hash confidential customer information. I am using Enterprise Guide 7.1. Therefore functions in any version after that wouldn't be accessible for me. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
See if the SHA256 function is available.
Since Enterprise Guide is not my strong point and know that the 7.versions are old-ish I'll leave it up to you to see if available.
Or run some code like:
data _null_; y=sha256('abc'); z=sha256('access method'); put y=$hex64.; put z=$hex64.; run;
and see if you get an error. The output in the log varies depending on OS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The MD5 function is another way of hashing that is irreversible and converting it to hex makes it even harder.
MyKeyHashed = put(md5(cats('MyHashedKey',MyKeyVar)),$hex10.);
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Enterprise Guide is a dumb interface.
It doesn't run any code.
The SAS version to which you connect from EG is what validates what you can run.
Function SHA256 has been around for a while, so you probably can run it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What @ChrisNZ wanted to point out is, that the version of Enterprise Guide is hardly relevant when talking about functions. Important alone is the version of the executing sas-environment. You can check that version by executing
%put &=SysVLong;