I have attached the file for the data ( Sheet - DATA)
So, Form base data, I wanted to extract the Customers.
Please supply your example data in a data step with cards;
I won't open a MS Office file from the web because of security considerations. I guess the same goes for most contributors here.
RESULT REQUIRED | |||||||||||||
CATEGORY OF CUSTOMER | BASE DATA | ||||||||||||
EMP | A | B | C | D | CATEGORY | COUNT OF TOTAL CUSTOMERS | |||||||
1 | 27 | 30 | 18 | 29 | A | 8000 | |||||||
2 | 21 | 18 | 17 | 21 | B | 12000 | |||||||
3 | 10 | 18 | 10 | 28 | C | 9000 | |||||||
4 | 13 | 24 | 24 | 17 | D | 11000 | |||||||
5 | 23 | 12 | 18 | 29 | |||||||||
6 | 13 | 29 | 13 | 26 | |||||||||
7 | 27 | 11 | 23 | 18 | |||||||||
8 | 16 | 16 | 27 | 16 | |||||||||
9 | 25 | 13 | 20 | 27 | |||||||||
10 | 13 | 26 | 25 | 28 | |||||||||
11 | 24 | 12 | 14 | 29 | |||||||||
12 | 12 | 20 | 25 | 22 | |||||||||
13 | 14 | 12 | 24 | 26 | |||||||||
14 | 28 | 22 | 20 | 27 | |||||||||
15 | 30 | 27 | 30 | 13 | |||||||||
16 | 12 | 25 | 18 | 21 | |||||||||
17 | 13 | 13 | 15 | 17 | |||||||||
18 | 17 | 18 | 14 | 28 | |||||||||
19 | 11 | 25 | 12 | 20 | |||||||||
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.