cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
srikanthyadav44
Quartz | Level 8 srikanthyadav44
Quartz | Level 8

how to create datalines?

Posted 01-10-2022 02:27 AM (1199 views)

dear all,

 i have to dataset in excel with four variables.

1. 'company_name' in text format

2. 'NIC'  in numeric

3. 'quantile_group' in numeric

4. 'ESG_company' in text format 

 

data in the same order is as follows

20 Microns Ltd.81NON_ESG
Raghav Productivity Enhancers Ltd.82NON_ESG
Ashapura Minechem Ltd.83NON_ESG
Shah Foods Ltd.101NON_ESG
Progrex Ventures Ltd.101NON_ESG
Madhur Industries Ltd.101NON_ESG
Ledo Tea Co. Ltd.101NON_ESG
Oswal Overseas Ltd.101NON_ESG
Riga Sugar Co. Ltd.101NON_ESG
Uniroyal Marine Exports Ltd.101NON_ESG
Spectrum Foods Ltd.101NON_ESG
V S F Projects Ltd.101NON_ESG
Norben Tea & Exports Ltd.101NON_ESG
Sampre Nutritions Ltd.101NON_ESG
Thiru Arooran Sugars Ltd.101NON_ESG
Gayatri Sugars Ltd.101NON_ESG
Jhandewalas Foods Ltd.101NON_ESG
Prima Agro Ltd.101NON_ESG
Datiware Maritime Infra Ltd.101NON_ESG
Natraj Proteins Ltd.101NON_ESG
Sunil Agro Foods Ltd.101NON_ESG
Valencia Nutrition Ltd.101NON_ESG
Ravalgaon Sugar Farm Ltd.101NON_ESG
Narmada Agrobase Ltd.101NON_ESG
Parvati Sweetners & Power Ltd.101NON_ESG
Tyroon Tea Co. Ltd.101NON_ESG
Prima Industries Ltd.101NON_ESG
Saboo Sodium Chloro Ltd.101NON_ESG
Sir Shadi Lal Enterprises Ltd.101NON_ESG
Diligent Industries Ltd.101NON_ESG
Lotus Chocolate Co. Ltd.101NON_ESG
Poona Dal & Oil Inds. Ltd.101NON_ESG
Dharani Sugars & Chemicals Ltd.101NON_ESG
Kanco Tea & Inds. Ltd.101NON_ESG
Tirupati Starch & Chemicals Ltd.101NON_ESG
Terai Tea Co. Ltd.101NON_ESG
Diana Tea Co. Ltd.101NON_ESG
Kohinoor Foods Ltd.101NON_ESG
Kovilpatti Lakshmi Roller Flour Mills Ltd.102NON_ESG
Shanti Overseas (India) Ltd.102NON_ESG
Megastar Foods Ltd.102NON_ESG
Universal Starch-Chem Allied Ltd.102NON_ESG
S B E C Sugar Ltd.102NON_ESG
Simbhaoli Sugars Ltd.102NON_ESG
Ajooni Biotech Ltd.102NON_ESG
M K Proteins Ltd.102NON_ESG
Ovobel Foods Ltd.102NON_ESG
Bengal Tea & Fabrics Ltd.102NON_ESG
Indian Sucrose Ltd.102NON_ESG
Chordia Food Products Ltd.102NON_ESG
Kesar Enterprises Ltd.102NON_ESG
Virat Crane Inds. Ltd.102NON_ESG
Joonktollee Tea & Inds. Ltd.102NON_ESG
B & A Ltd.102NON_ESG
Rajshree Sugars & Chemicals Ltd.102NON_ESG
Gayatri Bioorganics Ltd.102NON_ESG
Kwality Ltd.102NON_ESG
Warren Tea Ltd.102NON_ESG
Kings Infra Ventures Ltd.102NON_ESG
James Warren Tea Ltd.102NON_ESG
Peria Karamalai Tea & Produce Co. Ltd.102NON_ESG
Manpasand Beverages Ltd.102NON_ESG
Sharat Industries Ltd.102NON_ESG
Kothari Fermentation & Biochem Ltd.102NON_ESG
Davangere Sugar Co. Ltd.102NON_ESG
Gillanders Arbuthnot & Co. Ltd.102NON_ESG
Modi Naturals Ltd.102NON_ESG
Grob Tea Co. Ltd.102NON_ESG
Neelamalai Agro Inds. Ltd.102NON_ESG
Sayaji Industries Ltd.102NON_ESG
Piccadily Agro Inds. Ltd.102NON_ESG
K M Sugar Mills Ltd.102NON_ESG
Ajanta Soya Ltd.102NON_ESG
Mangalam Global Enterprise Ltd.103NON_ESG
Anjani Foods Ltd.103NON_ESG
S K M Egg Products Export (India) Ltd.103NON_ESG
Ponni Sugars (Erode) Ltd.103NON_ESG
Umang Dairies Ltd.103NON_ESG
Dangee Dums Ltd.103NON_ESG
Raj Oil Mills Ltd.103NON_ESG
Bambino Agro Inds. Ltd.103NON_ESG
Mawana Sugars Ltd.103NON_ESG
Magadh Sugar & Energy Ltd.103NON_ESG
Rana Sugars Ltd.103NON_ESG
United Nilgiri Tea Estates Co. Ltd.103NON_ESG
Milkfood Ltd.103NON_ESG
K C P Sugar & Inds. Corpn. Ltd.103NON_ESG
Sheetal Cool Products Ltd.103NON_ESG
Dhunseri Tea & Inds. Ltd.103NON_ESG
Coastal Corporation Ltd.103NON_ESG
Jay Shree Tea & Inds. Ltd.103NON_ESG
Euro India Fresh Foods Ltd.103NON_ESG
Ugar Sugar Works Ltd.103NON_ESG
Kriti Nutrients Ltd.103NON_ESG
Mcleod Russel India Ltd.103NON_ESG
Amrit Corp. Ltd.103NON_ESG
Kothari Sugars & Chemicals Ltd.103NON_ESG
B C L Industries Ltd.103NON_ESG
Gokul Agro Resources Ltd.103NON_ESG
Foods & Inns Ltd.103NON_ESG
Vijay Solvex Ltd.103NON_ESG
D C M Shriram Inds. Ltd.103NON_ESG
Uttam Sugar Mills Ltd.103NON_ESG
Avadh Sugar & Energy Ltd.103NON_ESG
Jayant Agro-Organics Ltd.103NON_ESG
Waterbase Ltd.103NON_ESG
Vishwaraj Sugar Inds. Ltd.103NON_ESG
Goodricke Group Ltd.103NON_ESG
Dwarikesh Sugar Inds. Ltd.104NON_ESG
Vadilal Industries Ltd.104NON_ESG
Apex Frozen Foods Ltd.104NON_ESG
Bajaj Hindusthan Sugar Ltd.104NON_ESG
K S E Ltd.104NON_ESG
Parag Milk Foods Ltd.104NON_ESG
Manorama Industries Ltd.104NON_ESG
Andrew Yule & Co. Ltd.104NON_ESG
Dhampur Sugar Mills Ltd.104NON_ESG
Prataap Snacks Ltd.104NON_ESG
Dalmia Bharat Sugar & Inds. Ltd.104NON_ESG
A D F Foods Ltd.104NON_ESG
D F M Foods Ltd.104NON_ESG
Shree Renuka Sugars Ltd.104NON_ESG
Mrs. Bectors Food Specialities Ltd.104NON_ESG
Bannari Amman Sugars Ltd.104NON_ESG
Agro Tech Foods Ltd.104NON_ESG
Triveni Engineering & Inds. Ltd.104NON_ESG
Venky'S (India) Ltd.104NON_ESG
Tata Coffee Ltd.104NON_ESG
Gujarat Ambuja Exports Ltd.104NON_ESG
C C L Products (India) Ltd.104NON_ESG
Tasty Bite Eatables Ltd.104NON_ESG
Hindustan Foods Ltd.104NON_ESG
Balrampur Chini Mills Ltd.104NON_ESG
E I D-Parry (India) Ltd.104NON_ESG
Avanti Feeds Ltd.104NON_ESG
Godrej Agrovet Ltd.104NON_ESG
Zydus Wellness Ltd.104NON_ESG
Ruchi Soya Inds. Ltd.104NON_ESG
Jubilant Foodworks Ltd.104ESG
Marico Ltd.104ESG
Tata Consumer Products Ltd.104ESG
Britannia Industries Ltd.104ESG

 

