topic Re: Multidimension array in a a macro in SAS Data Management

Multidimension array in a a macro

Kc2 — Tue, 10 Nov 2015 15:36:56 GMT

Hello

I have two datasets, with 4 rows and 3 columns. and I need to divide the values of one by the other.

dataset 1

Col1 Col2 Col3

Type1 T1C1 T1C2 T1C3

Type2 T2C1 T2C2 T2C3

Type3 T3C1 T3C2 T3C3

Type4 T4C1 T4C2 T4C3

dataset 2

Col1 Col2 Col3

Samp1 S1C1 S1C2 S1C3

Samp2 S2C1 S2C2 S2C3

Samp3 S3C1 S3C2 S3C3

Samp4 S4C1 S4C2 S4C3

How can I divide the values in dataset 1 by the values in dataset2:

desired result:

dataset 3:

Col1 Col2 Col3

Resl1 T1C1/S1C1 T1C2/S1C2 T1C3/S1C3

Resl2 T2C1/S2C1 T2C2/S2C2 T2C3/S2C3

Resl3 T3C1/S3C1 T2C2/S3C2 T2C3/S3C3

Resl4 T4C1/S4C1 T4C2/S4C2 T4C3/S4C3

I ws thinking of using a loop:

data result;
set dataset1 dataset2;

array type{4,3} t1c1-t1c3 t2c1-t2c3 t3c1-t3c3 t4c1-t4c3;

array sample{4,3} s1c1-s1c3 s2c1-s2c3 s3c1-s3c3 s4c1-s4c3;

       %do i = 1 %to dim1(type);
           %do j = 1 %to dim2(type);
           result{i,j}=type{i,j}/sample{i,j};
           %end;
       %end;

thanks

Re: Multidimension array in a a macro

Reeza — Tue, 10 Nov 2015 16:09:17 GMT

Are you using IML? If not, then you don't need to a multidimensional array or a macro.

MERGE the do data sets (side by side) declare two arrays and loop through.

Data want;
merge data1 data2;
array d1(3) d1_col1-d1_col3; *column names from first data set;
array d2(3) d2_col1-d2_col3;*column names from second data set;

array d3(3) d3_col1-d3_col3;

do i=1 to 3;
d3(i)=d1(i)/d2(i);
end;

run;

Re: Multidimension array in a a macro

slchen — Tue, 10 Nov 2015 16:12:37 GMT

data want;
merge dateset1 dataset2(rename=(col1=_col1 col2=_col2 col3=_col3));
array var1 col:;
array var2 _col:;
do over var1;
var1=catx('/',var1,var2);
end;
drop _:;
run;

Re: Multidimension array in a a macro

Kc2 — Tue, 10 Nov 2015 16:33:08 GMT

No I am not using IML

Re: Multidimension array in a a macro

Reeza — Tue, 10 Nov 2015 16:37:04 GMT

Then you should review how SAS processes data.
For starters, SAS automatically loops through each row. An array is used as a shortcut reference to variable names. So you don't need to set up a matrix and treat the data as multidimensional array because SAS will process it the way you want automatically. You have some code suggestions, but some other key concepts are that you can't have columns with the same name, so you need to rename one set of columns from a data set.

Re: Multidimension array in a a macro

Kc2 — Tue, 10 Nov 2015 16:58:45 GMT

Yes I did rename the colums in one of the dataset. Thank you for your help. It worked.