DATA Step, Macro, Functions and more

susbtr a string of characters

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

susbtr a string of characters

HI,

 

  AS I am confronted with a problem about'substr', now i just want to get the first two characters from the string of characters.

like : apple juice is my favorite food. i need the 'apple juice'.

 

   i have tried to parse the string and get the var1 for 'apple', var2 for 'juice' and coding like this ' m1 = substr(food,1,compress(var1!!var2)), however, the result is all characters in the string which is not i wanted.

 

i am wondering the better solution to it and the reasons why 'compress' not work out.

 

Thank you!


Accepted Solutions
Solution
‎02-05-2017 11:34 PM
Respected Advisor
Posts: 4,641

Re: susbtr a string of characters

length twoWords $16;
twoWords = catx(" ", scan(food, 1), scan(food, 2));
PG

View solution in original post


All Replies
Solution
‎02-05-2017 11:34 PM
Respected Advisor
Posts: 4,641

Re: susbtr a string of characters

length twoWords $16;
twoWords = catx(" ", scan(food, 1), scan(food, 2));
PG
☑ This topic is SOLVED.

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

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