topic Re: Want Total Only in SAS Programming

Want Total Only

NKormanik — Tue, 01 Jun 2021 07:41:58 GMT

ods
html5
style=daisy
path="c:\0_SAS_1"
file="Long, Importance.htm";

proc sort data=sas_1.importance_long;
by Indicator;
run;

proc freq data=sas_1.importance_long;
tables Importance;
by Indicator;
run;

Please see above code.

In the tables which result from this Proc Freq, in the final row of each table, in the Cumulative Frequency column, one can find the TOTAL value for the specific BY Variable.

Presently I am interested in ONLY those TOTAL amounts.

Is there a more direct way?

Want just the TOTAL.

In the above pic, all I want is the Specific Indicator and the 161.

Any help greatly appreciated.

Nicholas Kormanik

Re: Want Total Only

yabwon — Tue, 01 Jun 2021 08:07:09 GMT

How about:

proc sql;
  select Indicator, count(1) as total
  from sas_1.importance_long
  group by Indicator
  ;
quit;

Bart

Re: Want Total Only

Astounding — Tue, 01 Jun 2021 08:37:15 GMT

Since you are somewhat familiar with PROC FREQ:

proc freq data = sas_1.importance_long;
tables indicator;
run;

Re: Want Total Only

Reeza — Tue, 01 Jun 2021 14:25:11 GMT

If the variable is numeric why not use PROC MEANS and the N (Number of non missing observations) as your statistic?

Re: Want Total Only

NKormanik — Thu, 03 Jun 2021 22:17:38 GMT

Thanks @yabwon , @Astounding , @Reeza .

All three approaches worked!

topic Re: Want **Total** Only in SAS Programming

Want **Total** Only

Re: Want **Total** Only

Re: Want **Total** Only

Re: Want **Total** Only

Re: Want **Total** Only

topic Re: Want Total Only in SAS Programming

Want Total Only

Re: Want Total Only

Re: Want Total Only

Re: Want Total Only

Re: Want Total Only