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 | |||||||||
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.