SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Frequent Contributor
Posts: 76

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

[ Edited ]

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 

PROC Star
Posts: 504

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

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

 

Super User
Posts: 5,853

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

"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
Super User
Posts: 10,699

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

How about create a VIEW to mask the columns.

Ask a Question
Discussion stats
  • 3 replies
  • 131 views
  • 0 likes
  • 4 in conversation