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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.