topic Re: Counting two variables in SAS Programming

Counting two variables

Cuneyt — Mon, 08 May 2023 23:34:34 GMT

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.

Astounding — Mon, 08 May 2023 23:57:50 GMT

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 — Tue, 09 May 2023 00:29:02 GMT

This works. Thank you!