sum of column

[sasphd]

I want to sum the observations of a column.

A

1

2

6

3

=

Total 12

[stat_sas]

proc print data=have;

sum a;

run;

[sasphd]

where is the output?

[stat_sas]

May be I missed something in understanding your problem. What are you trying to do?

[sasphd]

I want to calculate the proportions of positive alphas. So the number in my column are (0,1)

For example,

A

1

0

1

0

so, the proportion of positive alphas is equal to sum of A /number of observations(which is 4 here)=2/4

[stat_sas · Accepted solution]

proc sql;
create table want as
select sum(a=1)/count(a) as positive_alpha from have;
quit;

proc print data=want;
run;

[Kurt_Bremser]

simplest solution, IMO:

proc sql;

/* create table want as */

select sum(a) from have;

quit;