please help in creating datalines 

 

thanks in advance 

 

0 Likes
Reply
9 REPLIES 9
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: how to create datalines?

Posted 01-10-2022 03:30 AM (1171 views)  |   In reply to srikanthyadav44

What do you mean by "datalines"? Do you want to create code with this data inline as a DATALINES block? Or do you just want code that reads the data consistently after saving to a different format (comma-, semicolon- or tab-separated)?

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
Reply
srikanthyadav44
Quartz | Level 8 srikanthyadav44
Quartz | Level 8

Re: how to create datalines?

Posted 01-10-2022 07:52 AM (1117 views)  |   In reply to Kurt_Bremser
i have to create SAS internal data file for my data which is in excel.
i need it because, in my earlier query on SAS code for a particular data processing, the members who would like to help me, were asking the data in datalines format.
0 Likes
Reply
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: how to create datalines?

Posted 01-10-2022 07:58 AM (1114 views)  |   In reply to srikanthyadav44

I think @srikanthyadav44 wants to turn his data into SAS data step code. I provided instructions in an earlier thread, but other than saying it doesn't work, the OP has not been specific about what doesn't work, and so without more information, we can't help. I even said in his/her earlier thread "If you are having trouble getting the data in the requested form, you can ask questions" but there has been no further information provided.

