BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Cuneyt
Obsidian | Level 7

Hi All,

 

I have a data set sorted by two variables (chain and store) and I would like to count them as shown below. Any help will be greatly appreciated.

Chain Store Count
A x 1
A x 1
A y 2
A z 3
A z 3
A z 3
B w 1
B w 1
B w 1
B q 2
B q 2
1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

Assuming the sorted order is correct:

data want;
   set have;
   by chain store;
   if first.chain then count=1;
   else if first.store then count + 1;
run;

View solution in original post

2 REPLIES 2
Astounding
PROC Star

Assuming the sorted order is correct:

data want;
   set have;
   by chain store;
   if first.chain then count=1;
   else if first.store then count + 1;
run;
Cuneyt
Obsidian | Level 7
This works. Thank you!

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 861 views
  • 0 likes
  • 2 in conversation