topic Re: Count of data in SAS Programming

Count of data

pdhokriya — Fri, 27 Nov 2020 16:16:36 GMT

Hi Reader,

Here is some new understanding i am exploring, so could you please share the solution?

/*Input data*/

data abc ;
input dsc $ ;
cards;
a
a
c
b
b
b
b
;
run;

/*Output requirement*/

b	c	a	total count
(n=4)	(n=1)	(n=2)	(n=7)

Re: Count of data

novinosrin — Fri, 27 Nov 2020 16:35:13 GMT


data abc ;
input dsc $ ;
cards;
a
a
c
b
b
b
b
;
run;

proc sql;
 create table temp as
 select dsc, count(dsc) as count, (select count( dsc )  from abc) as total_count
 from abc
 group by dsc;
quit;
proc transpose data=temp out=want(drop=_:);
 by total_count;
 var count;
 id dsc;
run;

Re: Count of data

ballardw — Fri, 27 Nov 2020 16:40:16 GMT

One basic approach:

proc tabulate data=abc;
  class dsc;
  table n,
        dsc all='Total'
  ;
run;

If the output actually requires the ugly-to-me (n= ) that's another story.

Re: Count of data

pdhokriya — Fri, 27 Nov 2020 17:09:16 GMT

I will prefer this kind of output-
proc sql;
create table temp as
select dsc, cat ("(n","=",count(dsc),")") as count, (select cat ("(n","=",count( dsc ),")") from abc) as total_count
from abc
group by dsc;
quit;

Re: Count of data

Reeza — Fri, 27 Nov 2020 17:23:47 GMT

Use PROC FREQ - which is the most basic solution.

PROC FREQ data=abc;
table dsc;
run;