topic Re: how to remove percentage from certain rows in SAS Programming

how to remove percentage from certain rows

stataq — Mon, 22 Apr 2024 02:47:54 GMT

Hello,

I have a data/table like below:

If I would like to remove (XX) when rowlbl='All' for col1:col3, how can I do it using do loop?

I can do it one by one, but when I try to use do loop, I failed. Could anyone guide me on this?

*do it one by one;
data _ds;
set ds;
if rowlbl='All' then do;
col1=scan(col1, 1, ' (');
end;
run;

*try to use do loop;
data _ds;
set ds;
if rowlbl='All' then do;
do i=1 to 3;
coli=scan(coli, 1, ' (');
end;
end;
run;

My way of removing '(XX)' might be too silly. Any better suggestion?

Re: how to remove percentage from certain rows

Tom — Mon, 22 Apr 2024 03:31:31 GMT

What variable is COLI?

Did you mean to create an array? if so you need addition syntax, brackets, to reference a member of the array.

data _ds;
  set ds;
  array columns col: ;
  if rowlbl='All' then do index=1 to dim(columns);
    columns[index]=scan(columns[index], 1, ' (');
  end;
  drop index;
run;

Re: how to remove percentage from certain rows

stataq — Mon, 22 Apr 2024 03:53:14 GMT

😅 COL1 is just col1. I can update cols one by one. I only listed COL1. sorry for that.

I was wondering whether we could use do loop to update the variable values. If so, how?

Re: how to remove percentage from certain rows

Tom — Mon, 22 Apr 2024 04:00:41 GMT

@stataq wrote:

😅 COL1 is just col1. I can update cols one by one. I only listed COL1. sorry for that.

I was wondering whether we could use do loop to update the variable values. If so, how?

?? Read the code I posted.