SAS VA: Counting the number of observations in a BY-Group

mfaqueiroz — Mon, 23 Oct 2017 17:28:20 GMT

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.

Area	Number Clients affected	Total clients area	Equipment
A	18	200	w
A	18	200	e
A	18	200	r
A	18	200	t
A	18	200	y
A	18	200	u
A	1	200	i
B	20	40	SF
B	20	40	A

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

🙂

Re: SAS VA: Counting the number of observations in a BY-Group

Frank_BB — Tue, 24 Oct 2017 12:32:49 GMT

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

topic SAS VA: Counting the number of observations in a BY-Group in SAS Visual Analytics

SAS VA: Counting the number of observations in a BY-Group

Re: SAS VA: Counting the number of observations in a BY-Group