Hide table from users while loading prompts

Loko — Thu, 03 Mar 2016 10:29:19 GMT

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

Re: Hide table from users while loading prompts

MC1985 — Wed, 06 Jul 2016 12:45:54 GMT

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

topic Re: Hide table from users while loading prompts in Developers

Hide table from users while loading prompts

Re: Hide table from users while loading prompts