Hi, When you define your stored process you can create prompts. These prompts can be different types (free text, check boxes, single/multiple choice drop down lists etc). These prompts get automatically created as macro variables in the STP code, and the values entered by the user passed in as the value. These prompts are displayed inside the node in CI studio for the user to enter values. So lets say you have a known list of defined values for products (Cosmetics, Hardware, Electrical etc) you could create an STP with a prompt called Product_Type, set this prompt to be a static list and enter those 3 values for the user to choose from). Then in your SAS code you change it to: Select business_key from sales_table where product = &Product_Type; There is a lot of flexibility in the types of prompts you can use, including using lookup table to get the defined values - check out the MA user guide (version 6.5 Pg 142) for further info, as well as the SAS Platform documentation for creating STPs. Regards James
... View more
