topic Re: Repeat by variable in SAS/IML Software and Matrix Computations

Repeat by variable

KPatra — Tue, 17 Mar 2015 14:08:36 GMT

I have two matrices H and K

H = 1 2 3

K = 10 20

I woulde like to repeat K for each value of H - any suggestions? The expected result will look like

1 10

1 20

2 10

2 20

3 10

3 20

Rick_SAS — Tue, 17 Mar 2015 14:17:10 GMT

KPatra — Tue, 17 Mar 2015 14:30:37 GMT

Thanks Rick, I have IML 12.1 and it does not have that function.

Rick_SAS — Tue, 17 Mar 2015 14:51:24 GMT

For a 2D grid, use this module, which is adapted from the article "How to create a grid of values"

start ExpandGrid(_x1, _x2);

x1 = colvec(_x1); Nx = nrow(x1);

x2 = rowvec(_x2); Ny = ncol(x2);

X = repeat(x1, 1, Ny);

Y = repeat(x2, Nx);

return ( colvec(X) || colvec(Y) );

finish;

KPatra — Tue, 17 Mar 2015 15:26:41 GMT

Works like a charm, thanks Rick.