topic Re: count values using a group in SAS Visual Analytics

count values using a group

KrisNori — Fri, 24 Feb 2017 16:52:14 GMT

Hi there,

I am using SAS VA 7.3.

How can I get the value in a variable in SAS VA Report Designer that is equivalent to the count produced by below query ?

Select customer_type, count( distinct customer_id)

from table

group by customer_type;

Thanks in advance.

Kris

Re: count values using a group

MichelleHomes — Fri, 24 Feb 2017 22:40:16 GMT

You can create a derived item on your customer_id category using the Creating Derived Items technique described in the SAS Visual Analytics User Guide: Creating Derived Items

To get a table of each customer_type by the distinct customer_id use both data items in a table object and you'll have the listing you desire. If you prefer a different visual then use customer_type and your derived item in that.

Kind Regards,

Michelle

Re: count values using a group

DaveShea — Thu, 22 Feb 2018 04:41:17 GMT

Hi Michelle,

Thanks for the great tip about Derived Items.

Downunder Dave.

Re: count values using a group

gabras — Mon, 06 Aug 2018 15:19:03 GMT

Hi @MichelleHomes

is there a way to create an aggregated variable, such as the one you suggested in this post, and then use it's distinct value in order to create other report?

For example i want to create a report that counts distinct customers that made that amount of count.

Re: count values using a group

MichelleHomes — Mon, 06 Aug 2018 18:48:22 GMT

It seems that what you are trying to achieve @gabras is now available in the newly released SAS Visual Analytics 8.3 on SAS Viya 3.4. See documentation http://documentation.sas.com/?cdcId=vacdc&cdcVersion=8.3&docsetId=vawn&docsetTarget=n1ehcc5pjl4yrtn1sjq5rellrmog.htm&locale=en and the Enhanced Data Pane section.

If you are using any other release you’ll need to create the aggregated value as a query or outside VA and have the data source available for the new report.

Kind Regards,

Michelle

Re: count values using a group

gabras — Mon, 06 Aug 2018 18:57:44 GMT

It seems to me that SAS VA doesn't support a dinamic report except for SAS Viya.

But if i use a data query in the Data Preparation Panel is it possible to treat the query builder as a stored process?

Let's say i create the query. is it possible to associate a from_data and to_data prompts to trigger the execution of the quey in order to create the report?