02-24-2017 11:52 AM
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)
group by customer_type;
Thanks in advance.
02-24-2017 05:40 PM
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.