topic How to change a string is a whole dataset in New SAS User

How to change a string is a whole dataset

Duvessa — Tue, 03 Mar 2020 10:21:14 GMT

Hi all

I am trying to change a string throughout a whole dataset. I know i could do case when statements but there are to many variables. I am trying to use an array but i can quite get it to work, code below. Could anyone help please. Thanks

data data2;

set data;

array s _char_;

do _n_=1 to dim(s);

if s(_n_)="Timed" then (s(_n_)="Time");

end;

run;

Edit to add data there are about 50 of the St columns

Num	rate	rate st	rate2	rate2 st
1	0.1	Timed	0.1	Timed
2	0.2	New	0.2	New
3	0.5	Unchanged	0.5	Unchanged
4	0.1	New	0.1	Timed
5	0.1	Unchanged	1	Unchanged
6	0.2	Timed	0.2	Timed
7	0.5	Timed	2	New
8	0.1	Timed	0.1	Unchanged
9	0.5	Timed	0.5	Timed
10	0.1	New	2.5	New
11	0.1	Unchanged	0.1	Unchanged

Re: How to change a string is a whole dataset

ed_sas_member — Tue, 03 Mar 2020 10:14:46 GMT

Hi @Duvessa

Could you please share some sample data?

Thanks a lot,

Best,

Re: How to change a string is a whole dataset

PeterClemmensen — Tue, 03 Mar 2020 10:17:15 GMT

@Duvessa Hi and welcome to the SAS Community 🙂

Simply drop the parentheses..

data have;
input c1 $ n1 c2 $;
datalines;
Timed 1 abc
abc   1 Timed
;

data want;
    set have;
    array s _char_;
    do _n_=1 to dim(s);
    if s(_n_)="Timed" then s(_n_)="Time";
    end;
run;

Re: How to change a string is a whole dataset

Duvessa — Tue, 03 Mar 2020 10:32:07 GMT

perfect thank you

Re: How to change a string is a whole dataset

PeterClemmensen — Tue, 03 Mar 2020 11:38:50 GMT

Anytime 🙂