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

[sathya66]

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_]

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]

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

[Ksharp]

How about create a VIEW to mask the columns.