BookmarkSubscribeRSS Feed
Dreamer
Obsidian | Level 7

Hi,

Currently I'm using a enterprise scheduler "Tidal" to schedule my SAS EGP processes.

It triggers a vbscript which intern runs EGP Process.

But few of my EGP processes has prompts and I was wondering how can I schedule them?

Is there any way I can map these prompt's values before scheduler triggers them?

Thanks

5 REPLIES 5
jakarman
Barite | Level 11

When scheduled it is going to run in batch.  Unless you can find some zombie  that can type on the keyboard and see the screen that is connected to that batch process (other batch world) there is no way for interaction. With Sp's (metadata) and LSF is solved in an other way. 

---->-- ja karman --<-----
Haikuo
Onyx | Level 15

What do you mean by "map these prompt's values before scheduler triggers them"?  Prompts are macro variables that assigned to Macros in the form of Macro parameter. In this context, like all other macro parameters, they CAN be assigned  with DEFAULT values. Here is how: Go to the Prompt Manager, open up the prompt you want to modify:

1.

p1.PNG

2.

p2.PNG

Doing so will allow you to run the EGP without popping up the prompts, where the prompts will be using default values.

Good luck,

Haikuo

Dreamer
Obsidian | Level 7

Thanks , I understand that we can set default value for prompts. But this way  we have to modify prompt and SP for every run and so it can't be scheduled in production.

My question is that how can we provide prompt values for every scheduled run?

Currently i have designed my solution this way:

  1. Update prompt values in an excel sheet before scheduled date
  2. SAS process imports that excel in to sas data set
  3. It creates macro variables which can be then used as prompt values

But here I have a set of business users who doesn't know much of sas coding and mainly they create process via point & click options.

Is there any way they can also schedule their processes by automating the prompt values?

Haikuo
Onyx | Level 15

If step 1,2, 3 is already in place, I can't see why your users can't feed the parameters by updating their own spreadsheets (step 1), and then your scheduled SAS process will take over from step 2 and move on?

It may or may not suit you, I would convert every 'production process' into STP, where I have much more control, not just in term of coding, but also STP supports better prompts (eg. cascade prompts).

Good luck,

Haikuo

Kurt_Bremser
Super User

Extract the code from the projects into .sas program files.

Set up an include that accepts values from the scheduler (usually via environment variables) and puts them into predefined macro variables (like param1, param2, ...., paramx)

Write your codes so that they use the predefined parms as control input (replacing the prompt values).

This means that user code must be evaluated by the SAS admin group, but this should be done anyway before allowing batch processing by the central scheduling.

We used tidal once as an intermediate tool between Control-M and the SAS server (UNIX). We have since set up a direct control of the UNIX server by Control-M, using nothing but UNIX standard tools (sftp/ssh, shell scripts).

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1838 views
  • 0 likes
  • 4 in conversation