Automatic Filtering of User Data

In some situations data might be user sensitive and locked down such that only the owner can view it. There is a quick method of automatically setting this up by using Data Step Views and capturing the user logging details.

By creating a view using PROC SQL we can pre-filter the data so that only data related to the owner (userid) present in the table is matched against the user logging details. The SQL procedure contains a USER literal word to achieve this, but otherwise using the &SYSUSERID macro variable can also produce the required results.

data sales;
  set sashelp.shoes;
  length userid $20;
  if region='Africa' then userid='John Smith';
  else if region='Asia' then userid='Elena.Muriel';
  else if region='Canada' then userid='';
  else if region='Pacific' then userid='';
run;

proc sql; 
create view mysales as 
              select * from sales 
where upcase(userid)=upcase(user); 
quit;

Automatic filtering will occur when accessing the view created.