topic Re: how to comptue skewness, kurtosis and standard deviation and save the values ? in New SAS User

topic Re: how to comptue skewness, kurtosis and standard deviation and save the values ? in New SAS User https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597989#M16231 thank you piagemiller Sun, 20 Oct 2019 17:13:11 GMT srikanthyadav44 2019-10-20T17:13:11Z how to comptue skewness, kurtosis and standard deviation and save the values ? https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597977#M16228 <P>dear all, </P><P>I have to compute skewness, kurtosis and standard deviation of stocks of 100 companies. </P><P>And also, to save the values in the separate file stock-wise. </P><P> </P><P>the input data format is as follows </P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>X1</TD><TD>X2</TD><TD>X3</TD><TD>………..</TD><TD>X100</TD></TR><TR><TD>1-Jan-18</TD><TD>0.27</TD><TD>-1.33</TD><TD>-1.77</TD><TD>………..</TD><TD>-0.33</TD></TR><TR><TD>2-Jan-18</TD><TD>-1.06</TD><TD>0.17</TD><TD>-0.06</TD><TD>………..</TD><TD>-2.15</TD></TR><TR><TD>3-Jan-18</TD><TD>0.17</TD><TD>-1.63</TD><TD>-0.54</TD><TD>………..</TD><TD>0.32</TD></TR><TR><TD>4-Jan-18</TD><TD>-0.1</TD><TD>0.72</TD><TD>2.26</TD><TD>………..</TD><TD>0.93</TD></TR><TR><TD>5-Jan-18</TD><TD>0.6</TD><TD>0.47</TD><TD>3.45</TD><TD>………..</TD><TD>3.25</TD></TR><TR><TD>8-Jan-18</TD><TD>0.39</TD><TD>-0.13</TD><TD>1.23</TD><TD>………..</TD><TD>-4.38</TD></TR><TR><TD>9-Jan-18</TD><TD>-0.03</TD><TD>-0.98</TD><TD>-0.94</TD><TD>………..</TD><TD>-1.27</TD></TR><TR><TD>10-Jan-18</TD><TD>-0.44</TD><TD>-1.11</TD><TD>-0.95</TD><TD>………..</TD><TD>-0.67</TD></TR><TR><TD>11-Jan-18</TD><TD>-0.72</TD><TD>-0.44</TD><TD>-1.21</TD><TD>………..</TD><TD>1.65</TD></TR><TR><TD>12-Jan-18</TD><TD>-0.65</TD><TD>-0.57</TD><TD>-0.58</TD><TD>………..</TD><TD>-1.01</TD></TR><TR><TD>15-Jan-18</TD><TD>0.98</TD><TD>-0.29</TD><TD>-1.8</TD><TD>………..</TD><TD>-0.99</TD></TR><TR><TD>16-Jan-18</TD><TD>0.47</TD><TD>-0.19</TD><TD>-2.92</TD><TD>………..</TD><TD>-1.44</TD></TR><TR><TD>17-Jan-18</TD><TD>3.91</TD><TD>1.08</TD><TD>0.82</TD><TD>………..</TD><TD>0.53</TD></TR><TR><TD>18-Jan-18</TD><TD>-0.07</TD><TD>0.22</TD><TD>-2.38</TD><TD>………..</TD><TD>-0.98</TD></TR><TR><TD>19-Jan-18</TD><TD>0.93</TD><TD>0.29</TD><TD>2.48</TD><TD>………..</TD><TD>0.59</TD></TR><TR><TD>22-Jan-18</TD><TD>3.61</TD><TD>2</TD><TD>0.26</TD><TD>………..</TD><TD>-1.45</TD></TR><TR><TD>23-Jan-18</TD><TD>1.4</TD><TD>0.66</TD><TD>0.14</TD><TD>………..</TD><TD>0.29</TD></TR><TR><TD>24-Jan-18</TD><TD>-1.96</TD><TD>1.38</TD><TD>1.78</TD><TD>………..</TD><TD>-6.62</TD></TR><TR><TD>25-Jan-18</TD><TD>1.34</TD><TD>-0.89</TD><TD>-1.66</TD><TD>………..</TD><TD>-1.48</TD></TR><TR><TD>29-Jan-18</TD><TD>-1.71</TD><TD>1.58</TD><TD>0.29</TD><TD>………..</TD><TD>-2.67</TD></TR><TR><TD>30-Jan-18</TD><TD>-1.95</TD><TD>-0.17</TD><TD>-2.15</TD><TD>………..</TD><TD>0.64</TD></TR><TR><TD>31-Jan-18</TD><TD>-0.03</TD><TD>-0.63</TD><TD>-0.03</TD><TD>………..</TD><TD>-0.17</TD></TR></TBODY></TABLE><P> </P><P>output format should be as follows</P><TABLE><TBODY><TR><TD>Stock </TD><TD>Skewss</TD><TD>Kurtosis</TD><TD>Standard_Deviation</TD></TR><TR><TD>X1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X2</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X3</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>…</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>…</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>…</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>…</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>…</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>…</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>X100</TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>thanks in advance </P> Sun, 20 Oct 2019 12:19:04 GMT https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597977#M16228 srikanthyadav44 2019-10-20T12:19:04Z Re: how to comptue skewness, kurtosis and standard deviation and save the values ? https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597979#M16229 <PRE><CODE class=" language-sas">ods output summary=summary; proc means data=have stackodsoutput skewness kurtosis stddev; var x1-x100; run;</CODE></PRE> Sun, 20 Oct 2019 12:38:42 GMT https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597979#M16229 PaigeMiller 2019-10-20T12:38:42Z Re: how to comptue skewness, kurtosis and standard deviation and save the values ? https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597989#M16231 thank you piagemiller Sun, 20 Oct 2019 17:13:11 GMT https://communities.sas.com/t5/New-SAS-User/how-to-comptue-skewness-kurtosis-and-standard-deviation-and-save/m-p/597989#M16231 srikanthyadav44 2019-10-20T17:13:11Z