topic Re: Data Masking on SAS Enterprise Guide in SAS Programming

Data Masking on SAS Enterprise Guide

breadmaker — Mon, 20 Apr 2020 15:43:53 GMT

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 — Mon, 20 Apr 2020 20:29:24 GMT

breadmaker — Tue, 21 Apr 2020 20:21:34 GMT

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 — Tue, 21 Apr 2020 20:38:18 GMT

@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 — Wed, 22 Apr 2020 18:28:58 GMT

Thanks!