topic Re: Non-reversible hash in SAS7.1 in SAS Programming

Non-reversible hash in SAS7.1

cherryhezy — Mon, 14 Dec 2020 23:32:14 GMT

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!

Re: Non-reversible hash in SAS7.1

ballardw — Mon, 14 Dec 2020 23:44:37 GMT

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.

Re: Non-reversible hash in SAS7.1

SASKiwi — Tue, 15 Dec 2020 00:30:37 GMT

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.);

Re: Non-reversible hash in SAS7.1

ChrisNZ — Tue, 15 Dec 2020 00:55:38 GMT

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.

Re: Non-reversible hash in SAS7.1

andreas_lds — Tue, 15 Dec 2020 07:46:08 GMT

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;