How many times in total did the respondents answer a specific question (mean and sd)

[Mari4]

Hello!

I'm trying to count, how many times in total did the respondents answer a question X during the longitudinal study. I would like to have a mean and standard deviation.

Example:

NAME           QUESTION X                   QUESTION X              QUESTION X

                        AT POINT 1                   AT POINT 2                    AT POINT 3

Matt                       3                                         2                                     1           (three times)     

Lisa                       4                                                                                4            (two times)

Anne                                                                3                                      2           (two times)

Karl                       3                                                                                              (one time)

I would like to know how many times in total (mean and SD) the participants provided information on the question X? In the example, I can see that the mean is 2, but I don't know how to make the script in SAS.

Thank you so much for your help!

[AMSAS]

Here's one way to do it using some data step then pushing the results into PROC MEANS

/* Create Test Data */
data have ;
	infile cards ;
	input 
		name $
		q1 $
		q2 $
		q3 $ ;
cards ;
matt 3 2 1
lisa 4 . 4
anne . 3 2
karl 3 . . 
;

/* Add variable that counts number of responses to questions */

data temp1 ;
	set have ;
	array qs{3} q1-q3 ;
	qCnt=0 ;
	do i=1 to 3 ;
		if not missing(qs{i}) then
			qCnt+1 ;
		/* output values to log for testing */
		put name= qs{i}= qCnt= numberOfObs= ;
	end ;
	/* Output observation */
	output ;	
run ;

/* PROC MEANS provides mean and standard deviation */
proc means data=temp1 ;
	var qCnt ;
run ;

[PaigeMiller · Accepted solution]

data have ;
	infile cards ;
	input 
		name $
		q1
		q2
		q3 ;
cards ;
matt 3 2 1
lisa 4 . 4
anne . 3 2
karl 3 . . 
;

data have2;
    set have;
    qcnt = n(of q1-q3);
run;

proc means data=temp1 ;
	var qCnt ;
run ;

[Mari4]

Thank you for your quick help!

I used this command, and I got the result! So, I think that I managed to do this! 😄 I'm really happy to have help via this Community! 🙂

[Mari4]

Thank you for your help!
This array command is little strange to me, so I used the script below. I have to familiarize myself also to this array command! 🙂