Hi:
Well, that (drop down boxes that allow the users to select choices that become selection parameters) sounds almost exactly like a stored process program that has had parameters defined for how data should be selected by the user.
If you built a SAS program -- and turned it into a stored process, the automatic prompting interface would present the user with a dialog box that had a selection choice (usually a drop down box, but you can choose other types of selection prompts --like a calendar for dates). This parameter prompting interface is automatically built into the SAS Platform for Business Analytics, when you use stored processes.
Look at the screen shot on page 1 of this paper, at the prompts for STATE and COUNTRY:
http://support.sas.com/resources/papers/proceedings09/330-2009.pdf
or on page 4 of this paper, at the prompt for REGION:
http://www.nesug.org/proceedings/nesug07/ap/ap22.pdf (figure 5 shows how the REGION parameter was defined in the metadata).
The prompting "GUI" was built automatically in these examples -- from the defined metadata that will "run" the stored process based on the user's selections. And, although you could build your own prompting interface (as shown in the first paper above), many people find that the prompting interface that is automatically generated is sufficient for end users who do not know the technical details of the data or the tables they need to access. With a SAS Stored Process, the results can be returned directly to Word or Excel using the SAS Add-in for Microsoft Office. So, it sounds to me like stored processes would be what you're looking for.
cynthia