topic Re: SAS VA - filter to current year and month by default in SAS Visual Analytics

SAS VA - filter to current year and month by default

DharmeshTadvi — Sat, 22 Sep 2018 11:14:33 GMT

how to show current year and month data by default on my VA report , but also give user the possibility to filter other year and month. (Note year and month should change dynamically when new month or year come )

Re: SAS VA - filter to current year and month by default

SASKiwi — Sun, 23 Sep 2018 01:28:07 GMT

The easiest way to do this is to add a flag in your SAS VA table before loading it. For the current month, set this flag to 0, for the previous month 1, and the month before that 2 and so on. Then you can have a static filter in VA set to month flag = 0.

Re: SAS VA - filter to current year and month by default

sridhar_m — Wed, 13 Feb 2019 12:06:56 GMT

Hi,

Thanks a lot for your quick updates. Could you please suggest how to include and where to include to add a flags.

Thanks in Advance,

Sridhar

Re: SAS VA - filter to current year and month by default

SASKiwi — Wed, 13 Feb 2019 19:19:49 GMT

Before loading your data into VA a simple DATA step can add this column. I'm assuming you would have a reporting date column in your data. From that you can derive a reporting month column. Based on the logic below Jan 2019 data will be flagged with a reporting month (Reporting_Month) of 0.

data want;
  set have;
  Reporting_Month = intck('MONTH', Reporting_Date, "31Jan2019"d);
run;

Re: SAS VA - filter to current year and month by default

sridhar_m — Thu, 14 Feb 2019 05:25:27 GMT

Thanks a lot for your quick updates.

Re: SAS VA - filter to current year and month by default

sridhar_m — Sun, 17 Feb 2019 07:20:44 GMT

Hi,

Could you please help me on the below:

How to load latest 6 months data into SAS CAS Server.

and after that how to append 3 more months into it.

Using with PROC CASUTIL.

Thanks in Advance

Re: SAS VA - filter to current year and month by default

SASKiwi — Mon, 18 Feb 2019 19:54:19 GMT

Have you read the CASUTIL documentation?

https://documentation.sas.com/?docsetId=casref&docsetTarget=n03spmi9ixzq5pn11lneipfwyu8b.htm&docsetVersion=3.3&locale=en

It looks like you can do an append with the LOAD statement to add to an existing CAS table. A normal LOAD with a WHERE condition to create the table in the first instance should work.

Re: SAS VA - filter to current year and month by default

sridhar_m — Tue, 19 Feb 2019 04:00:45 GMT

Hi,

Thank you very much for your answer.

I am submitting the below code:

proc casutil;

load casdata=" TRANSACTIONS" casout=" TRANSACTIONS_STG" outcaslib=" FA" incaslib="FA"

options={where=" dw_processed_date='201902'd " }

replace ;

quit;

But, I am not able to apply format. Kindly help.

Thank you

Re: SAS VA - filter to current year and month by default

34reqrwe — Tue, 19 Feb 2019 18:14:18 GMT

Hi,

have you read the documentation?

what does your log say?

Re: SAS VA - filter to current year and month by default

SASKiwi — Tue, 19 Feb 2019 19:10:47 GMT

Please post your SAS log.

Re: SAS VA - filter to current year and month by default

sridhar_m — Wed, 20 Feb 2019 03:34:33 GMT

82 load casdata="FA_TRANSACTIONS" incaslib="FA2" outcaslib="FA2" casout="FA_TRANSACTIONS_STG"
83 dataSourceOptions=(dbmswhere="posted_on_dt=201902")
84 replace;
NOTE: Action failed during Embedded Process processing. Retrying action without the Embedded Process.
ERROR: General error org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException Cannot
convert to Date from: int
ERROR: The action stopped due to errors.

Thank you

Re: SAS VA - filter to current year and month by default

sridhar_m — Wed, 20 Feb 2019 10:04:35 GMT

Hi,

PFB for your reference:

Re: SAS VA - filter to current year and month by default

34reqrwe — Thu, 21 Feb 2019 01:22:49 GMT

Sounds like a syntax error .
"Cannot convert to Date from: int"
you could confirm if it is syntax by removing this line
dataSourceOptions=(dbmswhere="posted_on_dt=201902")