topic Re: different variables for the if statement same then. in SAS Programming

different variables for the if statement same then.

sasiscool — Wed, 27 Apr 2016 16:26:38 GMT

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!

Re: different variables for the if statement same then.

FreelanceReinh — Wed, 27 Apr 2016 16:47:52 GMT

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;

Re: different variables for the if statement same then.

sasiscool — Wed, 27 Apr 2016 20:46:17 GMT

great thank you.

Re: different variables for the if statement same then.

ballardw — Thu, 28 Apr 2016 17:44:58 GMT

Please mark the appropriate solution as accepted.