dear all 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 company_name nic mcap ESG_company A D F Foods Ltd. 10 17874.78 NON_ESG Agro Tech Foods Ltd. 10 20365.39 NON_ESG Ajanta Soya Ltd. 10 1142.86 NON_ESG Ajooni Biotech Ltd. 10 304.17 NON_ESG Amrit Corp. Ltd. 10 2096.38 NON_ESG Andrew Yule & Co. Ltd. 10 9656.78 NON_ESG Anjani Foods Ltd. 10 1226.96 NON_ESG Apex Frozen Foods Ltd. 10 6481.25 NON_ESG Avadh Sugar & Energy Ltd. 10 3704.41 NON_ESG Avanti Feeds Ltd. 10 56490.84 NON_ESG B & A Ltd. 10 459.42 NON_ESG B C L Industries Ltd. 10 2580.43 NON_ESG Bajaj Hindusthan Sugar Ltd. 10 7022.4 NON_ESG Balrampur Chini Mills Ltd. 10 45045 NON_ESG Bambino Agro Inds. Ltd. 10 1360.7 NON_ESG Bannari Amman Sugars Ltd. 10 19777.3 NON_ESG Bengal Tea & Fabrics Ltd. 10 348.53 NON_ESG Britannia Industries Ltd. 10 873526.94 ESG C C L Products (India) Ltd. 10 31135.18 NON_ESG Chordia Food Products Ltd. 10 402.83 NON_ESG Coastal Corporation Ltd. 10 1826.07 NON_ESG D C M Shriram Inds. Ltd. 10 3269.17 NON_ESG D F M Foods Ltd. 10 18345.1 NON_ESG Dalmia Bharat Sugar & Inds. Ltd. 10 15105.3 NON_ESG Dangee Dums Ltd. 10 1328.8 NON_ESG Datiware Maritime Infra Ltd. 10 95 NON_ESG Davangere Sugar Co. Ltd. 10 818.56 NON_ESG Dhampur Sugar Mills Ltd. 10 12138.97 NON_ESG Dharani Sugars & Chemicals Ltd. 10 215.14 NON_ESG Dhunseri Tea & Inds. Ltd. 10 1804.3 NON_ESG Diana Tea Co. Ltd. 10 243.6 NON_ESG Diligent Industries Ltd. 10 187.55 NON_ESG Dwarikesh Sugar Inds. Ltd. 10 5799.69 NON_ESG E I D-Parry (India) Ltd. 10 56411.54 NON_ESG Euro India Fresh Foods Ltd. 10 1915.8 NON_ESG Foods & Inns Ltd. 10 2738.4 NON_ESG Gayatri Bioorganics Ltd. 10 507.4 NON_ESG Gayatri Sugars Ltd. 10 81.29 NON_ESG Gillanders Arbuthnot & Co. Ltd. 10 903.31 NON_ESG Godrej Agrovet Ltd. 10 100669.68 NON_ESG Gokul Agro Resources Ltd. 10 2667.58 NON_ESG Goodricke Group Ltd. 10 4511.16 NON_ESG Grob Tea Co. Ltd. 10 933.76 NON_ESG Gujarat Ambuja Exports Ltd. 10 29337.72 NON_ESG Hindustan Foods Ltd. 10 44594.4 NON_ESG Indian Sucrose Ltd. 10 350.21 NON_ESG James Warren Tea Ltd. 10 671.07 NON_ESG Jay Shree Tea & Inds. Ltd. 10 1912.41 NON_ESG Jayant Agro-Organics Ltd. 10 4084.5 NON_ESG Jhandewalas Foods Ltd. 10 89.27 NON_ESG Joonktollee Tea & Inds. Ltd. 10 448.19 NON_ESG Jubilant Foodworks Ltd. 10 384293.84 ESG K C P Sugar & Inds. Corpn. Ltd. 10 1669.59 NON_ESG K M Sugar Mills Ltd. 10 1072.72 NON_ESG K S E Ltd. 10 7359.84 NON_ESG 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. in level 2, second nearest companies and level 2 third nearest companies, i have to identify in the same manner. My final output format should be like this please suggest me the suitable SAS code ESG_companies Non_ESG_companies peer group level Britannia Industries Ltd. Bengal Tea & Fabrics Ltd. 1 Britannia Industries Ltd. C C L Products (India) Ltd. 1 Britannia Industries Ltd. Bannari Amman Sugars Ltd. 2 Britannia Industries Ltd. Chordia Food Products Ltd. 2 Britannia Industries Ltd. Bambino Agro Inds. Ltd. 3 Britannia Industries Ltd. Coastal Corporation Ltd. 3 thanks in advance
... View more
