BookmarkSubscribeRSS Feed
CarlS
Calcite | Level 5

Dear All,

I have a field that I use in an information map and that should not be seen by some users. How can I hide this ? Is there the possibility for column level security in the information map studio ? if not, what is in your oppinion a good workaround ?

Kind regards

Carl

4 REPLIES 4
sks
Fluorite | Level 6 sks
Fluorite | Level 6

Carl,

      How are the users accessing the SAS information map. If you have created a web report using the information map, then you can create a report specifically for these users and let them see the field and probably another report for the rest of the users without the specific field.

Shri

Madelyn_SAS
SAS Super FREQ

Column-level security is not supported (http://support.sas.com/kb/45/094.html). You will have to create a different information map for each set of users.

marius_sommerseth
Calcite | Level 5

Hi Carl,

You unforunately can't hide (as this would change the Metadata making the report invalid), a workaround would be to set all of the values in this column to something else (for instance missing). So som users see the data, others don't.

I would do it in one of two ways:

- Use a STP in the Information Map to subset the data (set the column to " " for instance). See http://support.sas.com/kb/39/432.html.

- Create a underlying view that either uses a lookup table or a variable (for instance the username) to show a empty column for some users, and the original column for others and then create the Information Map on this view instead of directly on the table.

Have a great weekend,

Marius

MicheleS_SAS
SAS Employee

Hi CarlS,

I've found this article, maybe it could be useful to you: http://www.zencos.com/2012/04/column-level-security-for-web-reports/

You have to create two infomap and two reports

Michele

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1318 views
  • 0 likes
  • 5 in conversation