topic Re: SAS Code to calculate per participant(any variable) in SAS Programming

SAS Code to calculate per participant(any variable)

knargis160 — Thu, 09 Jan 2020 14:04:48 GMT

Hi,

I am trying to calculate number of comments made per post-I have post-id and data set which only contains comments.

proc means noprint data=comments; by studyid post_id ; var studyid;class week group;
output out=nc_perpost min=xxx; run;

Can anyone help explaining more about "proc means noprint" and how should I verify my code.

Thanks,

Re: SAS Code to calculate per participant(any variable)

Kurt_Bremser — Thu, 09 Jan 2020 14:34:14 GMT

FORMAT your code. This spaghetti heap is not conducive to debugging and maintaining:

proc means data=comments noprint;
by studyid post_id;
class week group;
var studyid;
output out=nc_perpost min=xxx;
run;

To verify the code, look at the resulting dataset (nc_perpost), and see if it meets your expectations.
The NOPRINT option prevents creation of output via ODS.

Re: SAS Code to calculate per participant(any variable)

ed_sas_member — Thu, 09 Jan 2020 14:37:27 GMT

Hi @knargis160

I am not sure that PROC MEANS is the better way to do this job.

PROC FREQ or Proc SQL for example could be a better approach to compute frequencies.

Could you please share a sample of data and the desired output?

Re: SAS Code to calculate per participant(any variable)

knargis160 — Thu, 09 Jan 2020 14:48:32 GMT

Can you also add the code to get mean/std sum for number of participants per post in the same code

Re: SAS Code to calculate per participant(any variable)

ed_sas_member — Thu, 09 Jan 2020 15:11:27 GMT

proc means data=comments noprint n mean sum std;
	by studyid post_id;
	class week group;
	var studyid;
	output out=nc_perpost n= mean= std= sum= / autoname;
run;

Re: SAS Code to calculate per participant(any variable)

knargis160 — Thu, 09 Jan 2020 16:28:52 GMT

Can you give a example code in proc sql or proc freq about how to calculate total number of (any variable) per any variable?

Re: SAS Code to calculate per participant(any variable)

Reeza — Thu, 09 Jan 2020 16:32:10 GMT

https://www.listendata.com/2015/01/sas-detailed-explanation-of-proc-means.html

FREQ won't calculate STD. SQL can but it's not as efficient as PROC MEANS.

Re: SAS Code to calculate per participant(any variable)

Astounding — Fri, 10 Jan 2020 14:19:43 GMT

My spider sense is tingling. It seems you might need a lot of help on this.

If you want to compute statistics (mean, std, sum) on a numeric variable. that variable has to exist in your data set. I'm not sure from your post that it actually exists. Perhaps your data set has a single observation per post, and you have to count those first.

Does your data set really contain variables named WEEK and GROUP? If so, what do they represent and how do they affect what you want to count?