Your SAS programs, embedded in web apps and elsewhere

Hide table from users while loading prompts

Reply
Super Contributor
Posts: 305

Hide table from users while loading prompts

Dear All,

 

I have a sas process which loads info from a table within the prompts defined.

The users run the procedure from Excel Sas-Add-Inn.

 

Is there a way to hide this table so the users can not open it with Sas-Add-Inn?

 

I have tried to disable rights from accessing the table but in this way the prompts do not fill-in with info but remain empty.

I have also tried to set to 1 the option - IsHidden - from Table Advanced Properties within Sas Management COnsole, but

without success.

 

I'm using Sas9.3.

 

10x

 

Contributor
Posts: 34

Re: Hide table from users while loading prompts

I think for a twisted work-around:

1. - make a StoredProcess that call another with the dynamic prompt;

2 - the first STP create Metadata table (http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/viewer.htm#a003114179.htm ) before the second STP run;

3 - when Second STP run can read values for table in the dynamic prompt;

4 - before Endind of second STP delete metadata table (http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/viewer.htm#a003114182.htm)

 

you can try to put the creation of metadata table at the beginning of the STP, and the delete after, but i don't test it and i think that can be an ERROR.

 

hope this help

sorry but i didn't have a simple way

have nice day

MC

 

Martino Crippa
Ask a Question
Discussion stats
  • 1 reply
  • 274 views
  • 0 likes
  • 2 in conversation