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 | |||||||||
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.