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
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
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.
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=n1ehcc5pjl4yrtn1... 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
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?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.