About anuragraishines

anuragraishines · ‎04-18-2024

Hi HunterT_SAS, You are right am using precision container because there are certain requirements which is only possible in precision container e.g. there are scenarios where I have to minimize list table to show only single cell etc. which is not possible in other container. I am wondering why SAS provided precision container if it won't work on different resolution. In todays time we cannot force user to use report on laptop of certain resolution only or on desktop of certain resolution. Here we are not even talking about ipad or mobile devices. This option is there in Tableau , Power BI, MSTR etc. and it works like charm. Is there any workaround which at least minimize the issue if not resolve it. Any solution will be of great help. Regards, Anurag Rai

whymath · ‎06-20-2023

What a beautiful way!

acordes · ‎03-16-2023

No, to me your requirement is not clear. I'm wondering if you really want to do this in Visual Analytics or you strive to get it done with proc tabulate or proc report... If you go for VA, then take a look at this example.

Kurt_Bremser · ‎03-02-2023

You could only get this when any change on the database triggers a new CAS load in SAS. A "live" direct connection to a DB can only be done in SAS 9.4 or Viya with a SAS/ACCESS LIBNAME.

Kemal_Sozer · ‎02-24-2023

Dear Anurag, Why you do not use right panel "action"(filter selection) instead of two way? This selection restricts other objects.

anuragraishines · ‎01-20-2023

Thanks acordes for the input it was exactly what I was looking to implemet. Have to add few more logic on top of it and it will be done. The reason I am trying to avoid in SAS Studio is that it is the only derived column and rest is a flat table hence wanted to avoid that extra layer and other orchasteration

anuragraishines · ‎12-05-2022

Hi, Thanks for the update. The VS code option is currenlty not integrated in the exisitng version. Is there any other solution for downloading the data. Regards, Anurag

anuragraishines · ‎12-05-2022

Hi, But in your solution aggregation is coming for only one channel rest are missing. Can you please elaborate on the solution. Regards, Anurag

Stu_SAS · ‎07-15-2022

Hey Anurag! Check out Renato Luppi's article: Using parameters with Data-Driven Content in SAS Visual Analytics. There is also an SGF 2021 paper where @acordes discusses passing data from Visual Analytics into DDC in order to run back-end SAS code. Check out the second half of the video and paper here: Modernizing Scenario Analysis with SAS Viya and Visual Analytics. Hope this helps!

Sam_SAS · ‎06-07-2022

In that scenario you would create three calculated items based on the parameter. IF ( 'Parameter 1'p = 'R1' ) RETURN 'Measure1'n ELSE 'Measure3'n IF ( 'Parameter 1'p = 'R1' ) RETURN 'Measure2'n ELSE 'Measure4'n IF ( 'Parameter 1'p = 'R2' ) RETURN 'Measure5'n ELSE . We don't have a way to hide the third measure when R2 is selected, but its values would be blank (missing).

Kurt_Bremser · ‎10-31-2019

@anuragraishines wrote: hi, Thanks for the prompt reply!!! No it is not stored by using compressed option. Regards, Anurag Rai Then you must test it with the compress option. This may reduce physical dataset file size significantly and therefore your I/O load. Also run your steps with options fullstimer to get more in-depth diagnostic information. A large difference between CPU time and real time always points to the I/O subsystem.

SASKiwi · ‎06-25-2019

You can derive a month counter this way, assuming that the latest reporting date is the last month and is the last day of each month (eg 31 May 2019). Note this logic requires a SAS DATA step and should be part of your data preparation before loading into LASR. * Derive reporting month counter, latest month = 0, previous month = 1 and so on.; Reporting_Month = intck('MONTH', Reporting_Date, "&today"d);

SASKiwi · ‎06-23-2019

You can use SAS Studio in SAS VA to run SAS code to prepare SAS data for loading into your LASR library. Trying to do everything in formulas / calculated measures is severely limiting as well as often being inefficient.

anuragraishines · ‎06-03-2019

Hi Sam, Thanks for the reply I will get in touch with SAS Technical team. Regards, Anurag

PetriRoine · ‎05-31-2019

Yes, it has an impact to performance. This solution requires two calculated items: service_date_text and parameter_as_date. Each of these need processing. Calculated items are not permanently added into data source tables - they are calculated on the fly when you open the report. This means every calculated item takes some processing time. So, if you can populate the Drop-Down list from a separate table having only single variable with distinct values, then you are going to save processing time. Firstly you save time by not having to process distinct date values from 40M rows of data: Secondly you save time by not having to create calculated item service_date_text when opening the report. To see the performance effect I would simply use timer on my phone. Three timings opening the original report. Then three timings opening the report with this dynamic date filter. I hope this helps! Best regards, Petri

Online Status	Offline
Date Last Visited	‎04-18-2024 05:32 PM

Re: How to resolve screen resolution and prin issues in SAS VA Report

Re: How to resolve screen resolution and prin issues in SAS VA Report

How to resolve screen resolution and prin issues in SAS VA Report

Identify constant columns in a dataset

How to add headings in List Table and Cross Tab

Re: How to consume Live data in SAS VA

How to consume Live data in SAS VA

SAS Visual Analytics 2- way filters customization options

Re: How to do pattern check in SAS Visual Anaslytics

How to do pattern check in SAS Visual Anaslytics

Re: How to create dynamic date filter in SAS VA 7.3

Re: How to create dynamic date filter in SAS VA 7.3

Re: How to create dynamic date filter in SAS VA 7.3

Re: How to remove aggregation of subtotals in SAS Visual Analytics

Passing dynamic value from DDC object to SAS Job code

Re: Change language from english to other language in SAS VA

Re: How to create dynamic date filter in SAS VA 7.3

Re: How to resolve screen resolution and prin issues in SAS VA Report

Re: Identify constant columns in a dataset

Re: How to add headings in List Table and Cross Tab

Re: How to consume Live data in SAS VA

Re: SAS Visual Analytics 2- way filters customization options

Re: How to do pattern check in SAS Visual Anaslytics

Re: Add a button in SAS VA report to downlaod the data in excel or csv

Re: How to remove aggregation of subtotals in SAS Visual Analytics

Re: Passing dynamic value from DDC object to SAS Job code

Re: Creating dynamic measures in stacked bar chart

Re: SAS Processing Time for Big Data Sets

Re: Calculated Metric for last two months

Re: How to create lag and lead values

Re: Prompt Container Issue

Re: How to create dynamic date filter in SAS VA 7.3