count distinct with condition - Visual Analytics

Betty_sam — Fri, 11 Mar 2022 16:12:17 GMT

Hi all,

I need to calculte this : distinct(value) where nb>1 as a calculated element but it seems impossible in SAS VA

Please help me out with this issue.

Regards,

Re: count distinct with condition - Visual Analytics

Stu_SAS — Fri, 11 Mar 2022 20:07:42 GMT

Hi @Betty_sam! Here's a quick way to do it using sashelp.cars as an example. We're going to do create a distinct count of all Makes > 200 horsepower.

1. Create a new calculated item of your category

The below code will act as a filter:

if('Horsepower'n > 200) return 'Make'n 
    else ''

2. Create a new distinct count on your new calculated item

Right-click your new data item, select "New Calculation," and "Distinct Count." This should already be selected for you.

3. Add your calculation to an object and filter out missing values

The distinct function also includes missing values. We want to remove those, so we'll filter that out in our object by removing any missing values of our new Make calculation.

Now we have our distinct counts!

Hope this helps!

Re: count distinct with condition - Visual Analytics

Betty_sam — Tue, 15 Mar 2022 13:46:05 GMT

Hi @Stu_SAS,
Thank you very much for your response.

topic Re: count distinct with condition - Visual Analytics in SAS Visual Analytics

count distinct with condition - Visual Analytics

Re: count distinct with condition - Visual Analytics

Re: count distinct with condition - Visual Analytics