After unwittingly getting involved recently in a code vs GUI discussion another pro GUI vote came in yesterday when presenting to a customer's internal user group. When creating and using prompts in SAS Enterprise Guide, it is a no-brainer to recommend leveraging the %_eg_WhereParam as it handles all the special coding requirements to process prompts. Here are three very quick movies to show how it is done.
Single Selection Prompt in SAS Enterprise Guide
Use SAS Enterprise Guide to generate a single selection prompt off of a static list of values.
Multiple Selection Prompt in SAS Enterprise Guide
Use SAS Enterprise Guide to generate a multiple selection prompt off of a static list of values.
Date Range Prompt in SAS Enterprise Guide
Generate a date range prompt for only 2011 data and apply to the data table.
Need more ideas/information?
For more information on using SAS Enterprise Guide Prompt Manager, refer to my SAS Global Forum 2011 paper "Creating Reusable Programs Using SAS Enterprise Guide Prompt Manager".