- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-30-2023 05:21 AM
(698 views)
Good day,
Can someone please help me.
I have a list of ID numbers (915) out of this list i need to see 2 things :
1. if this ID applied at the same dealer and how many time
2. if this id applied at different dealers and how many time.
please can you assist me on the logic
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I think you can answer both questions by looking in this result. But you need to be more precise on your requirement:
proc sql;
select id, dealer, count(*) as no
from have group by id, dealer;
quit;
Data never sleeps
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
thank you, so this answers my question to see where the same ID went to the same dealer. but I also want to see the same Id that went to different dealers.
- Tags:
- you - so this
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
It's already there. If an id has more than one result line, they went to different dealers.
If you have more specific needs, post how the report(s) should look.