DATA Step, Macro, Functions and more

input method

Accepted Solution Solved
Reply
Regular Learner
Posts: 1
Accepted Solution

input method

Mountain Continent Country

Aconcagua South America Argentina
Everest Asia Nepal
Elbrus Europe Russia
Denali North America United States
Kilimanjaro Africa Tanzania
Kosciuszko Australia Australia

kindly provide an input method such that mountain continent and country will be allocated in correct columns

 


Accepted Solutions
Solution
‎03-31-2018 11:20 AM
Contributor
Posts: 62

Re: input method

Posted in reply to achala1369
You will have to base your solution on the fact that there are small number of possible continents. One rudimentary approach is read in entire lines to replace each occurrence of each continent name with a delimited string .
For example replace "North America" with ", North America , "
Then read the resulting strings as a delimited file.

View solution in original post


All Replies
Solution
‎03-31-2018 11:20 AM
Contributor
Posts: 62

Re: input method

Posted in reply to achala1369
You will have to base your solution on the fact that there are small number of possible continents. One rudimentary approach is read in entire lines to replace each occurrence of each continent name with a delimited string .
For example replace "North America" with ", North America , "
Then read the resulting strings as a delimited file.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation