topic Re: Find top values please any one can help in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829676#M81983 <P>Define what you mean by "top value". Largest single value? Largest sum or mean? Most frequent value? Something else?</P> <P>For which variable(s)?</P> <P>Using what groups?</P> Mon, 22 Aug 2022 15:33:30 GMT ballardw 2022-08-22T15:33:30Z Find top values please any one can help https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829625#M81982 <DIV class=""><DIV align="center">Obs EmpId EmpName EmpLocaton Sex Designation Salary Age1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD>101</TD><TD>Tejasree</TD><TD>nlr</TD><TD>female</TD><TD>developer</TD><TD>24000</TD><TD>25</TD></TR><TR><TD>102</TD><TD>Aravind</TD><TD>tpt</TD><TD>male</TD><TD>sales</TD><TD>26000</TD><TD>27</TD></TR><TR><TD>103</TD><TD>Malli</TD><TD>ctc</TD><TD>male</TD><TD>marketing</TD><TD>28000</TD><TD>23</TD></TR><TR><TD>104</TD><TD>Jagan</TD><TD>ongole</TD><TD>male</TD><TD>nontech</TD><TD>30000</TD><TD>24</TD></TR><TR><TD>105</TD><TD>Meghana</TD><TD>hyd</TD><TD>female</TD><TD>tech</TD><TD>32000</TD><TD>26</TD></TR><TR><TD>106</TD><TD>Praveen</TD><TD>nlr</TD><TD>male</TD><TD>analysit</TD><TD>34000</TD><TD>24</TD></TR><TR><TD>107</TD><TD>Likitha</TD><TD>kadapa</TD><TD>female</TD><TD>sap</TD><TD>36000</TD><TD>27</TD></TR><TR><TD>108</TD><TD>Tejeshswar</TD><TD>anthapur</TD><TD>male</TD><TD>sas</TD><TD>38000</TD><TD>22</TD></TR><TR><TD>109</TD><TD>Tanisha</TD><TD>tpt</TD><TD>female</TD><TD>sales</TD><TD>40000</TD><TD>28</TD></TR><TR><TD>110</TD><TD>Bhanu</TD><TD>guntur</TD><TD>male</TD><TD>marketing</TD><TD>42000</TD><TD>46</TD></TR><TR><TD>111</TD><TD>Mourya</TD><TD>nlr</TD><TD>male</TD><TD>sql analysit</TD><TD>44000</TD><TD>25</TD></TR><TR><TD>112</TD><TD>Manohar</TD><TD>tpt</TD><TD>male</TD><TD>developer</TD><TD>46000</TD><TD>27</TD></TR><TR><TD>113</TD><TD>Thanvitha</TD><TD>ctc</TD><TD>female</TD><TD>sales</TD><TD>48000</TD><TD>23</TD></TR><TR><TD>114</TD><TD>Chethan</TD><TD>ongole</TD><TD>male</TD><TD>marketing</TD><TD>50000</TD><TD>24</TD></TR><TR><TD>115</TD><TD>kumar</TD><TD>hyd</TD><TD>male</TD><TD>nontech</TD><TD>52000</TD><TD>26</TD></TR><TR><TD>116</TD><TD>Mouni</TD><TD>nlr</TD><TD>female</TD><TD>tech</TD><TD>54000</TD><TD>24</TD></TR><TR><TD>117</TD><TD>Jai</TD><TD>kadapa</TD><TD>male</TD><TD>analysit</TD><TD>56000</TD><TD>27</TD></TR><TR><TD>118</TD><TD>Karthik</TD><TD>anthapur</TD><TD>male</TD><TD>sap</TD><TD>58000</TD><TD>22</TD></TR><TR><TD>119</TD><TD>Swarna</TD><TD>tpt</TD><TD>female</TD><TD>sas</TD><TD>60000</TD><TD>28</TD></TR><TR><TD>120</TD><TD>Sahana</TD><TD>guntur</TD><TD>female</TD><TD>sales</TD><TD>62000</TD><TD>46</TD></TR><TR><TD>121</TD><TD>Nagaraj</TD><TD>nlr</TD><TD>male</TD><TD>marketing</TD><TD>64000</TD><TD>25</TD></TR><TR><TD>122</TD><TD>Kusuma</TD><TD>tpt</TD><TD>female</TD><TD>sql analysit</TD><TD>66000</TD><TD>27</TD></TR><TR><TD>123</TD><TD>Sai</TD><TD>ctc</TD><TD>male</TD><TD>developer</TD><TD>68000</TD><TD>23</TD></TR><TR><TD>124</TD><TD>Pawan</TD><TD>ongole</TD><TD>male</TD><TD>sales</TD><TD>70000</TD><TD>24</TD></TR><TR><TD>125</TD><TD>Vamsi</TD><TD>hyd</TD><TD>male</TD><TD>marketing</TD><TD>72000</TD><TD>26</TD></TR><TR><TD>126</TD><TD>Ramya</TD><TD>nlr</TD><TD>female</TD><TD>nontech</TD><TD>74000</TD><TD>24</TD></TR><TR><TD>127</TD><TD>Sri vidya</TD><TD>kadapa</TD><TD>female</TD><TD>tech</TD><TD>76000</TD><TD>27</TD></TR><TR><TD>128</TD><TD>Sravani</TD><TD>anthapur</TD><TD>female</TD><TD>analysit</TD><TD>78000</TD><TD>22</TD></TR><TR><TD>129</TD><TD>Jayanthi</TD><TD>tpt</TD><TD>female</TD><TD>sap</TD><TD>80000</TD><TD>28</TD></TR><TR><TD>130</TD><TD>hasini</TD><TD>guntur</TD><TD>female</TD><TD>sas</TD><TD>82000</TD><TD>46</TD></TR><TR><TD>131</TD><TD>Yeaswanth</TD><TD>nlr</TD><TD>male</TD><TD>sales</TD><TD>84000</TD><TD>34</TD></TR><TR><TD>132</TD><TD>Naveen</TD><TD>tpt</TD><TD>male</TD><TD>marketing</TD><TD>86000</TD><TD>65</TD></TR><TR><TD>133</TD><TD>Har**bleep**h</TD><TD>ctc</TD><TD>male</TD><TD>sql analysit</TD><TD>88000</TD><TD>34</TD></TR><TR><TD>134</TD><TD>Mounika</TD><TD>ongole</TD><TD>female</TD><TD>developer</TD><TD>90000</TD><TD>89</TD></TR><TR><TD>135</TD><TD>Afroz</TD><TD>hyd</TD><TD>female</TD><TD>sales</TD><TD>92000</TD><TD>26</TD></TR><TR><TD>136</TD><TD>Suresh</TD><TD>nlr</TD><TD>male</TD><TD>marketing</TD><TD>94000</TD><TD>24</TD></TR><TR><TD>137</TD><TD>venu</TD><TD>kadapa</TD><TD>male</TD><TD>nontech</TD><TD>96000</TD><TD>27</TD></TR><TR><TD>138</TD><TD>Soumya</TD><TD>anthapur</TD><TD>female</TD><TD>tech</TD><TD>98000</TD><TD>22</TD></TR><TR><TD>139</TD><TD>Murali</TD><TD>tpt</TD><TD>male</TD><TD>analysit</TD><TD>100000</TD><TD>28</TD></TR><TR><TD>140</TD><TD>kiran</TD><TD>guntur</TD><TD>male</TD><TD>sap</TD><TD>102000</TD><TD>46</TD></TR><TR><TD>141</TD><TD>Rayudu</TD><TD>nlr</TD><TD>male</TD><TD>sas</TD><TD>104000</TD><TD>25</TD></TR><TR><TD>142</TD><TD>Sunil</TD><TD>tpt</TD><TD>male</TD><TD>sales</TD><TD>106000</TD><TD>27</TD></TR><TR><TD>143</TD><TD>Rahul</TD><TD>ctc</TD><TD>male</TD><TD>marketing</TD><TD>108000</TD><TD>23</TD></TR><TR><TD>144</TD><TD>hema</TD><TD>ongole</TD><TD>female</TD><TD>sql analysit</TD><TD>122000</TD><TD>24</TD></TR><TR><TD>145</TD><TD>Madhu</TD><TD>hyd</TD><TD>male</TD><TD>developer</TD><TD>112000</TD><TD>26</TD></TR><TR><TD>145</TD><TD>Joshna</TD><TD>nlr</TD><TD>female</TD><TD>sales</TD><TD>122000</TD><TD>24</TD></TR><TR><TD>146</TD><TD>Sree</TD><TD>kadapa</TD><TD>male</TD><TD>marketing</TD><TD>116000</TD><TD>27</TD></TR><TR><TD>148</TD><TD>Pavani</TD><TD>anthapur</TD><TD>female</TD><TD>nontech</TD><TD>118000</TD><TD>22</TD></TR><TR><TD>149</TD><TD>Swaroop</TD><TD>tpt</TD><TD>male</TD><TD>tech</TD><TD>122000</TD><TD>28</TD></TR><TR><TD>150</TD><TD>Manasa</TD><TD>guntur</TD><TD>female</TD><TD>analysit</TD><TD>122000</TD><TD>46</TD></TR></TBODY></TABLE><P>This my data</P><DIV class=""><DIV align="center">Obs EmpId EmpName EmpLocaton Sex Designation Salary Age1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950</DIV><DIV align="center"><DIV class=""><DIV align="center"><DIV class=""><DIV align="center"><DIV class=""><DIV><DIV align="center">Obs EmpId EmpName EmpLocaton Sex Designation Salary Age1234567891011 <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD>144</TD><TD>hema</TD><TD>ongole</TD><TD>female</TD><TD>sql analysit</TD><TD>122000</TD><TD>24</TD></TR><TR><TD>145</TD><TD>Joshna</TD><TD>nlr</TD><TD>female</TD><TD>sales</TD><TD>122000</TD><TD>24</TD></TR><TR><TD>149</TD><TD>Swaroop</TD><TD>tpt</TD><TD>male</TD><TD>tech</TD><TD>122000</TD><TD>28</TD></TR><TR><TD>150</TD><TD>Manasa</TD><TD>guntur</TD><TD>female</TD><TD>analysit</TD><TD>122000</TD><TD>46</TD></TR><TR><TD>148</TD><TD>Pavani</TD><TD>anthapur</TD><TD>female</TD><TD>nontech</TD><TD>118000</TD><TD>22</TD></TR><TR><TD>146</TD><TD>Sree</TD><TD>kadapa</TD><TD>male</TD><TD>marketing</TD><TD>116000</TD><TD>27</TD></TR><TR><TD>145</TD><TD>Madhu</TD><TD>hyd</TD><TD>male</TD><TD>developer</TD><TD>112000</TD><TD>26</TD></TR><TR><TD>143</TD><TD>Rahul</TD><TD>ctc</TD><TD>male</TD><TD>marketing</TD><TD>108000</TD><TD>23</TD></TR><TR><TD>142</TD><TD>Sunil</TD><TD>tpt</TD><TD>male</TD><TD>sales</TD><TD>106000</TD><TD>27</TD></TR><TR><TD>141</TD><TD>Rayudu</TD><TD>nlr</TD><TD>male</TD><TD>sas</TD><TD>104000</TD><TD>25</TD></TR><TR><TD>140</TD><TD>kiran</TD><TD>guntur</TD><TD>male</TD><TD>sap</TD><TD>102000</TD><TD>46</TD></TR></TBODY></TABLE></DIV></DIV></DIV></DIV></DIV></DIV></DIV><BR /><P>I have data like this&nbsp;</P><DIV class=""><DIV align="center">Obs EmpId EmpName EmpLocaton Sex Designation Salary Age12345 <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD>144</TD><TD>hema</TD><TD>ongole</TD><TD>female</TD><TD>sql analysit</TD><TD>122000</TD><TD>24</TD></TR><TR><TD>145</TD><TD>Joshna</TD><TD>nlr</TD><TD>female</TD><TD>sales</TD><TD>122000</TD><TD>24</TD></TR><TR><TD>149</TD><TD>Swaroop</TD><TD>tpt</TD><TD>male</TD><TD>tech</TD><TD>122000</TD><TD>28</TD></TR><TR><TD>150</TD><TD>Manasa</TD><TD>guntur</TD><TD>female</TD><TD>analysit</TD><TD>122000</TD><TD>46</TD></TR><TR><TD>148</TD><TD>Pavani</TD><TD>anthapur</TD><TD>female</TD><TD>nontech</TD><TD>118000</TD><TD>22</TD></TR></TBODY></TABLE><P>I got output like this , help me anyone&nbsp;</P></DIV></DIV></DIV></DIV></DIV></DIV> Mon, 22 Aug 2022 10:13:24 GMT https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829625#M81982 sas_university 2022-08-22T10:13:24Z Re: Find top values please any one can help https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829676#M81983 <P>Define what you mean by "top value". Largest single value? Largest sum or mean? Most frequent value? Something else?</P> <P>For which variable(s)?</P> <P>Using what groups?</P> Mon, 22 Aug 2022 15:33:30 GMT https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829676#M81983 ballardw 2022-08-22T15:33:30Z Re: Find top values please any one can help https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829682#M81984 <P><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/procstat/procstat_univariate_examples03.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/procstat/procstat_univariate_examples03.htm</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 Aug 2022 15:43:43 GMT https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/829682#M81984 Reeza 2022-08-22T15:43:43Z Re: Find top values please any one can help https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/830072#M81985 <P>If you want the most popular (=most frequent) categories, you can use the ORDER=FREQ option on PROC FREQ combined with the MAXLEVELS= option on the TABLES statement. For example:</P> <PRE><CODE class=" language-sas">%let TopN = 10; proc freq data=sashelp.cars ORDER=FREQ; tables make / maxlevels=&amp;TopN Plots=FreqPlot; run;</CODE></PRE> <P>For more information, see&nbsp;<A href="https://blogs.sas.com/content/iml/2018/06/04/top-10-table-bar-chart.html" target="_blank">https://blogs.sas.com/content/iml/2018/06/04/top-10-table-bar-chart.html</A></P> <P>&nbsp;</P> Wed, 24 Aug 2022 13:20:27 GMT https://communities.sas.com/t5/SAS-Procedures/Find-top-values-please-any-one-can-help/m-p/830072#M81985 Rick_SAS 2022-08-24T13:20:27Z