topic Re: Implementation of Date Range Prompt in Query Builder in SAS Enterprise Guide

Implementation of Date Range Prompt in Query Builder

JDMTX — Tue, 22 Mar 2011 20:20:09 GMT

Can someone adivse how to implement a date range prompt via a filter in the query builder interface in EG 4.3? I understand how to use prompts in open code but it is not clear how the date range prompt macro variables of _MIN and _MAX should be setup via the filter setup screen. Any help would be greatly appreciated.

jdm

Re: Implementation of Date Range Prompt in Query Builder

tomrvincent — Thu, 31 Aug 2017 13:27:42 GMT

I'm trying to do this as well. QB adds a where clause like this:

WHERE %_eg_WhereParam( t1.CLCL_PAID_DT, Paid_Dates, EQ, TYPE=D, IS_EXPLICIT=0 );

but I haven't gotten it to work and it doesn't show Paid_Date_Min or _Max as available prompts.

I might have to get rid of the date range macro variable or add a redundant begin_paid_dt and end_paid_dt.

Re: Implementation of Date Range Prompt in Query Builder

tomrvincent — Thu, 31 Aug 2017 13:38:34 GMT

I solved it!

use a 'between range' and you can use a date range macro variable.

it'll generate this filter: WHERE %_eg_WhereParam( t1.CLCL_PAID_DT, Paid_Dates, BETWEEN, TYPE=D, IS_EXPLICIT=0 );

here's a video to explain it. https://www.youtube.com/watch?v=zgk3lJzcIPo