DATA Step, Macro, Functions and more

Trim the line until the symbol

Reply
Occasional Contributor
Posts: 11

Trim the line until the symbol

[ Edited ]

How I can trim the line until the symbol in the loop?

for example, " abc, defg, hj, kli "

I need to get "abc"  "defg" "hj" "kli"

Frequent Contributor
Posts: 116

Re: Trim the line until the symbol

[ Edited ]

 

Use the following functions - COUNTC, SUM, SCAN

data sample;
 a="'abc','def','xyz'";
 count_commas=countc(a);
if count_commas>1 then do;
 count_commas=count_commas+1;
  do i=1 to count_commas;
  var=scan(a,",",i);
  output;
end;
end;
if count_commas=0 or count_commas=. then var=a; run;
Super User
Super User
Posts: 9,599

Re: Trim the line until the symbol

What do you mean by "I need to get..."?  This is where posting test data as a datastep and what you want out is so important.  We are now all guessing what you want to do!  From what you post, it seems that you want to replace , with " ", which would be:

want=tranwrd(have,',','" "');

Posting clear concise questions will get you clear concise answers.

Ask a Question
Discussion stats
  • 2 replies
  • 117 views
  • 1 like
  • 3 in conversation