topic Re: SAS Stored process use input in SAS Enterprise Guide

SAS Stored process use input

Filipvdr — Thu, 06 Sep 2018 07:37:30 GMT

Hello,

We have a stored process which will upload a table to LASR VA.

To make it more easier for end-users in SAS Eguide we want to use the input, so the user does not have to fill in a lot of prompts.

For example if the table is called work.FINDINGS_2018 we want FINDINGS_2018 to be filled in in a field/prompt already, the user can overwrite it in the prompt but it's filled in already by default. Maybe we can work with &syslast or any other ideas? Can this be done in Eguide with a stored process?

I also sas the task templates but this seems more difficult.

Filip

Re: SAS Stored process use input

FredrikE — Thu, 06 Sep 2018 08:04:57 GMT

Can you do the other way, i.e if the prompt is blank you use the default (in your code) and if it has a value you use this instead?

//Fredrik

Re: SAS Stored process use input

Filipvdr — Thu, 06 Sep 2018 08:16:04 GMT

This could be a solution, but more difficult for users to understand. Most user-friendly way would be that it would be filled in.

Re: SAS Stored process use input

Kurt_Bremser — Thu, 06 Sep 2018 09:29:34 GMT

Just tried it. You can't use a macro variable to pre-populate a prompt, so this won't be possible.

Re: SAS Stored process use input

Filipvdr — Thu, 06 Sep 2018 09:35:42 GMT

Ok thanks, it confirms my thoughts.

Any workarounds or ideas? Or the only way is to create a custom task template?

Re: SAS Stored process use input

Kurt_Bremser — Thu, 06 Sep 2018 09:44:00 GMT

Since you can create a prompt that lets you select values form a list, and that list can be dynamic (read from a dataset), you can try the following:

create a dataset with a properly defined column for dataset names (8+1+32=41 characters)
register the dataset in metadata
create prompt that reads values from the dataset, but also allows the user to enter values not in the list
write one or more dataset names to the dataset at runtime before the STP is called