https://communities.sas.com/t5/SAS-Programming/input-method/m-p/450127#M113334 You will have to base your solution on the fact that there are small number of possible continents.&nbsp;One rudimentary approach is read in entire lines to replace each occurrence of each continent name with a delimited string .<BR />For example replace "North America" with ", North America , "<BR />Then read the resulting strings as a delimited file.<BR /> Sat, 31 Mar 2018 13:11:15 GMT JohnHoughton 2018-03-31T13:11:15Z https://communities.sas.com/t5/SAS-Programming/input-method/m-p/450125#M113332 <P>Mountain Continent Country</P><PRE>Aconcagua South America Argentina<BR />Everest Asia Nepal<BR />Elbrus Europe Russia<BR />Denali North America United States<BR />Kilimanjaro Africa Tanzania<BR />Kosciuszko Australia Australia</PRE><P>kindly provide an input method such that mountain continent and country will be allocated in correct columns</P><P>&nbsp;</P> Sat, 31 Mar 2018 12:44:38 GMT https://communities.sas.com/t5/SAS-Programming/input-method/m-p/450125#M113332 achala1369 2018-03-31T12:44:38Z https://communities.sas.com/t5/SAS-Programming/input-method/m-p/450127#M113334 You will have to base your solution on the fact that there are small number of possible continents.&nbsp;One rudimentary approach is read in entire lines to replace each occurrence of each continent name with a delimited string .<BR />For example replace "North America" with ", North America , "<BR />Then read the resulting strings as a delimited file.<BR /> Sat, 31 Mar 2018 13:11:15 GMT https://communities.sas.com/t5/SAS-Programming/input-method/m-p/450127#M113334 JohnHoughton 2018-03-31T13:11:15Z