Hi. i have a raw data file that has names of cities in it, followed by some stats. the names of cities may be one-, two-, or three-word long. the words of the city name are separated by a space. the city name and other stats are separated by a double space. so it's like this: idaho 123 345 789 los angeles 234 567 890 papua new guniea 765 432 109 something like that i thought i'd found the way around when i wrote a code like this (with dlm set to DOUBLE SPACE): data stats2; infile "/folders/myfolders/datasets/sample1.dat" dlm=" " dsd missover; input city_name :$30. stat1 stat2 stat3; run; it won't work. how can i go about it?
... View more