topic Re: how to create datalines? in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789240#M252518 <P>I think&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wants to turn his data into SAS data step code. I provided <A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self">instructions</A> 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 "<SPAN>If you are having trouble getting the data in the requested form, you can ask questions" but there has been no further information provided.</SPAN></P> Mon, 10 Jan 2022 13:08:08 GMT PaigeMiller 2022-01-10T13:08:08Z how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789193#M252497 <P>dear all,</P><P>&nbsp;i have to dataset in excel with four variables.</P><P>1. 'company_name' in text format</P><P>2. 'NIC'&nbsp; in numeric</P><P>3. 'quantile_group' in numeric</P><P>4. 'ESG_company' in text format&nbsp;</P><P>&nbsp;</P><P><STRONG>data in the same order is as follows</STRONG></P><TABLE><TBODY><TR><TD>20 Microns Ltd.</TD><TD>8</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Raghav Productivity Enhancers Ltd.</TD><TD>8</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Ashapura Minechem Ltd.</TD><TD>8</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Shah Foods Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Progrex Ventures Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Madhur Industries Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Ledo Tea Co. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Oswal Overseas Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Riga Sugar Co. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Uniroyal Marine Exports Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Spectrum Foods Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>V S F Projects Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Norben Tea &amp; Exports Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Sampre Nutritions Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Thiru Arooran Sugars Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Gayatri Sugars Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Jhandewalas Foods Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Prima Agro Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Datiware Maritime Infra Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Natraj Proteins Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Sunil Agro Foods Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Valencia Nutrition Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Ravalgaon Sugar Farm Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Narmada Agrobase Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Parvati Sweetners &amp; Power Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Tyroon Tea Co. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Prima Industries Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Saboo Sodium Chloro Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Sir Shadi Lal Enterprises Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Diligent Industries Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Lotus Chocolate Co. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Poona Dal &amp; Oil Inds. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Dharani Sugars &amp; Chemicals Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Kanco Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Tirupati Starch &amp; Chemicals Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Terai Tea Co. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Diana Tea Co. Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Kohinoor Foods Ltd.</TD><TD>10</TD><TD>1</TD><TD>NON_ESG</TD></TR><TR><TD>Kovilpatti Lakshmi Roller Flour Mills Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Shanti Overseas (India) Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Megastar Foods Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Universal Starch-Chem Allied Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>S B E C Sugar Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Simbhaoli Sugars Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Ajooni Biotech Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>M K Proteins Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Ovobel Foods Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Bengal Tea &amp; Fabrics Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Indian Sucrose Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Chordia Food Products Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Kesar Enterprises Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Virat Crane Inds. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Joonktollee Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>B &amp; A Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Rajshree Sugars &amp; Chemicals Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Gayatri Bioorganics Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Kwality Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Warren Tea Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Kings Infra Ventures Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>James Warren Tea Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Peria Karamalai Tea &amp; Produce Co. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Manpasand Beverages Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Sharat Industries Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Kothari Fermentation &amp; Biochem Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Davangere Sugar Co. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Gillanders Arbuthnot &amp; Co. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Modi Naturals Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Grob Tea Co. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Neelamalai Agro Inds. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Sayaji Industries Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Piccadily Agro Inds. Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>K M Sugar Mills Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Ajanta Soya Ltd.</TD><TD>10</TD><TD>2</TD><TD>NON_ESG</TD></TR><TR><TD>Mangalam Global Enterprise Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Anjani Foods Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>S K M Egg Products Export (India) Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Ponni Sugars (Erode) Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Umang Dairies Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Dangee Dums Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Raj Oil Mills Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Bambino Agro Inds. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Mawana Sugars Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Magadh Sugar &amp; Energy Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Rana Sugars Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>United Nilgiri Tea Estates Co. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Milkfood Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>K C P Sugar &amp; Inds. Corpn. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Sheetal Cool Products Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Dhunseri Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Coastal Corporation Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Jay Shree Tea &amp; Inds. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Euro India Fresh Foods Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Ugar Sugar Works Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Kriti Nutrients Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Mcleod Russel India Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Amrit Corp. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Kothari Sugars &amp; Chemicals Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>B C L Industries Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Gokul Agro Resources Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Foods &amp; Inns Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Vijay Solvex Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>D C M Shriram Inds. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Uttam Sugar Mills Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Avadh Sugar &amp; Energy Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Jayant Agro-Organics Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Waterbase Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Vishwaraj Sugar Inds. Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Goodricke Group Ltd.</TD><TD>10</TD><TD>3</TD><TD>NON_ESG</TD></TR><TR><TD>Dwarikesh Sugar Inds. Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Vadilal Industries Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Apex Frozen Foods Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Bajaj Hindusthan Sugar Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>K S E Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Parag Milk Foods Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Manorama Industries Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Andrew Yule &amp; Co. Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Dhampur Sugar Mills Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Prataap Snacks Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Dalmia Bharat Sugar &amp; Inds. Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>A D F Foods Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>D F M Foods Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Shree Renuka Sugars Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Mrs. Bectors Food Specialities Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Bannari Amman Sugars Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Agro Tech Foods Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Triveni Engineering &amp; Inds. Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Venky'S (India) Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Tata Coffee Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Gujarat Ambuja Exports Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>C C L Products (India) Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Tasty Bite Eatables Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Hindustan Foods Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Balrampur Chini Mills Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>E I D-Parry (India) Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Avanti Feeds Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Godrej Agrovet Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Zydus Wellness Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Ruchi Soya Inds. Ltd.</TD><TD>10</TD><TD>4</TD><TD>NON_ESG</TD></TR><TR><TD>Jubilant Foodworks Ltd.</TD><TD>10</TD><TD>4</TD><TD>ESG</TD></TR><TR><TD>Marico Ltd.</TD><TD>10</TD><TD>4</TD><TD>ESG</TD></TR><TR><TD>Tata Consumer Products Ltd.</TD><TD>10</TD><TD>4</TD><TD>ESG</TD></TR><TR><TD>Britannia Industries Ltd.</TD><TD>10</TD><TD>4</TD><TD>ESG</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please help in creating datalines&nbsp;</P><P>&nbsp;</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P> Mon, 10 Jan 2022 07:27:43 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789193#M252497 srikanthyadav44 2022-01-10T07:27:43Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789199#M252502 <P>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)?</P> Mon, 10 Jan 2022 08:30:29 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789199#M252502 Kurt_Bremser 2022-01-10T08:30:29Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789203#M252505 <P>You can use this macro to generate datalines:&nbsp;&nbsp;<A href="https://core.sasjs.io/mp__ds2cards_8sas.html" target="_blank" rel="noopener">https://core.sasjs.io/mp__ds2cards_8sas.html</A></P> Mon, 10 Jan 2022 09:02:40 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789203#M252505 AllanBowe 2022-01-10T09:02:40Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789235#M252514 it is not working Mon, 10 Jan 2022 12:30:29 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789235#M252514 srikanthyadav44 2022-01-10T12:30:29Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789236#M252515 <P>Can you be a bit more specific?</P> Mon, 10 Jan 2022 12:37:46 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789236#M252515 AllanBowe 2022-01-10T12:37:46Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789239#M252517 i have to create SAS internal data file for my data which is in excel.<BR />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.<BR /> Mon, 10 Jan 2022 12:52:56 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789239#M252517 srikanthyadav44 2022-01-10T12:52:56Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789240#M252518 <P>I think&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wants to turn his data into SAS data step code. I provided <A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self">instructions</A> 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 "<SPAN>If you are having trouble getting the data in the requested form, you can ask questions" but there has been no further information provided.</SPAN></P> Mon, 10 Jan 2022 13:08:08 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789240#M252518 PaigeMiller 2022-01-10T13:08:08Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789249#M252526 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote:<BR />it is not working<HR /></BLOCKQUOTE> <P>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.</P> Mon, 10 Jan 2022 13:26:22 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789249#M252526 Kurt_Bremser 2022-01-10T13:26:22Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789250#M252527 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote:<BR />i have to create SAS internal data file for my data which is in excel.<BR />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.<BR /><HR /></BLOCKQUOTE> <P>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:</P> <PRE><CODE class=" language-sas">data want; infile datalines dlm=';' dsd truncover firstobs=2; input company_name :$30. nic quantile_group esg_company :$20.; datalines4; &lt; text from Excel here &gt; ;;;; /* ends the DATALINES4 block and the data step */</CODE></PRE> <P>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 ....).</P> Mon, 10 Jan 2022 13:39:54 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789250#M252527 Kurt_Bremser 2022-01-10T13:39:54Z Re: how to create datalines? https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789286#M252543 <P>The best way to formulate your questions is&nbsp;</P> <UL> <LI>This is what I have (example of your input/starting data)</LI> <LI>Here is what&nbsp; I need/want (example of what you want as output)</LI> <LI>Here is what I tried and how it didn't work (code/log including errors and an explanation of how it didn't work)</LI> </UL> <P>&nbsp;</P> <PRE><CODE class=" language-sas">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 &amp; 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 &amp; 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 &amp; Oil Inds. Ltd. 10 1 NON_ESG Dharani Sugars &amp; Chemicals Ltd. 10 1 NON_ESG Kanco Tea &amp; Inds. Ltd. 10 1 NON_ESG Tirupati Starch &amp; 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 &amp; 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 &amp; Inds. Ltd. 10 2 NON_ESG B &amp; A Ltd. 10 2 NON_ESG Rajshree Sugars &amp; 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 &amp; Produce Co. Ltd. 10 2 NON_ESG Manpasand Beverages Ltd. 10 2 NON_ESG Sharat Industries Ltd. 10 2 NON_ESG Kothari Fermentation &amp; Biochem Ltd. 10 2 NON_ESG Davangere Sugar Co. Ltd. 10 2 NON_ESG Gillanders Arbuthnot &amp; 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 &amp; 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 &amp; Inds. Corpn. Ltd. 10 3 NON_ESG Sheetal Cool Products Ltd. 10 3 NON_ESG Dhunseri Tea &amp; Inds. Ltd. 10 3 NON_ESG Coastal Corporation Ltd. 10 3 NON_ESG Jay Shree Tea &amp; 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 &amp; Chemicals Ltd. 10 3 NON_ESG B C L Industries Ltd. 10 3 NON_ESG Gokul Agro Resources Ltd. 10 3 NON_ESG Foods &amp; 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 &amp; 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 &amp; Co. Ltd. 10 4 NON_ESG Dhampur Sugar Mills Ltd. 10 4 NON_ESG Prataap Snacks Ltd. 10 4 NON_ESG Dalmia Bharat Sugar &amp; 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 &amp; 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; </CODE></PRE> <LI-SPOILER> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote:<BR /> <P>dear all,</P> <P>&nbsp;i have to dataset in excel with four variables.</P> <P>1. 'company_name' in text format</P> <P>2. 'NIC'&nbsp; in numeric</P> <P>3. 'quantile_group' in numeric</P> <P>4. 'ESG_company' in text format&nbsp;</P> <P>&nbsp;</P> <P><STRONG>data in the same order is as follows</STRONG></P> <TABLE> <TBODY> <TR> <TD>20 Microns Ltd.</TD> <TD>8</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Raghav Productivity Enhancers Ltd.</TD> <TD>8</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ashapura Minechem Ltd.</TD> <TD>8</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Shah Foods Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Progrex Ventures Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Madhur Industries Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ledo Tea Co. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Oswal Overseas Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Riga Sugar Co. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Uniroyal Marine Exports Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Spectrum Foods Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>V S F Projects Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Norben Tea &amp; Exports Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Sampre Nutritions Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Thiru Arooran Sugars Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Gayatri Sugars Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Jhandewalas Foods Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Prima Agro Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Datiware Maritime Infra Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Natraj Proteins Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Sunil Agro Foods Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Valencia Nutrition Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ravalgaon Sugar Farm Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Narmada Agrobase Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Parvati Sweetners &amp; Power Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Tyroon Tea Co. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Prima Industries Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Saboo Sodium Chloro Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Sir Shadi Lal Enterprises Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Diligent Industries Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Lotus Chocolate Co. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Poona Dal &amp; Oil Inds. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Dharani Sugars &amp; Chemicals Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kanco Tea &amp; Inds. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Tirupati Starch &amp; Chemicals Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Terai Tea Co. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Diana Tea Co. Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kohinoor Foods Ltd.</TD> <TD>10</TD> <TD>1</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kovilpatti Lakshmi Roller Flour Mills Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Shanti Overseas (India) Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Megastar Foods Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Universal Starch-Chem Allied Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>S B E C Sugar Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Simbhaoli Sugars Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ajooni Biotech Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>M K Proteins Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ovobel Foods Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Bengal Tea &amp; Fabrics Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Indian Sucrose Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Chordia Food Products Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kesar Enterprises Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Virat Crane Inds. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Joonktollee Tea &amp; Inds. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>B &amp; A Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Rajshree Sugars &amp; Chemicals Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Gayatri Bioorganics Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kwality Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Warren Tea Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kings Infra Ventures Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>James Warren Tea Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Peria Karamalai Tea &amp; Produce Co. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Manpasand Beverages Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Sharat Industries Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kothari Fermentation &amp; Biochem Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Davangere Sugar Co. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Gillanders Arbuthnot &amp; Co. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Modi Naturals Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Grob Tea Co. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Neelamalai Agro Inds. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Sayaji Industries Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Piccadily Agro Inds. Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>K M Sugar Mills Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ajanta Soya Ltd.</TD> <TD>10</TD> <TD>2</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Mangalam Global Enterprise Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Anjani Foods Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>S K M Egg Products Export (India) Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ponni Sugars (Erode) Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Umang Dairies Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Dangee Dums Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Raj Oil Mills Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Bambino Agro Inds. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Mawana Sugars Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Magadh Sugar &amp; Energy Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Rana Sugars Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>United Nilgiri Tea Estates Co. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Milkfood Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>K C P Sugar &amp; Inds. Corpn. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Sheetal Cool Products Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Dhunseri Tea &amp; Inds. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Coastal Corporation Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Jay Shree Tea &amp; Inds. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Euro India Fresh Foods Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ugar Sugar Works Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kriti Nutrients Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Mcleod Russel India Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Amrit Corp. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Kothari Sugars &amp; Chemicals Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>B C L Industries Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Gokul Agro Resources Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Foods &amp; Inns Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Vijay Solvex Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>D C M Shriram Inds. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Uttam Sugar Mills Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Avadh Sugar &amp; Energy Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Jayant Agro-Organics Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Waterbase Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Vishwaraj Sugar Inds. Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Goodricke Group Ltd.</TD> <TD>10</TD> <TD>3</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Dwarikesh Sugar Inds. Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Vadilal Industries Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Apex Frozen Foods Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Bajaj Hindusthan Sugar Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>K S E Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Parag Milk Foods Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Manorama Industries Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Andrew Yule &amp; Co. Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Dhampur Sugar Mills Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Prataap Snacks Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Dalmia Bharat Sugar &amp; Inds. Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>A D F Foods Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>D F M Foods Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Shree Renuka Sugars Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Mrs. Bectors Food Specialities Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Bannari Amman Sugars Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Agro Tech Foods Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Triveni Engineering &amp; Inds. Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Venky'S (India) Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Tata Coffee Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Gujarat Ambuja Exports Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>C C L Products (India) Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Tasty Bite Eatables Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Hindustan Foods Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Balrampur Chini Mills Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>E I D-Parry (India) Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Avanti Feeds Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Godrej Agrovet Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Zydus Wellness Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Ruchi Soya Inds. Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>NON_ESG</TD> </TR> <TR> <TD>Jubilant Foodworks Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>ESG</TD> </TR> <TR> <TD>Marico Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>ESG</TD> </TR> <TR> <TD>Tata Consumer Products Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>ESG</TD> </TR> <TR> <TD>Britannia Industries Ltd.</TD> <TD>10</TD> <TD>4</TD> <TD>ESG</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>please help in creating datalines&nbsp;</P> <P>&nbsp;</P> <P>thanks in advance&nbsp;</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> </LI-SPOILER> <P>&nbsp;</P> Mon, 10 Jan 2022 16:12:47 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-datalines/m-p/789286#M252543 Reeza 2022-01-10T16:12:47Z