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
@srikanthyadav44 wrote:......
please suggest me the suitable SAS code
thanks in advance
Please post data in usable form!
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.
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:
Data2DataStep Maco instructions
data have ;
infile cards ;
input var1 var2 ;
cards ;
1 2
3 4
5 6
;
run ;
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.
If you have already attempted this, then the code you used would also be helpful to determine what you are trying to do.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.