topic Re: How many times in total did the respondents answer a specific question (mean and sd) in SAS Programming

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

Mari4 — Tue, 15 Nov 2022 11:21:16 GMT

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!

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

AMSAS — Tue, 15 Nov 2022 13:04:00 GMT

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 ;

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

PaigeMiller — Tue, 15 Nov 2022 13:22:14 GMT

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 ;

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

Mari4 — Tue, 15 Nov 2022 13:38:30 GMT

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! 🙂

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

Mari4 — Tue, 15 Nov 2022 13:41:28 GMT

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! 🙂