--
Paige Miller
0 Likes
Reply
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: how to create datalines?

Posted 01-10-2022 08:39 AM (1093 views)  |   In reply to srikanthyadav44
@srikanthyadav44 wrote:
i have to create SAS internal data file for my data which is in excel.
i need it because, in my earlier query on SAS code for a particular data processing, the members who would like to help me, were asking the data in datalines format.

I would simply save the spreadsheet as .csv from Excel, which results in a semicolon-separated text file. Then load the file into the SAS program editor, and add the necessary data step code:

data want;
infile datalines dlm=';' dsd truncover firstobs=2;
input company_name :$30. nic quantile_group esg_company :$20.;
datalines4;
< text from Excel here >
;;;; /* ends the DATALINES4 block and the data step */

You may need to adapt the string lengths, and possibly add informats for the numeric values if those come in a non-standard format (e.g. comma instead of decimal dot, or trailing instead of leading sign, or ....).

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
Reply
AllanBowe
Barite | Level 11 AllanBowe
Barite | Level 11

Re: how to create datalines?

Posted 01-10-2022 04:02 AM (1163 views)  |   In reply to srikanthyadav44

You can use this macro to generate datalines:  https://core.sasjs.io/mp__ds2cards_8sas.html

/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)
Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
0 Likes
Reply
srikanthyadav44
Quartz | Level 8 srikanthyadav44
Quartz | Level 8

Re: how to create datalines?

Posted 01-10-2022 07:30 AM (1127 views)  |   In reply to AllanBowe
it is not working
0 Likes
Reply
AllanBowe
Barite | Level 11 AllanBowe
Barite | Level 11

Re: how to create datalines?

Posted 01-10-2022 07:37 AM (1122 views)  |   In reply to srikanthyadav44

Can you be a bit more specific?

/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)
Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
0 Likes
Reply
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: how to create datalines?

Posted 01-10-2022 08:26 AM (1101 views)  |   In reply to srikanthyadav44
@srikanthyadav44 wrote:
it is not working

This is the dumbest way to describe a problem, as it provides absolutely no information about the issue itself. Please refrain from such extremely useless statements in the future. Instead provide code you ran, the logs you got, and describe in detail where the results don't meet your expectations.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
Reply
Reeza
Super User Reeza
Super User

Re: how to create datalines?

