How to identify the Peer group company?

[srikanthyadav44]

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 

[andreas_lds]

---

@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.

[AMSAS]

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.