If you have spent anytime building SAS prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data l…
Tag: prompts
SAS BI Prompts: Gettin’ User Friendly
When creating prompts in SAS Business Intelligence or SAS Enterprise Guide, the value the database or your code uses to populate the field may not be user-friendly. Certainly you want your user community to think you are that cool BI developer tucked…
Prompts: How do I use a Date Range Prompt?
After some not-so careful consideration, I decided to take the SAS BI Content Developer exam. Some folks I know who have passed the exam recommended that I study how to work with prompts and stored processes. So I am making up examples and working through some exercise drills of my own creation (oooh … scary). I am noticing some of the features and nuisances of working with the Date Range prompts. When I started using stored processes several years ago, it was not quiet this easy to setup date prompts, so the prompts are a welcome improvement. In this example, a Proc Tabulate summarizes the sales by location and date. The Date Range prompt allows the user to select a custom date range between Jan 1995 and December 1998. This figure shows how the prompt looks and the results. Check if the User is Insane … I like this prompt because it does have some built in “sanity” checks. For instance, I tried to make the end date before the start date and it didn’t like it. You can see it generated an error message. This capture is a little dramatic with a date of June 1900. If using Jan 1996 […]