Want **Total** Only

[NKormanik]

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

[yabwon · Accepted solution]

How about:

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

?

Bart

[NKormanik]

Thanks @yabwon ,  @Astounding , @Reeza .

All three approaches worked!

[Astounding]

Since you are somewhat familiar with PROC FREQ:

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

[Reeza]

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