Desktop productivity for business analysts and programmers

Sample usage prompt range

Reply
Occasional Contributor
Posts: 14

Sample usage prompt range

Hi,

Does anyone has a good example of creating and using a prompt with a numeric or character range

Regards,

Henri
SAS Super FREQ
Posts: 8,719

Re: Sample usage prompt range

In our classes, we frequently show prompts in stored processes or macro coding for numeric ranges of years (want a report where year is between 2005 and 2008 or 2001 and 2005, etc). Or where sales are gt 5000 and lt 10000, etc. Or a day start and day end or time start and time end. (I know that date, day and time aren't only numeric -- but sometimes must be treated a bit differently in the WHERE clause -- which is a teaching opportunity.)

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation