topic Re: How to mask personal data(columns) in all library tables in SAS Data Management

How to mask personal data(columns) in all library tables

sathya66 — Mon, 12 Mar 2018 16:45:17 GMT

Hi all,

how to mask the variables with personal data in all libraries without affecting the daily reports.

we have nearly 10 libraries all are using personal data so now we are in the process to mask them to the all users.

Jobs are automated and running on daily , weekly and monthly basis.

Thanks,

Re: How to mask personal data(columns) in all library tables

kiranv_ — Mon, 12 Mar 2018 15:35:21 GMT

I did this by creating views in databases, I do not have much idea as much as in SAS, but below are some resources which are interesting and will take you forward.

http://mwsug.org/proceedings/2016/RF/MWSUG-2016-RF10.pdf

https://communities.sas.com/t5/Ask-the-Expert/Virtualizing-Enterprise-Data/ta-p/391452

Re: How to mask personal data(columns) in all library tables

LinusH — Mon, 12 Mar 2018 16:42:20 GMT

"help me with the programme".
Can you be a bit more specific?
We are not going to do the job for you, at best put you in the right direction.

Re: How to mask personal data(columns) in all library tables

Ksharp — Tue, 13 Mar 2018 14:01:34 GMT

How about create a VIEW to mask the columns.