topic Re: How to identify the Peer group company? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788861#M252345 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote: <P class="1641563793460">......</P> <P>please suggest me the suitable SAS code&nbsp;</P> <P>&nbsp;</P> <P>thanks in advance&nbsp;</P> <HR /></BLOCKQUOTE> <P>Please post data in usable form!</P> <P>And show the expected result using the posted data, also add an example explaining how (at least) one observation is created in the expected dataset.</P> Fri, 07 Jan 2022 14:02:11 GMT andreas_lds 2022-01-07T14:02:11Z How to identify the Peer group company? https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788852#M252342 <P>dear all&nbsp;</P><P>i have the dataset of 4,202 companies having the data of their industry code(NIC code), market capitalization and whether the company ESG group or not. the given below is the format of my dataset</P><TABLE><TBODY><TR><TD>company_name</TD><TD>nic</TD><TD>mcap</TD><TD>ESG_company</TD></TR><TR><TD>A D F Foods Ltd.</TD><TD>10</TD><TD>17874.78</TD><TD>NON_ESG</TD></TR><TR><TD>Agro Tech Foods Ltd.</TD><TD>10</TD><TD>20365.39</TD><TD>NON_ESG</TD></TR><TR><TD>Ajanta Soya Ltd.</TD><TD>10</TD><TD>1142.86</TD><TD>NON_ESG</TD></TR><TR><TD>Ajooni Biotech Ltd.</TD><TD>10</TD><TD>304.17</TD><TD>NON_ESG</TD></TR><TR><TD>Amrit Corp. Ltd.</TD><TD>10</TD><TD>2096.38</TD><TD>NON_ESG</TD></TR><TR><TD>Andrew Yule &amp; Co. Ltd.</TD><TD>10</TD><TD>9656.78</TD><TD>NON_ESG</TD></TR><TR><TD>Anjani Foods Ltd.</TD><TD>10</TD><TD>1226.96</TD><TD>NON_ESG</TD></TR><TR><TD>Apex Frozen Foods Ltd.</TD><TD>10</TD><TD>6481.25</TD><TD>NON_ESG</TD></TR><TR><TD>Avadh Sugar &amp; Energy Ltd.</TD><TD>10</TD><TD>3704.41</TD><TD>NON_ESG</TD></TR><TR><TD>Avanti Feeds Ltd.</TD><TD>10</TD><TD>56490.84</TD><TD>NON_ESG</TD></TR><TR><TD>B &amp; A Ltd.</TD><TD>10</TD><TD>459.42</TD><TD>NON_ESG</TD></TR><TR><TD>B C L Industries Ltd.</TD><TD>10</TD><TD>2580.43</TD><TD>NON_ESG</TD></TR><TR><TD>Bajaj Hindusthan Sugar Ltd.</TD><TD>10</TD><TD>7022.4</TD><TD>NON_ESG</TD></TR><TR><TD>Balrampur Chini Mills Ltd.</TD><TD>10</TD><TD>45045</TD><TD>NON_ESG</TD></TR><TR><TD>Bambino Agro Inds. Ltd.</TD><TD>10</TD><TD>1360.7</TD><TD>NON_ESG</TD></TR><TR><TD>Bannari Amman Sugars Ltd.</TD><TD>10</TD><TD>19777.3</TD><TD>NON_ESG</TD></TR><TR><TD>Bengal Tea &amp; Fabrics Ltd.</TD><TD>10</TD><TD>348.53</TD><TD>NON_ESG</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>10</TD><TD>873526.94</TD><TD>ESG</TD></TR><TR><TD>C C L Products (India) Ltd.</TD><TD>10</TD><TD>31135.18</TD><TD>NON_ESG</TD></TR><TR><TD>Chordia Food Products Ltd.</TD><TD>10</TD><TD>402.83</TD><TD>NON_ESG</TD></TR><TR><TD>Coastal Corporation Ltd.</TD><TD>10</TD><TD>1826.07</TD><TD>NON_ESG</TD></TR><TR><TD>D C M Shriram Inds. Ltd.</TD><TD>10</TD><TD>3269.17</TD><TD>NON_ESG</TD></TR><TR><TD>D F M Foods Ltd.</TD><TD>10</TD><TD>18345.1</TD><TD>NON_ESG</TD></TR><TR><TD>Dalmia Bharat Sugar &amp; Inds. Ltd.</TD><TD>10</TD><TD>15105.3</TD><TD>NON_ESG</TD></TR><TR><TD>Dangee Dums Ltd.</TD><TD>10</TD><TD>1328.8</TD><TD>NON_ESG</TD></TR><TR><TD>Datiware Maritime Infra Ltd.</TD><TD>10</TD><TD>95</TD><TD>NON_ESG</TD></TR><TR><TD>Davangere Sugar Co. Ltd.</TD><TD>10</TD><TD>818.56</TD><TD>NON_ESG</TD></TR><TR><TD>Dhampur Sugar Mills Ltd.</TD><TD>10</TD><TD>12138.97</TD><TD>NON_ESG</TD></TR><TR><TD>Dharani Sugars &amp; Chemicals Ltd.</TD><TD>10</TD><TD>215.14</TD><TD>NON_ESG</TD></TR><TR><TD>Dhunseri Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>1804.3</TD><TD>NON_ESG</TD></TR><TR><TD>Diana Tea Co. Ltd.</TD><TD>10</TD><TD>243.6</TD><TD>NON_ESG</TD></TR><TR><TD>Diligent Industries Ltd.</TD><TD>10</TD><TD>187.55</TD><TD>NON_ESG</TD></TR><TR><TD>Dwarikesh Sugar Inds. Ltd.</TD><TD>10</TD><TD>5799.69</TD><TD>NON_ESG</TD></TR><TR><TD>E I D-Parry (India) Ltd.</TD><TD>10</TD><TD>56411.54</TD><TD>NON_ESG</TD></TR><TR><TD>Euro India Fresh Foods Ltd.</TD><TD>10</TD><TD>1915.8</TD><TD>NON_ESG</TD></TR><TR><TD>Foods &amp; Inns Ltd.</TD><TD>10</TD><TD>2738.4</TD><TD>NON_ESG</TD></TR><TR><TD>Gayatri Bioorganics Ltd.</TD><TD>10</TD><TD>507.4</TD><TD>NON_ESG</TD></TR><TR><TD>Gayatri Sugars Ltd.</TD><TD>10</TD><TD>81.29</TD><TD>NON_ESG</TD></TR><TR><TD>Gillanders Arbuthnot &amp; Co. Ltd.</TD><TD>10</TD><TD>903.31</TD><TD>NON_ESG</TD></TR><TR><TD>Godrej Agrovet Ltd.</TD><TD>10</TD><TD>100669.68</TD><TD>NON_ESG</TD></TR><TR><TD>Gokul Agro Resources Ltd.</TD><TD>10</TD><TD>2667.58</TD><TD>NON_ESG</TD></TR><TR><TD>Goodricke Group Ltd.</TD><TD>10</TD><TD>4511.16</TD><TD>NON_ESG</TD></TR><TR><TD>Grob Tea Co. Ltd.</TD><TD>10</TD><TD>933.76</TD><TD>NON_ESG</TD></TR><TR><TD>Gujarat Ambuja Exports Ltd.</TD><TD>10</TD><TD>29337.72</TD><TD>NON_ESG</TD></TR><TR><TD>Hindustan Foods Ltd.</TD><TD>10</TD><TD>44594.4</TD><TD>NON_ESG</TD></TR><TR><TD>Indian Sucrose Ltd.</TD><TD>10</TD><TD>350.21</TD><TD>NON_ESG</TD></TR><TR><TD>James Warren Tea Ltd.</TD><TD>10</TD><TD>671.07</TD><TD>NON_ESG</TD></TR><TR><TD>Jay Shree Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>1912.41</TD><TD>NON_ESG</TD></TR><TR><TD>Jayant Agro-Organics Ltd.</TD><TD>10</TD><TD>4084.5</TD><TD>NON_ESG</TD></TR><TR><TD>Jhandewalas Foods Ltd.</TD><TD>10</TD><TD>89.27</TD><TD>NON_ESG</TD></TR><TR><TD>Joonktollee Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>448.19</TD><TD>NON_ESG</TD></TR><TR><TD>Jubilant Foodworks Ltd.</TD><TD>10</TD><TD>384293.84</TD><TD>ESG</TD></TR><TR><TD>K C P Sugar &amp; Inds. Corpn. Ltd.</TD><TD>10</TD><TD>1669.59</TD><TD>NON_ESG</TD></TR><TR><TD>K M Sugar Mills Ltd.</TD><TD>10</TD><TD>1072.72</TD><TD>NON_ESG</TD></TR><TR><TD>K S E Ltd.</TD><TD>10</TD><TD>7359.84</TD><TD>NON_ESG</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i have to identify the peer group companies in three levels based on their market capitalisation. in level 1, i have identify the Non-ESG companies which are nearest to ESG companies based on their market capitalization i.e, one nearest higher market capitalisation company and one nearest lower market capitalization company.&nbsp;</P><P>in level 2, second nearest companies and level 2 third nearest companies, i have to identify in the same manner.&nbsp;</P><P>My final output format should be like this&nbsp;</P><P>please suggest me the suitable SAS code&nbsp;</P><TABLE><TBODY><TR><TD>ESG_companies&nbsp;</TD><TD>Non_ESG_companies&nbsp;</TD><TD>peer group level</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>Bengal Tea &amp; Fabrics Ltd.</TD><TD>1</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>C C L Products (India) Ltd.</TD><TD>1</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>Bannari Amman Sugars Ltd.</TD><TD>2</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>Chordia Food Products Ltd.</TD><TD>2</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>Bambino Agro Inds. Ltd.</TD><TD>3</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>Coastal Corporation Ltd.</TD><TD>3</TD></TR></TBODY></TABLE><P>thanks in advance&nbsp;</P> Sat, 08 Jan 2022 05:12:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788852#M252342 srikanthyadav44 2022-01-08T05:12:17Z Re: How to identify the Peer group company? https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788861#M252345 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote: <P class="1641563793460">......</P> <P>please suggest me the suitable SAS code&nbsp;</P> <P>&nbsp;</P> <P>thanks in advance&nbsp;</P> <HR /></BLOCKQUOTE> <P>Please post data in usable form!</P> <P>And show the expected result using the posted data, also add an example explaining how (at least) one observation is created in the expected dataset.</P> Fri, 07 Jan 2022 14:02:11 GMT https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788861#M252345 andreas_lds 2022-01-07T14:02:11Z Re: How to identify the Peer group company? https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788862#M252346 <P>Please provide your have/want dataset in SAS code (example below), so we can quickly generate them in SAS. If you already have datasets then you can use the following link to generate code:</P> <P><A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_blank">Data2DataStep Maco instructions</A><BR /><BR /></P> <PRE><CODE class=" language-sas">data have ; infile cards ; input var1 var2 ; cards ; 1 2 3 4 5 6 ; run ;</CODE></PRE> <P>I do not understand your want data example, where are these individual letters ("A", "B", "C", "X", "Y") coming from? They are not in your have data.<BR />If you have already attempted this, then the code you used would also be helpful to determine what you are trying to do.<BR /><BR /></P> Fri, 07 Jan 2022 14:06:00 GMT https://communities.sas.com/t5/SAS-Programming/How-to-identify-the-Peer-group-company/m-p/788862#M252346 AMSAS 2022-01-07T14:06:00Z