BookmarkSubscribeRSS Feed
mfaqueiroz
Fluorite | Level 6

Hello,

 

My dataset has the number of clients affected , the corresponding  area, the total of clients per area and the existing equipments.

All the inputs are repeated the number of times that each equipment appears..I know, it does not seem wise but it is constructed in this way.

 

AreaNumber Clients affectedTotal clients areaEquipment
A18200w
A18200e
A18200r
A18200t
A18200y
A18200u
A1200i
B2040SF
B2040A

 

I need to calculate in SAS VA the % of clients affected per area, i.e for area A shall be: (18+1)/200.

 

Is any way count only the distintics grouping by area?

Thanks in advance for your help,

 

Mariana

🙂

1 REPLY 1
Frank_BB
Calcite | Level 5

Hi Maraina

 

You probably don't know which of the 200 clients from area A that is included pr. equipment.

 

I think you will have to add the uniqe Client-ID to the dataset and then make SAS VA Count the 'distinct' number of Cliet-ID's, by defining an aggregated value. 

 

Frank

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 1407 views
  • 0 likes
  • 2 in conversation