BookmarkSubscribeRSS Feed
Loko
Barite | Level 11

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

 

1 REPLY 1
MC1985
Obsidian | Level 7

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1174 views
  • 0 likes
  • 2 in conversation