SAS Stored processes (SAS V9) can be used to generate dynamic reports from web browser, SAS Add in of MS Office, SAS VA (etc.) It's not always easy to understand the capabilities of the different options proposed in the parameters wizard creation nor to identify how you can retrieve the values of the parameters within your SAS code. This tips and tricks helps you to put some light on that.

In this tips and tricks, we will first talk about the SAS Stored processes:

• What is a SAS STP ?
• How and where can we use them?
• How can we create them using the SAS Management Console or SAS Enterprise Guide?
• What is the meaning of the different options of the wizard?
• What is a SAS parameter?
• How can we create parameters?

• The different types of parameters of the SAS prompting framework
• Generate default values and dynamic or static list of values
• Create group of prompts
• Create cascading prompts
• Reuse the parameter values in SAS code

You have some SAS experience and have already created SAS reports.