topic Re: replace values with zeros in New SAS User

replace values with zeros

dapenDaniel — Thu, 27 Feb 2020 06:02:39 GMT

Hi,

I have a dataset with 288 variables whose name is col2 to col289. I want to replace all values with zeros and the code I used is as below.

data want;
  set have;
  array n{*} Col2-Col289;
  do i=1 to dim(n);        
    if n{i}=1 then n{i}=0;
  end;
run;

After I used this program, all values are replaced with zeros but there is one more variable called i. All the values in this column are 288. Can anyone tell me why this variable exists and how can I avoid it? Thanks.

Re: replace values with zeros

PeterClemmensen — Thu, 27 Feb 2020 06:24:06 GMT

Your code is fine. i is your index variable in the do loop. You can safely drop it like this

data want(drop=i);
  set have;
  array n{*} Col2-Col289;
  do i=1 to dim(n);        
    if n{i}=1 then n{i}=0;
  end;
run;

Re: replace values with zeros

dapenDaniel — Thu, 27 Feb 2020 06:28:00 GMT

Thanks @PeterClemmensen

Re: replace values with zeros

PeterClemmensen — Thu, 27 Feb 2020 06:29:42 GMT

Anytime 🙂