Data Masking on SAS Enterprise Guide

[breadmaker]

Hi guys,

I want to create a Unique Identifier using hash for multiple columns. (I am not sure if I am using the correct terminology)

Taking the baseball data set as an example:

I want to hash the personal identifiable information ('Name' column), and still show other columns ('nAtBat', 'nHits') when one queries. 

I just started the task and have the following code:

I want to know how to hash the 'name' column. 

Could you guys please tell me any method I can use or any resources I can look into?

Thanks in advance!

[SASKiwi]

@breadmaker - the type of masking / hashing you want is available with the MD5 function: https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0mu81ozw0013yn1kzwve5ola26e.htm...

[breadmaker]

Hi,

When I tried to implement hashing, I got the error of "HASHING is unknown".

Here is my code:

DATA HASH_BASEBALL;
    SET SASHELP.BASEBALL;
    MD5 = HASHING('MD5', Name);
RUN;

Here is the error:

68
ERROR 68-185: The function HASHING is unknown, or cannot be accessed.

Do you happen to know the reason for this error?

[SASKiwi · Accepted solution]

@breadmaker - Try the example in the link I sent you:

data _null_;
   y=md5('abc');
   z=md5('access method');
   put y=/ y=$hex32.;
   put z=/ z=$hex32.;
run;

[breadmaker]

Thanks!