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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.