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

sathya66 · Posted 03-12-2018 10:58 AM

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,

SS

kiranv_ · Posted 03-12-2018 11:35 AM

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

LinusH · Posted 03-12-2018 12:42 PM

"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.

Data never sleeps

Ksharp · Posted 03-13-2018 10:01 AM

How about create a VIEW to mask the columns.