topic Re: Count and Sum Function in SAS Procedures

Count and Sum Function

Mgarret — Tue, 04 Dec 2012 22:29:57 GMT

Hi all—

I’m trying to use base SAS to count points possible and points earned. When counting points possible missing values do not count. I have been trying to use the count function. Is that correct? Your help is appreciated.

data want (keep=S1 S2 S3 S4 S5);

set have;

Points_ Possible=count(S1, S2, S3, S4 ,S5); Not

Total_ points=sum(S1, S2, S3, S4 ,S5);

run;

What I need:

Id_Survey	S1	S2	S3	S4	S5	Points_ Possible	Total_ points
4545	1.0	0.0	1.0	1.0	0.0	5.0	3.0
999	0.0	1.0	.	.	1.0	3.0	2.0
784	.	0.5	0.0	1.0	0.0	4.0	1.5
852	0.5	.	1.0	.	.	2.0	1.5

Thanks!!!

Re: Count and Sum Function

Reeza — Tue, 04 Dec 2012 23:27:14 GMT

Use the n() function

data want (keep=S1 S2 S3 S4 S5 Points_possible total_points);

set have;

Points_ Possible=n(S1, S2, S3, S4 ,S5);

Total_ points=sum(S1, S2, S3, S4 ,S5);

run;

Re: Count and Sum Function

art297 — Tue, 04 Dec 2012 23:27:38 GMT

There are a number of ways to do what you want. I prefer something like the following, as it is easy to modify for different surveys:

data have;

input Id_Survey S1 S2 S3 S4 S5;

cards;

4545 1.0 0.0 1.0 1.0 0.0 5.0 3.0

999 0.0 1.0 . . 1.0 3.0 2.0

784 . 0.5 0.0 1.0 0.0 4.0 1.5

852 0.5 . 1.0 . . 2.0 1.5

;

data want;

set have;

array s(*) s:;

Points_Possible=dim(s)-nmiss(of S:);

Total_points=sum(of S:);

run;

Re: Count and Sum Function

Astounding — Tue, 04 Dec 2012 23:41:57 GMT

Perhaps even:

points_possible = n(of S:);