topic sum of column in SAS Procedures

sum of column

sasphd — Tue, 26 Aug 2014 13:15:51 GMT

I want to sum the observations of a column.

Total 12

stat_sas — Tue, 26 Aug 2014 13:27:43 GMT

proc print data=have;

sum a;

run;

sasphd — Tue, 26 Aug 2014 13:31:08 GMT

where is the output?

stat_sas — Tue, 26 Aug 2014 13:33:57 GMT

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

sasphd — Tue, 26 Aug 2014 13:40:23 GMT

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

For example,

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

Kurt_Bremser — Tue, 26 Aug 2014 13:44:04 GMT

simplest solution, IMO:

proc sql;

/* create table want as */

select sum(a) from have;

quit;

stat_sas — Tue, 26 Aug 2014 13:51:24 GMT

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

proc print data=want;
run;