Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Calculated items with aggregate measures

Reply
Occasional Contributor
Posts: 5

Calculated items with aggregate measures

[ Edited ]

Hi all,

 

Is it possible to create a new item ins SAS Visual Analytics (Report designer) like this:

 

if (distinct(A)>1) return "abc"
else return A

A is a category and abc is a string.

 

 

Thanks,

 

LF

Contributor
Posts: 29

Re: Calculated items with aggregate measures

Create a new aggregated measure ind use the boolean for the if statement and the aggregated to use distinct

Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation