topic Re: finding an average via long data longitunidal data output (doc attached has the display) in SAS Programming

finding an average via long data longitunidal data output (doc attached has the display)

mgrzyb — Sat, 30 Jun 2018 15:30:14 GMT

Hi again.

Thank you for reading this!

If any of you know how to sum all the S1 scores/n where n=15 …… S20 scores/15, please let me know.

I have done this before and it has been a long time. But I am in need of help.

Thank you once again.

See the attachment. I want to calculate the mean of each column (s1-s20).

Re: finding an average via long data longitunidal data output (doc attached has the display)

novinosrin — Sat, 30 Jun 2018 15:35:35 GMT

Have you tried Proc means or Proc summary. A simple google search and copy paste is what you need i think

Re: finding an average via long data longitunidal data output (doc attached has the display)

mgrzyb — Sat, 30 Jun 2018 15:50:42 GMT

I tried finding a link, but could not find one. Thanks.

Re: finding an average via long data longitunidal data output (doc attached has the display)

novinosrin — Sat, 30 Jun 2018 15:56:47 GMT

proc means data=your_dataset;
var s1-s20;
output out=want mean = / AUTONAME;
run;

Re: finding an average via long data longitunidal data output (doc attached has the display)

Reeza — Sat, 30 Jun 2018 18:57:58 GMT

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas

Not sure where you're searching but try starting at LexJansen.com though make sure to get the later results since SAS goes back to 1980's at least on there.

Many more resources:

https://www.lexjansen.com/search/searchresults.php?q=proc%20means%20beginner

@mgrzyb wrote:

I tried finding a link, but could not find one. Thanks.