topic Re: How to use today()-1 date filter in SAS Data Studio plan in SAS Viya

How to use today()-1 date filter in SAS Data Studio plan

SatishR — Mon, 16 Dec 2024 06:49:05 GMT

Dear Team,

I am trying to filter out the Yesterday's data from Audit table and I want to store in Historical manner in my permanent lib. However I am not getting any option to filter out data in dynamic way. I have attached screenshot for your reference.

Any option to filter out data based on today()-1 features. Kindly assist me regarding the same.

Thanks in advance.

Re: How to use today()-1 date filter in SAS Data Studio plan

LinusH — Mon, 16 Dec 2024 09:08:21 GMT

I don't have Data Studio at my fingertips, and the docukentation is not really answering this specific need.

But your screen shot is from the Convert Column transform, please attach one with the Filter transform.

Re: How to use today()-1 date filter in SAS Data Studio plan

SatishR — Mon, 16 Dec 2024 09:41:01 GMT

@LinusH kindly find the below screenshot

I think this can be achieve using custom code

Re: How to use today()-1 date filter in SAS Data Studio plan

LinusH — Mon, 16 Dec 2024 10:00:50 GMT

Ok, so the question is what kind of expressions are valid in the Value field.

I guess you can try your today()-1 or "&Sysdate"d-1.

Re: How to use today()-1 date filter in SAS Data Studio plan

SatishR — Mon, 16 Dec 2024 10:30:22 GMT

@LinusH Using below custom code we can achieve the scenario

This resolved the concern.

Thanks for your support.

Re: How to use today()-1 date filter in SAS Data Studio plan

Patrick — Mon, 16 Dec 2024 12:48:06 GMT

@SatishR Instead of custom code you could also use the BETWEEN operator from your dropdown list to generate the following where expression:

datetime between intnx('dtday',datetime(),-1,'b') and intnx('dtday',datetime(),-1,'e')