About PetriRoine

PetriRoine · ‎03-30-2020

Hello @PaigeMiller, This is Visual Analytics related question, so no SAS code and output here 😃 Best regards, Petri

PetriRoine · ‎03-30-2020

Hello @MVras , Yes, it became possible in the release VA 8.5. You just click R-M-B on top of the Key value object and select Add link. Since you haven't been able to do this I guess you are running earlier version like 8.3 or 8.4 and would need an upgrade to take benefit of this. Best regards, Petri

PetriRoine · ‎03-19-2020

Hello @MClay , My understanding is that it's not possible to get totals in details table. Regarding the second question you could utilize Custom Category to achieve what you want. Just create three new categories [Yes, No, Unk] and assign [yes, no, unknown] accordingly.

PetriRoine · ‎03-10-2020

Hello @DarjaJafanova, Please check the Result Type is Numeric. Best regards, Petri

PetriRoine · ‎03-02-2020

Hello @ghartge I see options for you: 1. Wrangle data to fit your need Your data has now own variables for Course Count, Status and Number_of_Seats_Filled. You could manipulate data to have these as one variable and another variable to define the data description [Course Count, Status, Number_of_Seats_Filled]. Then you would use this new data description variable in your Cross tab role Rows. 2. Almost the same appearance as wanted?? Not a perfect solution, but hopefully these ideas help even a little. Best regards, Petri

PetriRoine · ‎02-03-2020

Hello @SCS78 Unfortunately setting X (or Y) axis to log base is not yet in VA. Maybe you could give D3.js chart a try? Best regards, Petri

PetriRoine · ‎11-21-2019

Hello @chandanbanerjee They way forward could be by using Parse operator. F.ex. if you have Category for Cruise ship cabins and the data looks something like this Text A = [A123, A154, B129, C3021, C3122,...], you can first use Substring operator to get the number part and then cast it into a number type variable using Parse: Best regards, Petri

PetriRoine · ‎09-25-2019

Nice to hear that you found another way to get where you want 😃 Could I ask you to please share your approach here? Best regards, Petri

PetriRoine · ‎09-21-2019

Hello @bobbyfajardo, I might have a solution for you but it depends on the version you are using. In SAS VA8.3 a new operator was published. AggregateCells aggregates the values of a specific set of cells in the detail data table for an object and allows offset starting point for the aggregation. I have used that operator to basically calculate: ( AggregateCells(_Sum_, 'Bottles_Used'n, column, CellIndex(current, 0), CellIndex(current, 0)) - AggregateCells(_Sum_,'Bottles_Used'n, column, CellIndex(current, -1), CellIndex(current, -1)) ) / AggregateCells(_Sum_, 'Bottles_Used'n, column,CellIndex(current, -1), CellIndex(current, -1)) If you are running < VA8.3 then unfortunately I do not have an answer for you. Best regards, Petri

PetriRoine · ‎08-02-2019

Hello @elkinsbe Here's a little information I was able to find for you. Decision Tree Implementation follows for the most part the standard C4.5 algorithm to build and prune decision tree. The primary difference between our implementation and C4.5 is the determination of the desired number of branches with the optimal variable for each splitting. Cluster The default technique is k-means clustering. If you are using GUI you basically define inputs and number of clusters. The default method for initializing K cluster centeroids is Forgy - you can change that to simple Random. Feature scaling is done default. Are you considering using DTree to provide clusters by giving it a target that has nothing to do with the final clusters? Best regards Petri

PetriRoine · ‎07-28-2019

Hello @pgadde , This limitation is version dependent. VA 7.4 and earlier: You can select up to 25 data items for a custom sort. VA 7.5 and VA 8.x: No limit or high limit (?). I've used +70 and worked well. Best regards, Petri

PetriRoine · ‎07-19-2019

Hello @Derick Have your tried to use Rank? You can use the Ranks to subset the data in your visualizations. A rank selects either the top (greatest) or the bottom (least) aggregated value for a category. Best regards, Petri

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

PetriRoine · ‎05-29-2019

You are absolutely correct. The step #4 wasn't right. I have now fixed that. Apologies for the trouble. Best regards, Petri

PetriRoine · ‎05-28-2019

The end user can type what ever codes they want - the codes (search strings) aren't fixed. The number of codes (search strings) user can type in the Text Input to be searched is fixed. In my example the max number to be searched was five. That's why I had five new calculated items. Actually to be 100% correct the user can type in as many codes (search strings) as they want, but the maximum number of codes (search strings) to be processed is fixed. I propose you try this and see how it works. Br, Petri

Online Status	Offline
Date Last Visited	‎01-14-2021 10:25 AM

Re: Calculating Month and Fiscal Averages

Re: [VA] - tabel, calculations. how to solve

Juletip #2 - How to calculate AVG, MIN, MAX, etc… for aggregated measu...

Re: How to change your DATETIME format in SAS VA?

Re: SAS Sentiment Analysis Studio

Re: Data visualization

Re: Distribution of case and controls in different age groups - Plot &...

Re: Data visualization

Re: Data visualization

Re: Percentages for "Select all" Survey Questions

Juletip #11-Enable access to Git in SAS StudioV for Viya 3.5 using HTT...

Juletip #10 How Santa easily imbeds visualizations in his CRM system –...

Re: Juletip #8 - Drawing a simple pyramid in SAS

Juletip #4 - In Christmas you open only your own presents. But how to ...

Juletip #1 - Even if Christmas is packed - don't fill up your report t...

Re: Creating a 'Difference from previous period' variable on an aggreg...

Re: Calculating frequency percentage by category in Visual Analytics 8...

Juletip #2 - How to calculate AVG, MIN, MAX, etc… for aggregated measu...

Re: Distribution of case and controls in different age groups - Plot &...

Re: Adding more than 155 on a deep nested operator

Re: Link from a key value to another report

Re: Link from a key value to another report

Re: How do you customize a details table in SAS VA 7.5?

Re: Calculated item with count if function

Re: Set a measure to display as a column heading to group (display abo...

Re: How to create a line plot with X-axis set to log base in SAS VA?

Re: How to convert category(character type) to measure in VA?

Re: Percentage difference between 3 specific dates per year

Re: Percentage difference between 3 specific dates per year

Re: SAS/VA .4 Exploration section - "Decision Tree" and "Cluster"

Re: custom sort category limit of 25 values

Re: How to Top N by Sum in Bar Chart

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 use text input for multiple selections in SAS VA 7.3

SAS Community Nordic