https://communities.sas.com/t5/SAS-Enterprise-Guide/Sample-usage-prompt-range/m-p/62483#M6324 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.)<BR /> <BR /> cynthia Fri, 14 Jan 2011 18:10:17 GMT Cynthia_sas 2011-01-14T18:10:17Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Sample-usage-prompt-range/m-p/62482#M6323 Hi, <BR /> <BR /> Does anyone has a good example of creating and using a prompt with a numeric or character range<BR /> <BR /> Regards, <BR /> <BR /> Henri Fri, 14 Jan 2011 09:19:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Sample-usage-prompt-range/m-p/62482#M6323 HenriTheuwissen 2011-01-14T09:19:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Sample-usage-prompt-range/m-p/62483#M6324 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.)<BR /> <BR /> cynthia Fri, 14 Jan 2011 18:10:17 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Sample-usage-prompt-range/m-p/62483#M6324 Cynthia_sas 2011-01-14T18:10:17Z