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"
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;
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.