Posted 01-10-2022 11:12 AM (1070 views)  |   In reply to srikanthyadav44

The best way to formulate your questions is 

  • This is what I have (example of your input/starting data)
  • Here is what  I need/want (example of what you want as output)
  • Here is what I tried and how it didn't work (code/log including errors and an explanation of how it didn't work)

 

data have;
infile cards dlm='09'x truncover;
informat company_name $50. NIC quantile_group 8. ESG_Company $10.;
input company_name NIC quantile_group ESG_company;
cards;
20 Microns Ltd.	8	1	NON_ESG
Raghav Productivity Enhancers Ltd.	8	2	NON_ESG
Ashapura Minechem Ltd.	8	3	NON_ESG
Shah Foods Ltd.	10	1	NON_ESG
Progrex Ventures Ltd.	10	1	NON_ESG
Madhur Industries Ltd.	10	1	NON_ESG
Ledo Tea Co. Ltd.	10	1	NON_ESG
Oswal Overseas Ltd.	10	1	NON_ESG
Riga Sugar Co. Ltd.	10	1	NON_ESG
Uniroyal Marine Exports Ltd.	10	1	NON_ESG
Spectrum Foods Ltd.	10	1	NON_ESG
V S F Projects Ltd.	10	1	NON_ESG
Norben Tea & Exports Ltd.	10	1	NON_ESG
Sampre Nutritions Ltd.	10	1	NON_ESG
Thiru Arooran Sugars Ltd.	10	1	NON_ESG
Gayatri Sugars Ltd.	10	1	NON_ESG
Jhandewalas Foods Ltd.	10	1	NON_ESG
Prima Agro Ltd.	10	1	NON_ESG
Datiware Maritime Infra Ltd.	10	1	NON_ESG
Natraj Proteins Ltd.	10	1	NON_ESG
Sunil Agro Foods Ltd.	10	1	NON_ESG
Valencia Nutrition Ltd.	10	1	NON_ESG
Ravalgaon Sugar Farm Ltd.	10	1	NON_ESG
Narmada Agrobase Ltd.	10	1	NON_ESG
Parvati Sweetners & Power Ltd.	10	1	NON_ESG
Tyroon Tea Co. Ltd.	10	1	NON_ESG
Prima Industries Ltd.	10	1	NON_ESG
Saboo Sodium Chloro Ltd.	10	1	NON_ESG
Sir Shadi Lal Enterprises Ltd.	10	1	NON_ESG
Diligent Industries Ltd.	10	1	NON_ESG
Lotus Chocolate Co. Ltd.	10	1	NON_ESG
Poona Dal & Oil Inds. Ltd.	10	1	NON_ESG
Dharani Sugars & Chemicals Ltd.	10	1	NON_ESG
Kanco Tea & Inds. Ltd.	10	1	NON_ESG
Tirupati Starch & Chemicals Ltd.	10	1	NON_ESG
Terai Tea Co. Ltd.	10	1	NON_ESG
Diana Tea Co. Ltd.	10	1	NON_ESG
Kohinoor Foods Ltd.	10	1	NON_ESG
Kovilpatti Lakshmi Roller Flour Mills Ltd.	10	2	NON_ESG
Shanti Overseas (India) Ltd.	10	2	NON_ESG
Megastar Foods Ltd.	10	2	NON_ESG
Universal Starch-Chem Allied Ltd.	10	2	NON_ESG
S B E C Sugar Ltd.	10	2	NON_ESG
Simbhaoli Sugars Ltd.	10	2	NON_ESG
Ajooni Biotech Ltd.	10	2	NON_ESG
M K Proteins Ltd.	10	2	NON_ESG
Ovobel Foods Ltd.	10	2	NON_ESG
Bengal Tea & Fabrics Ltd.	10	2	NON_ESG
Indian Sucrose Ltd.	10	2	NON_ESG
Chordia Food Products Ltd.	10	2	NON_ESG
Kesar Enterprises Ltd.	10	2	NON_ESG
Virat Crane Inds. Ltd.	10	2	NON_ESG
Joonktollee Tea & Inds. Ltd.	10	2	NON_ESG
B & A Ltd.	10	2	NON_ESG
Rajshree Sugars & Chemicals Ltd.	10	2	NON_ESG
Gayatri Bioorganics Ltd.	10	2	NON_ESG
Kwality Ltd.	10	2	NON_ESG
Warren Tea Ltd.	10	2	NON_ESG
Kings Infra Ventures Ltd.	10	2	NON_ESG
James Warren Tea Ltd.	10	2	NON_ESG
Peria Karamalai Tea & Produce Co. Ltd.	10	2	NON_ESG
Manpasand Beverages Ltd.	10	2	NON_ESG
Sharat Industries Ltd.	10	2	NON_ESG
Kothari Fermentation & Biochem Ltd.	10	2	NON_ESG
Davangere Sugar Co. Ltd.	10	2	NON_ESG
Gillanders Arbuthnot & Co. Ltd.	10	2	NON_ESG
Modi Naturals Ltd.	10	2	NON_ESG
Grob Tea Co. Ltd.	10	2	NON_ESG
Neelamalai Agro Inds. Ltd.	10	2	NON_ESG
Sayaji Industries Ltd.	10	2	NON_ESG
Piccadily Agro Inds. Ltd.	10	2	NON_ESG
K M Sugar Mills Ltd.	10	2	NON_ESG
Ajanta Soya Ltd.	10	2	NON_ESG
Mangalam Global Enterprise Ltd.	10	3	NON_ESG
Anjani Foods Ltd.	10	3	NON_ESG
S K M Egg Products Export (India) Ltd.	10	3	NON_ESG
Ponni Sugars (Erode) Ltd.	10	3	NON_ESG
Umang Dairies Ltd.	10	3	NON_ESG
Dangee Dums Ltd.	10	3	NON_ESG
Raj Oil Mills Ltd.	10	3	NON_ESG
Bambino Agro Inds. Ltd.	10	3	NON_ESG
Mawana Sugars Ltd.	10	3	NON_ESG
Magadh Sugar & Energy Ltd.	10	3	NON_ESG
Rana Sugars Ltd.	10	3	NON_ESG
United Nilgiri Tea Estates Co. Ltd.	10	3	NON_ESG
Milkfood Ltd.	10	3	NON_ESG
K C P Sugar & Inds. Corpn. Ltd.	10	3	NON_ESG
Sheetal Cool Products Ltd.	10	3	NON_ESG
Dhunseri Tea & Inds. Ltd.	10	3	NON_ESG
Coastal Corporation Ltd.	10	3	NON_ESG
Jay Shree Tea & Inds. Ltd.	10	3	NON_ESG
Euro India Fresh Foods Ltd.	10	3	NON_ESG
Ugar Sugar Works Ltd.	10	3	NON_ESG
Kriti Nutrients Ltd.	10	3	NON_ESG
Mcleod Russel India Ltd.	10	3	NON_ESG
Amrit Corp. Ltd.	10	3	NON_ESG
Kothari Sugars & Chemicals Ltd.	10	3	NON_ESG
B C L Industries Ltd.	10	3	NON_ESG
Gokul Agro Resources Ltd.	10	3	NON_ESG
Foods & Inns Ltd.	10	3	NON_ESG
Vijay Solvex Ltd.	10	3	NON_ESG
D C M Shriram Inds. Ltd.	10	3	NON_ESG
Uttam Sugar Mills Ltd.	10	3	NON_ESG
Avadh Sugar & Energy Ltd.	10	3	NON_ESG
Jayant Agro-Organics Ltd.	10	3	NON_ESG
Waterbase Ltd.	10	3	NON_ESG
Vishwaraj Sugar Inds. Ltd.	10	3	NON_ESG
Goodricke Group Ltd.	10	3	NON_ESG
Dwarikesh Sugar Inds. Ltd.	10	4	NON_ESG
Vadilal Industries Ltd.	10	4	NON_ESG
Apex Frozen Foods Ltd.	10	4	NON_ESG
Bajaj Hindusthan Sugar Ltd.	10	4	NON_ESG
K S E Ltd.	10	4	NON_ESG
Parag Milk Foods Ltd.	10	4	NON_ESG
Manorama Industries Ltd.	10	4	NON_ESG
Andrew Yule & Co. Ltd.	10	4	NON_ESG
Dhampur Sugar Mills Ltd.	10	4	NON_ESG
Prataap Snacks Ltd.	10	4	NON_ESG
Dalmia Bharat Sugar & Inds. Ltd.	10	4	NON_ESG
A D F Foods Ltd.	10	4	NON_ESG
D F M Foods Ltd.	10	4	NON_ESG
Shree Renuka Sugars Ltd.	10	4	NON_ESG
Mrs. Bectors Food Specialities Ltd.	10	4	NON_ESG
Bannari Amman Sugars Ltd.	10	4	NON_ESG
Agro Tech Foods Ltd.	10	4	NON_ESG
Triveni Engineering & Inds. Ltd.	10	4	NON_ESG
Venky'S (India) Ltd.	10	4	NON_ESG
Tata Coffee Ltd.	10	4	NON_ESG
Gujarat Ambuja Exports Ltd.	10	4	NON_ESG
C C L Products (India) Ltd.	10	4	NON_ESG
Tasty Bite Eatables Ltd.	10	4	NON_ESG
Hindustan Foods Ltd.	10	4	NON_ESG
Balrampur Chini Mills Ltd.	10	4	NON_ESG
E I D-Parry (India) Ltd.	10	4	NON_ESG
Avanti Feeds Ltd.	10	4	NON_ESG
Godrej Agrovet Ltd.	10	4	NON_ESG
Zydus Wellness Ltd.	10	4	NON_ESG
Ruchi Soya Inds. Ltd.	10	4	NON_ESG
Jubilant Foodworks Ltd.	10	4	ESG
Marico Ltd.	10	4	ESG
Tata Consumer Products Ltd.	10	4	ESG
Britannia Industries Ltd.	10	4	ESG
;;;;;
run;
Spoiler
@srikanthyadav44 wrote:

