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 🙂
... View more