topic Proc means output in SAS Programming

topic Proc means output in SAS Programming https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455370#M115172 <P>Hello Team,</P><P> </P><P>How to get all numeric fields stats details by using PROC MEANS and output should be in SAS dataset (no need report).</P><P>Input:</P><TABLE><TBODY><TR><TD><P>Num1</P></TD><TD><P>New_Ques</P></TD><TD><P>New_Status_1</P></TD><TD><P>new_ Interval</P></TD><TD><P>New_Status_2</P></TD><TD><P>new_ address</P></TD></TR><TR><TD><P>234</P></TD><TD><P>13</P></TD><TD><P>8</P></TD><TD><P>7</P></TD><TD><P>14</P></TD><TD><P>24</P></TD></TR><TR><TD><P>431</P></TD><TD><P>20</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>28</P></TD></TR><TR><TD><P>755</P></TD><TD><P>36</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>13</P></TD><TD><P>27</P></TD></TR><TR><TD><P>753</P></TD><TD><P>28</P></TD><TD><P>14</P></TD><TD><P>9</P></TD><TD><P>13</P></TD><TD><P>17</P></TD></TR><TR><TD><P>941</P></TD><TD><P>28</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>15</P></TD></TR><TR><TD><P>526</P></TD><TD><P>33</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>20</P></TD></TR><TR><TD><P>621</P></TD><TD><P>46</P></TD><TD><P>14</P></TD><TD><P>7</P></TD><TD><P>13</P></TD><TD><P>14</P></TD></TR><TR><TD><P>834</P></TD><TD><P>29</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>22</P></TD></TR></TBODY></TABLE><P> </P><P> </P><P>Output:</P><TABLE><TBODY><TR><TD><P>Var</P></TD><TD><P>Mean</P></TD><TD><P>Std</P></TD><TD><P>Min</P></TD><TD><P>Max</P></TD><TD><P>P5</P></TD><TD><P>P25</P></TD><TD><P>P50</P></TD><TD><P>P75</P></TD></TR><TR><TD><P>Num1</P></TD><TD><P>636.875</P></TD><TD><P>231.7717</P></TD><TD><P>234</P></TD><TD><P>941</P></TD><TD><P>234</P></TD><TD><P>478.5</P></TD><TD><P>234</P></TD><TD><P>794.5</P></TD></TR><TR><TD><P>New_Ques</P></TD><TD><P>29.125</P></TD><TD><P>9.948977</P></TD><TD><P>13</P></TD><TD><P>46</P></TD><TD><P>13</P></TD><TD><P>24</P></TD><TD><P>13</P></TD><TD><P>34.5</P></TD></TR><TR><TD><P>New_Status_1</P></TD><TD><P>9.5</P></TD><TD><P>2.77746</P></TD><TD><P>8</P></TD><TD><P>14</P></TD><TD><P>8</P></TD><TD><P>8</P></TD><TD><P>8</P></TD><TD><P>11</P></TD></TR><TR><TD><P>new_ Interval</P></TD><TD><P>6.625</P></TD><TD><P>1.06066</P></TD><TD><P>6</P></TD><TD><P>9</P></TD><TD><P>6</P></TD><TD><P>6</P></TD><TD><P>6</P></TD><TD><P>7</P></TD></TR><TR><TD><P>New_Status_2</P></TD><TD><P>13.625</P></TD><TD><P>0.517549</P></TD><TD><P>13</P></TD><TD><P>14</P></TD><TD><P>13</P></TD><TD><P>13</P></TD><TD><P>13</P></TD><TD><P>14</P></TD></TR><TR><TD><P>new_ address</P></TD><TD><P>20.875</P></TD><TD><P>5.303301</P></TD><TD><P>14</P></TD><TD><P>28</P></TD><TD><P>14</P></TD><TD><P>16</P></TD><TD><P>14</P></TD><TD><P>25.5</P></TD></TR></TBODY></TABLE> Wed, 18 Apr 2018 19:34:29 GMT cho16 2018-04-18T19:34:29Z Proc means output https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455370#M115172 <P>Hello Team,</P><P> </P><P>How to get all numeric fields stats details by using PROC MEANS and output should be in SAS dataset (no need report).</P><P>Input:</P><TABLE><TBODY><TR><TD><P>Num1</P></TD><TD><P>New_Ques</P></TD><TD><P>New_Status_1</P></TD><TD><P>new_ Interval</P></TD><TD><P>New_Status_2</P></TD><TD><P>new_ address</P></TD></TR><TR><TD><P>234</P></TD><TD><P>13</P></TD><TD><P>8</P></TD><TD><P>7</P></TD><TD><P>14</P></TD><TD><P>24</P></TD></TR><TR><TD><P>431</P></TD><TD><P>20</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>28</P></TD></TR><TR><TD><P>755</P></TD><TD><P>36</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>13</P></TD><TD><P>27</P></TD></TR><TR><TD><P>753</P></TD><TD><P>28</P></TD><TD><P>14</P></TD><TD><P>9</P></TD><TD><P>13</P></TD><TD><P>17</P></TD></TR><TR><TD><P>941</P></TD><TD><P>28</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>15</P></TD></TR><TR><TD><P>526</P></TD><TD><P>33</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>20</P></TD></TR><TR><TD><P>621</P></TD><TD><P>46</P></TD><TD><P>14</P></TD><TD><P>7</P></TD><TD><P>13</P></TD><TD><P>14</P></TD></TR><TR><TD><P>834</P></TD><TD><P>29</P></TD><TD><P>8</P></TD><TD><P>6</P></TD><TD><P>14</P></TD><TD><P>22</P></TD></TR></TBODY></TABLE><P> </P><P> </P><P>Output:</P><TABLE><TBODY><TR><TD><P>Var</P></TD><TD><P>Mean</P></TD><TD><P>Std</P></TD><TD><P>Min</P></TD><TD><P>Max</P></TD><TD><P>P5</P></TD><TD><P>P25</P></TD><TD><P>P50</P></TD><TD><P>P75</P></TD></TR><TR><TD><P>Num1</P></TD><TD><P>636.875</P></TD><TD><P>231.7717</P></TD><TD><P>234</P></TD><TD><P>941</P></TD><TD><P>234</P></TD><TD><P>478.5</P></TD><TD><P>234</P></TD><TD><P>794.5</P></TD></TR><TR><TD><P>New_Ques</P></TD><TD><P>29.125</P></TD><TD><P>9.948977</P></TD><TD><P>13</P></TD><TD><P>46</P></TD><TD><P>13</P></TD><TD><P>24</P></TD><TD><P>13</P></TD><TD><P>34.5</P></TD></TR><TR><TD><P>New_Status_1</P></TD><TD><P>9.5</P></TD><TD><P>2.77746</P></TD><TD><P>8</P></TD><TD><P>14</P></TD><TD><P>8</P></TD><TD><P>8</P></TD><TD><P>8</P></TD><TD><P>11</P></TD></TR><TR><TD><P>new_ Interval</P></TD><TD><P>6.625</P></TD><TD><P>1.06066</P></TD><TD><P>6</P></TD><TD><P>9</P></TD><TD><P>6</P></TD><TD><P>6</P></TD><TD><P>6</P></TD><TD><P>7</P></TD></TR><TR><TD><P>New_Status_2</P></TD><TD><P>13.625</P></TD><TD><P>0.517549</P></TD><TD><P>13</P></TD><TD><P>14</P></TD><TD><P>13</P></TD><TD><P>13</P></TD><TD><P>13</P></TD><TD><P>14</P></TD></TR><TR><TD><P>new_ address</P></TD><TD><P>20.875</P></TD><TD><P>5.303301</P></TD><TD><P>14</P></TD><TD><P>28</P></TD><TD><P>14</P></TD><TD><P>16</P></TD><TD><P>14</P></TD><TD><P>25.5</P></TD></TR></TBODY></TABLE> Wed, 18 Apr 2018 19:34:29 GMT https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455370#M115172 cho16 2018-04-18T19:34:29Z Re: Proc means output https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455379#M115175 <P>PROC SUMMARY or PROC MEANS will do this. There are examples in the documentation</P> <P><A href="http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p0f0fjpjeuco4gn1ri963f683mi4.htm&locale=en" target="_blank">http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p0f0fjpjeuco4gn1ri963f683mi4.htm&locale=en</A></P> Wed, 18 Apr 2018 19:47:39 GMT https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455379#M115175 PaigeMiller 2018-04-18T19:47:39Z Re: Proc means output https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455398#M115189 <P><A href="https://communities.sas.com/t5/General-SAS-Programming/Get-all-character-fields-value-s-length-in-new-fields-then-use/m-p/455346#M56340" target="_blank">https://communities.sas.com/t5/General-SAS-Programming/Get-all-character-fields-value-s-length-in-new-fields-then-use/m-p/455346#M56340</A></P> <P> </P> <P>Is there any specific reason you're using multiple ID's here?</P> <P> </P> <P>Or is this a homework question of sorts?</P> Wed, 18 Apr 2018 20:44:25 GMT https://communities.sas.com/t5/SAS-Programming/Proc-means-output/m-p/455398#M115189 Reeza 2018-04-18T20:44:25Z