topic Re: Multiple Array in SAS in SAS Programming

Multiple Array in SAS

fayyazcivil — Thu, 31 Jul 2014 10:06:20 GMT

Hi.

I need to create a multiple array (81,81).

I've 3 columns in my data. 1st and 2nd column values ranges from 1 to 81 (these are codes for Provinces) and the 3rd column shows the distance between these provinces. The data structure is like:

A B C

1 2 200

1 3 500

. . .

1 81 300

2 1 100

2 3 250

. . .

81 80 1000;

I need to create an array/table/matrix which is 81 by 81 and shows the distance (3rd column value) between these provinces (1st and 2nd columns values).

Thanks in advance.

Re: Multiple Array in SAS

RW9 — Thu, 31 Jul 2014 10:15:48 GMT

Hi,

Try transpose:

data have;
infile datalines;
input a b c;
datalines;
1 2 200
1 3 30
1 5 23
2 1 27
2 4 8
2 5 90
;
run;

proc sort data=have;
by a b c;
run;
proc transpose data=have out=want (drop=_name_) prefix=B;
by a;
var c;
id b;
idlabel b;
run;

The above will create Bx variables for each unique occurrence of a value in B.

Re: Multiple Array in SAS

data_null__ — Thu, 31 Jul 2014 12:59:38 GMT

Shouldn't the distance between a=1 and b=2 be the same as a=2 and b=1?

Re: Multiple Array in SAS

fayyazcivil — Thu, 31 Jul 2014 13:01:57 GMT

Hi. Thanks for your reply.

Yes it is, I just mentioned randomly .