https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789462#M252627 <P>Hi everyone!</P><P>I'm starting with a dataset like this:</P><P>&nbsp;</P><P>&nbsp; Question&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unit&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Score</P><P>&nbsp; ------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-------</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.5</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.5</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jennifer&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.5</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jennifer&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jennifer&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5</P><P>&nbsp;</P><P>And I'm hoping, using iterative data step code, to generate a table that looks like this:</P><P>&nbsp;</P><P>&nbsp; Question&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mean_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Median_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Min_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Max_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SEM_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Conf95_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Std_Dev_Score</P><P>&nbsp; ------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -----------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -------------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ----------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;------------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------------------</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.16667&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.2722&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.533&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.4714</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.2357&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.462&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.4082</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.16667&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.5932&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.163&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.0274</P><P>&nbsp;</P><P>Any assistance you can provide would be greatly appreciated!</P><P>&nbsp;</P><P>Thank you!</P> Tue, 11 Jan 2022 13:50:15 GMT mtgkooks 2022-01-11T13:50:15Z https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789462#M252627 <P>Hi everyone!</P><P>I'm starting with a dataset like this:</P><P>&nbsp;</P><P>&nbsp; Question&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Unit&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Score</P><P>&nbsp; ------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -----&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-------</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.5</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.5</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jennifer&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.5</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jennifer&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jennifer&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5</P><P>&nbsp;</P><P>And I'm hoping, using iterative data step code, to generate a table that looks like this:</P><P>&nbsp;</P><P>&nbsp; Question&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mean_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Median_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Min_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Max_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SEM_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Conf95_Score&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Std_Dev_Score</P><P>&nbsp; ------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -----------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -------------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ----------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;------------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;---------------------</P><P>&nbsp; 111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.16667&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.2722&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.533&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.4714</P><P>&nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.2357&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.462&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.4082</P><P>&nbsp; 113&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.16667&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.5932&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.163&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.0274</P><P>&nbsp;</P><P>Any assistance you can provide would be greatly appreciated!</P><P>&nbsp;</P><P>Thank you!</P> Tue, 11 Jan 2022 13:50:15 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789462#M252627 mtgkooks 2022-01-11T13:50:15Z https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789478#M252630 <P>What is iterative about that?</P> <P>&nbsp;</P> <P>If you want to calculate statistics use PROC MEANS.</P> <P>Looks like you want to use QUESTION as a BY or CLASS variable.</P> Tue, 11 Jan 2022 15:09:43 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789478#M252630 Tom 2022-01-11T15:09:43Z https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789484#M252631 <P>Here's the link to <A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0f0fjpjeuco4gn1ri963f683mi4.htm" target="_self">PROC MEANS</A><BR />Go take a look at that, and the examples, and you can probably get the results you are looking for.</P> Tue, 11 Jan 2022 15:42:27 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-use-iterative-code-to-generate-summary-statistics/m-p/789484#M252631 AMSAS 2022-01-11T15:42:27Z