Conversely, as long as there are no numbers in County name and you don't have any missing data, here is another way that you could input the data without having to modify it: data two; length County $30; input; County=substr(_infile_,1,anydigit(_infile_)-2); _infile_=substr(_infile_,anydigit(_infile_)); life=scan(_infile_,1," "); People=scan(_infile_,2," "); physician=scan(_infile_,3," "); Female=scan(_infile_,4," "); Male=scan(_infile_,5," "); label life = 'Life expectancy' people = 'People per television' physician = 'People per physician' Female = 'Female life expectancy' Male = 'Male Life expectancy'; datalines; Argentina 70.5 4 370 74 67 Bangladesh 53.5 315 6166 53 54 Brazil 65 4 684 68 62 Canada 76.5 1.7 449 80 73 China 70 8 643 72 68 Colombia 71 5.6 1551 74 68 Egypt 60.5 15 616 61 60 Ethiopia 51.5 503 36660 53 50 France 78 2.6 403 82 74 Germany 76 2.6 346 79 73 India 57.5 44 2471 58 57 Indonesia 61 24 7427 63 59 Iran 64.5 23 2992 65 64 Italy 78.5 3.8 233 82 75 United States 75.5 1.3 404 79 7 ;
... View more