BookmarkSubscribeRSS Feed
colms
Fluorite | Level 6

Hi all

 

I am working with a client and they have their SAS Studio linked to a UNIX server. SAS Studio is version 3.8 and seems to be a standalone installation, no SAS EG or other products.

 

I want to be able to solicit information from a user, I understand that SAS Studio does not have prompts, I did try the custom prompt tasks but they are totally useless at least in this version of Studio.

 

So I was wondering is it possible to call/execute a .sh script whic would open and ask the users in a command window for the required values and pass these either back to SAS Studio or at least to a txt file inside Studio somewhere.

 

There has to be a way to solict info from users who are not technically and only know how to hit run.

 

Thanks in advance

6 REPLIES 6
Tom
Super User Tom
Super User

Custom tasks in SAS/Studio are pretty powerful, certainly more powerful than what could be done quickly using a shell script. I would be surprised if it could not work for you. What types of inputs are you trying to ask the users for?

 

If you build a shell script to run on Unix you will need to show your users how to log onto the Unix server instead of connecting to SAS/Studio.  If you go the trouble of building some other user interface from the Unix prompt then you should probably just run the resulting SAS code directly from that interface by running it like a normal SAS program instead trying to interacting with SAS/Studio at all.

colms
Fluorite | Level 6

Hi there

 

I want to essentially ask user questions should as name the report to run.

 

Example:

 

Prompt: What report would you like to run ?

User Response: Report 1

 

The user would then be able to select ideally from a list of reports or a predefined list. That value should then be passed back to the SAS program code be be use for conditionally running things.

 

Example:

 

%if &prompt1 = "Report 1" %then %do; 

   <some action >

%end;

Kurt_Bremser
Super User

With SAS 9.4, stored processes are the way to build an application interfacing with the user.

The STP writes HTML forms to _webout, and these forms call the same or another STP for processing.

colms
Fluorite | Level 6

This is all i have available to me 

 

colms_0-1729174344343.png

 

colms_1-1729174375185.png

 

 

Tom
Super User Tom
Super User

Make your own.  When we first got SAS/Studio years ago I was able to quickly build a task that allowed users to select from a list of databases (the source of the list is a dataset so the task does not change as new databases are added).

Tom_0-1729215148598.png

One of the nice things about SAS is the commitment to backwards compatibility.  I had not used that task in probably over 5 years and it is still working now, even after SAS/Studio and SAS version upgrades.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 6 replies
  • 429 views
  • 1 like
  • 4 in conversation