different variables for the if statement same then.

[sasiscool]

I have multiple variables that follow in sequential order ques5-ques20. Each of these varibles have some entries with a "*" that I want to change to a blank.

Rather than write out a ton of if-or-then. (if ques5="*" then ques5=" ")....

How can i achieve this more efficiently with a do loop?

Thank you!

[FreelanceReinh · Accepted solution]

Hi @sasiscool,

Try this:

data want;
set have;
array q ques5-ques20;
do _n_=1 to dim(q);
  if strip(q[_n_])='*' then q[_n_]=' ';
end;
run;

[sasiscool]

great thank you.

[ballardw]

Please mark the appropriate solution as accepted.