topic counting number of registers that are greater than 1, 2, 3.... in SAS Programming

counting number of registers that are greater than 1, 2, 3....

ariogon — Mon, 23 Jul 2018 09:06:51 GMT

Hi,

I have a table with just one column with hundreds of numbers:

...

and I want a table with the information of number of registers greater than 1, greater than 2, greater than 3 ann so on, until 48, without having to repeat 48 times select count(*) from table where column>n, where n is 1, 2, 3....

Thanks in advance

Re: counting number of registers that are greater than 1, 2, 3....

RW9 — Mon, 23 Jul 2018 09:36:59 GMT

Post test data in the form of a datastep, and show what the output should look like. At a guess:

data have;
  input num;
datalines;
1
2
7
2
8
6
7
;
run;

data want;
  set have;
  array res{48} 8;
  retain res:;
  do i=1 to 48;
    if num >= i then res{i}=sum(res{i},1);
  end;
run;

Re: counting number of registers that are greater than 1, 2, 3....

PeterClemmensen — Mon, 23 Jul 2018 10:50:05 GMT

data have;
  input num;
datalines;
1
2
7
2
8
6
7
;
run;

proc sort data=have out=temp;
   by num;
run;

data want;
   set temp;
   by num;
   sum+1;
   if last.num & num le 48;
   retain sum;
run;

Re: counting number of registers that are greater than 1, 2, 3....

ariogon — Mon, 23 Jul 2018 13:15:15 GMT

The output for the data of the example should be a table of 2 columns:

1 6

2 4

3 4

4 4

5 4

6 3

7 1

8 0

9 0

....

48 0

Re: counting number of registers that are greater than 1, 2, 3....

ballardw — Mon, 23 Jul 2018 17:25:41 GMT

And another approach:

proc sql;
   create table want as
   select num , count(num) as Numcount
   from have
   group by num;
quit;