topic Re: SAS - Visual Data Builder - where dynamic date condition in SAS Visual Analytics

SAS - Visual Data Builder - where dynamic date condition

dhavalyparikh — Fri, 04 Nov 2022 16:39:42 GMT

In visual data builder expression date function while creating data query condition - where tab :

I want place conditions like

Where start_date between intnx(week,start_date, 0,'B') and intnx(week,start_date, 0,'E')

having said - I want to see a list of only those records where startdate is within the current week's first date of week and last date of week.

Re: SAS - Visual Data Builder - where dynamic date condition

KeithM — Tue, 08 Nov 2022 20:46:01 GMT

The following is an example of the expression that you will need to use. Note, in the example expression "date" is a data item. You will have to have a value for your start_date. I simply hard coded in may 30.

intnx('week','30MAY1980'd,0,'B') <= 'date'n <= intnx('week','30MAY1980'd,0,'E')

Re: SAS - Visual Data Builder - where dynamic date condition

dhavalyparikh — Wed, 09 Nov 2022 02:43:43 GMT

That's great - I will try to implement it tomorrow and get back to you. Thank you very much.

Re: SAS - Visual Data Builder - where dynamic date condition

dhavalyparikh — Mon, 14 Nov 2022 16:34:35 GMT

Instead of you hardcoded date as intnx('week','30MAY1980'd,0,'B') <= 'date'n <= intnx('week','30MAY1980'd,0,'E')
Is there way I can use the current date ? with my case statement

Start_Date is : (TableDate Value Field)
In below statement

select
ind_latest =
case when Freq="Weekly" and intnx ('Week',Today(),0'b') <= Start_Date<=intnx ('Week',Today(),0'E')
then 1
else 0
run;