topic count in proc report in SAS Programming

count in proc report

BrahmanandaRao — Fri, 18 Feb 2022 06:04:08 GMT

Hi guys

how to count cars makers list in sashelp.cars using proc report

Re: count in proc report

andreas_lds — Fri, 18 Feb 2022 06:12:26 GMT

What have you tried? Why proc report?

Re: count in proc report

BrahmanandaRao — Fri, 18 Feb 2022 06:18:06 GMT

count no of car makers list

Re: count in proc report

andreas_lds — Fri, 18 Feb 2022 06:24:21 GMT

So you aren't limited to use proc report?

Re: count in proc report

Kurt_Bremser — Fri, 18 Feb 2022 06:36:59 GMT

Show us what you tried, so we can point out where you went wrong.

I mean, you did try something, or do you expect that for all your life, others will do your work?

Re: count in proc report

BrahmanandaRao — Fri, 18 Feb 2022 06:45:33 GMT

data ds;
set sashelp.cars;

run;

proc sort data=ds;
by make;
run;


data ds2 (keep=make);
set ds;
by make;
if last.make then output;
run;

Hi Kurt_Bremser

I tried but i am looking output in proc report

Re: count in proc report

Kurt_Bremser — Fri, 18 Feb 2022 06:51:33 GMT

Then read the documentation of PROC REPORT and start hacking away. You will learn a LOT doing that.

Hint: PROC REPORT provides a statistic (n) that has the count.

Also do a Google search for "sas counting in proc report".

Re: count in proc report

PaigeMiller — Fri, 18 Feb 2022 12:44:07 GMT

@BrahmanandaRao wrote:
data ds;
set sashelp.cars;

run;

proc sort data=ds;
by make;
run;


data ds2 (keep=make);
set ds;
by make;
if last.make then output;
run;
Hi Kurt_Bremser

I tried but i am looking output in proc report

Maxim 14 — Use the Right Tool

For tasks that are essentially counting, use PROC FREQ, no need to create new data sets and sort the new data sets. All you need is four lines of code (and the first line is really optional, you could leave it out):

ods select nlevels;
proc freq data=sashelp.cars nlevels;
    tables make;
run;

If you really really really need it from PROC REPORT, show us what the report should look like.

Re: count in proc report

Cynthia_sas — Fri, 18 Feb 2022 22:19:08 GMT

Hi:

There are several procedures, including PROC FREQ, PROC TABULATE as well as PROC REPORT and PROC SQL that could generate counts for you. 3 of these procedures are shown below -- going from least lines of code to most lines of code:

Cynthia