topic Re: Replace values in array in SAS Programming

Replace values in array

fayyazcivil — Mon, 07 Jul 2014 13:53:21 GMT

Hello.

I've a column vector array 61312*1. Values ranges from 0 to 20. I need to replace the values (0 to 20) with the below mentioned values(0 to 7):

0=0, 1=1, 2,3=2, 4=3, 5,6,13=4, 7,8,9=5, 10,11,12,16=6, 14,15,17,18,19,20=7

Thanks in advance.

Re: Replace values in array

RW9 — Mon, 07 Jul 2014 14:02:24 GMT

Not sure what the column vector array means, but with normal arrays you could use if statements, select/when statements, in fact any conditional logic in a datastep or sql to change the information e.g.:

if the_array{iterator}=0 then 0;

if the_array{iterator}=1 then 1;

...

if the_array{iterator} in (14,15,16,17,18,19,20) then 7;

Re: Replace values in array

Reeza — Mon, 07 Jul 2014 15:31:58 GMT

Use Proc Format:

Here's a good reference on how to recode something:

http://www2.sas.com/proceedings/sugi30/001-30.pdf

Re: Replace values in array

stat_sas — Mon, 07 Jul 2014 15:34:24 GMT

If just interested in displaying then you can try proc format.

data have;

do vector=1 to 20;

output;

end;

run;

proc format;

value vector

0=0

1=1

2,3=2

4=3

5,6,13=4

7,8,9=5

10,11,12,16=6

14,15,17,18,19,20=7

;

data want;

set have;

format vector vector.;

run;

Re: Replace values in array

Reeza — Mon, 07 Jul 2014 15:39:51 GMT

You say an array of 613121*1, which in my head is 60K rows and 1 column? If so this isn't considered an array in SAS. An array in SAS is in a single row, as such, 1*61K values.

Re: Replace values in array

fayyazcivil — Mon, 07 Jul 2014 15:48:55 GMT

@Reeza, yes it has 60K rows and I column.

I am sorry I didn't know about that. Now I know what is array in SAS.

Re: Replace values in array

Reeza — Mon, 07 Jul 2014 16:00:42 GMT

That's fine, its just that @RW9 code won't work for that, you'll need something closer to stat@sas code.

SAS Learning Module: Creating and recoding variables in SAS

Re: Replace values in array

fayyazcivil — Mon, 07 Jul 2014 16:02:11 GMT

I am reading Proc Format, and let's see how it works.