How to transfer dataset into array?

jjjunyi — Sun, 20 Apr 2014 15:14:12 GMT

Hi every one:)

I have a dataset, with variable v1 v2 and Rev, see below:

now I would like to transfer dataset into an array:

How could i accomplish that? should I use array? is there any procedure better than array?

Great Thanks,

Jenny

Re: How to transfer dataset into array?

Tom — Sun, 20 Apr 2014 15:23:11 GMT

Not sure what you mean by an array. You could use PROC TRANSPOSE, but then the numbers that you have in V2 will be turned into variable names.

proc transpose data=have out=want ;

by v1 ;

id v2 ;

var rev ;

run;