topic Re: Trim the line until the symbol in SAS Programming

Trim the line until the symbol

Liliya95 — Tue, 28 Nov 2017 07:10:37 GMT

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"

Re: Trim the line until the symbol

ShiroAmada — Tue, 28 Nov 2017 08:01:33 GMT

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;

Re: Trim the line until the symbol

RW9 — Tue, 28 Nov 2017 09:03:20 GMT

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.