Repating a vector in a vector form

goliPSU — Mon, 16 Jul 2012 18:13:08 GMT

Hi,

If I have a vector

v = [i

I want to repeat a vector in a vector format couple of times:

v=[i

]

Actually I would like to use this in reshaping a matrix to a vector. but I want to add a column by the variable name as the first two columns:

z = [

1 2 3

4 5 6

7 8 9]

rowname = [ a b c]

calname = [i j k]

I am using Z = shape(Z, ncol*nrow, 1);

I want to create a table looks like:

a i 1

a j 2

a k 3

b i 4

b j 5

b k 6

c i 7

c j 8

c k 9

Thank you

Re: Repating a vector in a vector form

Rick_SAS — Mon, 16 Jul 2012 18:41:35 GMT

You want to use the REPEAT function, as discussed in the Getting Started chapter of my book.

For the first two columns, you should read about the very useful Define2DGrid function, which wraps up some of the REPEAT and SHAPE functionality: http://blogs.sas.com/content/iml/2011/01/21/how-to-create-a-grid-of-values/

You can use that function to generate the indices for the first two columns:

ij = Define2DGrid(1, 3, 3, 1, 3, 3);

i = ij[,1]; j = ij[,2];

rname={a b c};

cname = {i j k};

c1 = rname;

c2 = cname;