SAS Stored process use input

[Filipvdr]

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

[FredrikE]

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

[Filipvdr]

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

[Kurt_Bremser]

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

[Filipvdr]

Ok thanks, it confirms my thoughts.

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

[Kurt_Bremser]

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