dear all,

 i have to dataset in excel with four variables.

1. 'company_name' in text format

2. 'NIC'  in numeric

3. 'quantile_group' in numeric

4. 'ESG_company' in text format 

 

data in the same order is as follows

20 Microns Ltd. 8 1 NON_ESG
Raghav Productivity Enhancers Ltd. 8 2 NON_ESG
Ashapura Minechem Ltd. 8 3 NON_ESG
Shah Foods Ltd. 10 1 NON_ESG
Progrex Ventures Ltd. 10 1 NON_ESG
Madhur Industries Ltd. 10 1 NON_ESG
Ledo Tea Co. Ltd. 10 1 NON_ESG
Oswal Overseas Ltd. 10 1 NON_ESG
Riga Sugar Co. Ltd. 10 1 NON_ESG
Uniroyal Marine Exports Ltd. 10 1 NON_ESG
Spectrum Foods Ltd. 10 1 NON_ESG
V S F Projects Ltd. 10 1 NON_ESG
Norben Tea & Exports Ltd. 10 1 NON_ESG
Sampre Nutritions Ltd. 10 1 NON_ESG
Thiru Arooran Sugars Ltd. 10 1 NON_ESG
Gayatri Sugars Ltd. 10 1 NON_ESG
Jhandewalas Foods Ltd. 10 1 NON_ESG
Prima Agro Ltd. 10 1 NON_ESG
Datiware Maritime Infra Ltd. 10 1 NON_ESG
Natraj Proteins Ltd. 10 1 NON_ESG
Sunil Agro Foods Ltd. 10 1 NON_ESG
Valencia Nutrition Ltd. 10 1 NON_ESG
Ravalgaon Sugar Farm Ltd. 10 1 NON_ESG
Narmada Agrobase Ltd. 10 1 NON_ESG
Parvati Sweetners & Power Ltd. 10 1 NON_ESG
Tyroon Tea Co. Ltd. 10 1 NON_ESG
Prima Industries Ltd. 10 1 NON_ESG
Saboo Sodium Chloro Ltd. 10 1 NON_ESG
Sir Shadi Lal Enterprises Ltd. 10 1 NON_ESG
Diligent Industries Ltd. 10 1 NON_ESG
Lotus Chocolate Co. Ltd. 10 1 NON_ESG
Poona Dal & Oil Inds. Ltd. 10 1 NON_ESG
Dharani Sugars & Chemicals Ltd. 10 1 NON_ESG
Kanco Tea & Inds. Ltd. 10 1 NON_ESG
Tirupati Starch & Chemicals Ltd. 10 1 NON_ESG
Terai Tea Co. Ltd. 10 1 NON_ESG
Diana Tea Co. Ltd. 10 1 NON_ESG
Kohinoor Foods Ltd. 10 1 NON_ESG
Kovilpatti Lakshmi Roller Flour Mills Ltd. 10 2 NON_ESG
Shanti Overseas (India) Ltd. 10 2 NON_ESG
Megastar Foods Ltd. 10 2 NON_ESG
Universal Starch-Chem Allied Ltd. 10 2 NON_ESG
S B E C Sugar Ltd. 10 2 NON_ESG
Simbhaoli Sugars Ltd. 10 2 NON_ESG
Ajooni Biotech Ltd. 10 2 NON_ESG
M K Proteins Ltd. 10 2 NON_ESG
Ovobel Foods Ltd. 10 2 NON_ESG
Bengal Tea & Fabrics Ltd. 10 2 NON_ESG
Indian Sucrose Ltd. 10 2 NON_ESG
Chordia Food Products Ltd. 10 2 NON_ESG
Kesar Enterprises Ltd. 10 2 NON_ESG
Virat Crane Inds. Ltd. 10 2 NON_ESG
Joonktollee Tea & Inds. Ltd. 10 2 NON_ESG
B & A Ltd. 10 2 NON_ESG
Rajshree Sugars & Chemicals Ltd. 10 2 NON_ESG
Gayatri Bioorganics Ltd. 10 2 NON_ESG
Kwality Ltd. 10 2 NON_ESG
Warren Tea Ltd. 10 2 NON_ESG
Kings Infra Ventures Ltd. 10 2 NON_ESG
James Warren Tea Ltd. 10 2 NON_ESG
Peria Karamalai Tea & Produce Co. Ltd. 10 2 NON_ESG
Manpasand Beverages Ltd. 10 2 NON_ESG
Sharat Industries Ltd. 10 2 NON_ESG
Kothari Fermentation & Biochem Ltd. 10 2 NON_ESG
Davangere Sugar Co. Ltd. 10 2 NON_ESG
Gillanders Arbuthnot & Co. Ltd. 10 2 NON_ESG
Modi Naturals Ltd. 10 2 NON_ESG
Grob Tea Co. Ltd. 10 2 NON_ESG
Neelamalai Agro Inds. Ltd. 10 2 NON_ESG
Sayaji Industries Ltd. 10 2 NON_ESG
Piccadily Agro Inds. Ltd. 10 2 NON_ESG
K M Sugar Mills Ltd. 10 2 NON_ESG
Ajanta Soya Ltd. 10 2 NON_ESG
Mangalam Global Enterprise Ltd. 10 3 NON_ESG
Anjani Foods Ltd. 10 3 NON_ESG
S K M Egg Products Export (India) Ltd. 10 3 NON_ESG
Ponni Sugars (Erode) Ltd. 10 3 NON_ESG
Umang Dairies Ltd. 10 3 NON_ESG
Dangee Dums Ltd. 10 3 NON_ESG
Raj Oil Mills Ltd. 10 3 NON_ESG
Bambino Agro Inds. Ltd. 10 3 NON_ESG
Mawana Sugars Ltd. 10 3 NON_ESG
Magadh Sugar & Energy Ltd. 10 3 NON_ESG
Rana Sugars Ltd. 10 3 NON_ESG
United Nilgiri Tea Estates Co. Ltd. 10 3 NON_ESG
Milkfood Ltd. 10 3 NON_ESG
K C P Sugar & Inds. Corpn. Ltd. 10 3 NON_ESG
Sheetal Cool Products Ltd. 10 3 NON_ESG
Dhunseri Tea & Inds. Ltd. 10 3 NON_ESG
Coastal Corporation Ltd. 10 3 NON_ESG
Jay Shree Tea & Inds. Ltd. 10 3 NON_ESG
Euro India Fresh Foods Ltd. 10 3 NON_ESG
Ugar Sugar Works Ltd. 10 3 NON_ESG
Kriti Nutrients Ltd. 10 3 NON_ESG
Mcleod Russel India Ltd. 10 3 NON_ESG
Amrit Corp. Ltd. 10 3 NON_ESG
Kothari Sugars & Chemicals Ltd. 10 3 NON_ESG
B C L Industries Ltd. 10 3 NON_ESG
Gokul Agro Resources Ltd. 10 3 NON_ESG
Foods & Inns Ltd. 10 3 NON_ESG
Vijay Solvex Ltd. 10 3 NON_ESG
D C M Shriram Inds. Ltd. 10 3 NON_ESG
Uttam Sugar Mills Ltd. 10 3 NON_ESG
Avadh Sugar & Energy Ltd. 10 3 NON_ESG
Jayant Agro-Organics Ltd. 10 3 NON_ESG
Waterbase Ltd. 10 3 NON_ESG
Vishwaraj Sugar Inds. Ltd. 10 3 NON_ESG
Goodricke Group Ltd. 10 3 NON_ESG
Dwarikesh Sugar Inds. Ltd. 10 4 NON_ESG
Vadilal Industries Ltd. 10 4 NON_ESG
Apex Frozen Foods Ltd. 10 4 NON_ESG
Bajaj Hindusthan Sugar Ltd. 10 4 NON_ESG
K S E Ltd. 10 4 NON_ESG
Parag Milk Foods Ltd. 10 4 NON_ESG
Manorama Industries Ltd. 10 4 NON_ESG
Andrew Yule & Co. Ltd. 10 4 NON_ESG
Dhampur Sugar Mills Ltd. 10 4 NON_ESG
Prataap Snacks Ltd. 10 4 NON_ESG
Dalmia Bharat Sugar & Inds. Ltd. 10 4 NON_ESG
A D F Foods Ltd. 10 4 NON_ESG
D F M Foods Ltd. 10 4 NON_ESG
Shree Renuka Sugars Ltd. 10 4 NON_ESG
Mrs. Bectors Food Specialities Ltd. 10 4 NON_ESG
Bannari Amman Sugars Ltd. 10 4 NON_ESG
Agro Tech Foods Ltd. 10 4 NON_ESG
Triveni Engineering & Inds. Ltd. 10 4 NON_ESG
Venky'S (India) Ltd. 10 4 NON_ESG
Tata Coffee Ltd. 10 4 NON_ESG
Gujarat Ambuja Exports Ltd. 10 4 NON_ESG
C C L Products (India) Ltd. 10 4 NON_ESG
Tasty Bite Eatables Ltd. 10 4 NON_ESG
Hindustan Foods Ltd. 10 4 NON_ESG
Balrampur Chini Mills Ltd. 10 4 NON_ESG
E I D-Parry (India) Ltd. 10 4 NON_ESG
Avanti Feeds Ltd. 10 4 NON_ESG
Godrej Agrovet Ltd. 10 4 NON_ESG
Zydus Wellness Ltd. 10 4 NON_ESG
Ruchi Soya Inds. Ltd. 10 4 NON_ESG
Jubilant Foodworks Ltd. 10 4 ESG
Marico Ltd. 10 4 ESG
Tata Consumer Products Ltd. 10 4 ESG
Britannia Industries Ltd. 10 4 ESG

 

please help in creating datalines 

 

thanks in advance 

 

 

Reply

SAS Innovate 2025: Register Today!

 

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 9 replies
  • ‎01-10-2022 02:27 AM
  • 1200 views
  • 2 likes
  • 5 in conversation