topic how to compute standard deviation, skewness and kurtosis? in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812067#M320372 <P>dear all,</P><P>i have the data of in the following format</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type&nbsp;</TD><TD>percent_shares</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>10.76</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.37</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.01</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>9.26</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.61</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.13</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.04</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>6.81</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.25</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.58</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.18</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.18</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.05</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.36</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.39</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.64</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.33</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.17</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Non-Promoters</TD><TD>18.67</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Non-Promoters</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>10.8</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>18.94</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>6.81</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.06</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.19</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.58</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.05</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.39</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.33</TD></TR></TBODY></TABLE><P><BR />it represents the company name, year and shareholding percentage. it the panel data of nearly 5000 companies from 2010 to 2019.</P><P>i have to find out mean, standard deviation, skewness and kurtosis for each company for every year from 2010 to 2019.</P><P>my output should have the following information</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type&nbsp;</TD><TD>percent_shares</TD><TD>mean&nbsp;</TD><TD>stand.dev</TD><TD>skewness</TD><TD>kurtosis</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>please suggest the appropriate SAS CODE</P><P>&nbsp;</P><P>thanks in advance</P> Mon, 09 May 2022 04:16:52 GMT srikanthyadav44 2022-05-09T04:16:52Z how to compute standard deviation, skewness and kurtosis? https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812067#M320372 <P>dear all,</P><P>i have the data of in the following format</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type&nbsp;</TD><TD>percent_shares</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>10.76</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.37</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.01</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>9.26</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.61</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.13</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.04</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>6.81</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.25</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.58</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.18</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.18</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.05</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.36</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.39</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.64</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.33</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.17</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Non-Promoters</TD><TD>18.67</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Non-Promoters</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>10.8</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>18.94</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>6.81</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.06</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.19</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.58</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.05</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.39</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.33</TD></TR></TBODY></TABLE><P><BR />it represents the company name, year and shareholding percentage. it the panel data of nearly 5000 companies from 2010 to 2019.</P><P>i have to find out mean, standard deviation, skewness and kurtosis for each company for every year from 2010 to 2019.</P><P>my output should have the following information</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type&nbsp;</TD><TD>percent_shares</TD><TD>mean&nbsp;</TD><TD>stand.dev</TD><TD>skewness</TD><TD>kurtosis</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>please suggest the appropriate SAS CODE</P><P>&nbsp;</P><P>thanks in advance</P> Mon, 09 May 2022 04:16:52 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812067#M320372 srikanthyadav44 2022-05-09T04:16:52Z Re: how to compute standard deviation, skewness and kurtosis? https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812073#M320378 <P>how about this.</P> <PRE><CODE class=" language-sas">data have; length company_name $15 year 8 type $16 percent_shares 8; input company_name $ 1-15 year type $ 22-37 percent_shares; datalines; 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.77 20 Microns Ltd. 2010 Locked-In Shares 2.5 20 Microns Ltd. 2010 Locked-In Shares 0.57 20 Microns Ltd. 2010 Locked-In Shares 0.35 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 1.85 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0.5 20 Microns Ltd. 2010 Locked-In Shares 10.76 20 Microns Ltd. 2010 Locked-In Shares 0.37 20 Microns Ltd. 2010 Locked-In Shares 0.01 20 Microns Ltd. 2010 Locked-In Shares 9.26 20 Microns Ltd. 2010 Locked-In Shares 0.61 20 Microns Ltd. 2010 Locked-In Shares 0.13 20 Microns Ltd. 2010 Locked-In Shares 0.14 20 Microns Ltd. 2010 Locked-In Shares 0.08 20 Microns Ltd. 2010 Locked-In Shares 0.12 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.65 20 Microns Ltd. 2010 Locked-In Shares 0.21 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 0.04 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0 20 Microns Ltd. 2010 Locked-In Shares 6.81 20 Microns Ltd. 2010 Locked-In Shares 1.25 20 Microns Ltd. 2010 Locked-In Shares 0.58 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 1.05 20 Microns Ltd. 2010 Locked-In Shares 0.36 20 Microns Ltd. 2010 Locked-In Shares 1.39 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.64 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.33 20 Microns Ltd. 2010 Locked-In Shares 0.17 20 Microns Ltd. 2010 Non-Promoters 18.67 20 Microns Ltd. 2010 Non-Promoters 1.65 20 Microns Ltd. 2010 Promoters 0.77 20 Microns Ltd. 2010 Promoters 2.5 20 Microns Ltd. 2010 Promoters 0.57 20 Microns Ltd. 2010 Promoters 0.35 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 1.85 20 Microns Ltd. 2010 Promoters 10.8 20 Microns Ltd. 2010 Promoters 18.94 20 Microns Ltd. 2010 Promoters 0.14 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.08 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.21 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 6.81 20 Microns Ltd. 2010 Promoters 0.06 20 Microns Ltd. 2010 Promoters 1.19 20 Microns Ltd. 2010 Promoters 0.58 20 Microns Ltd. 2010 Promoters 1.05 20 Microns Ltd. 2010 Promoters 1.39 20 Microns Ltd. 2010 Promoters 0.33 ; run; proc univariate data=have noprint; by company_name year type; output out=want MEAN =mean STDDEV =stddev SKEWNESS =skewness KURTOSIS =kurtosis; run; </CODE></PRE> Mon, 09 May 2022 05:22:03 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812073#M320378 japelin 2022-05-09T05:22:03Z Re: how to compute standard deviation, skewness and kurtosis? https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812129#M320411 thanks a lot.<BR />the code is working Mon, 09 May 2022 11:26:05 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-standard-deviation-skewness-and-kurtosis/m-p/812129#M320411 srikanthyadav44 2022-05-09T11:26:05Z