How to read variable value?

[lakshmi_74]

I want to read the dataset and assign the value correcsponding variable number. How can i solve it? Thanks.

data have;

 input number v1 v2 v3 v4 v5;

datalines;

    1 23 34 45 56 67

    5 12 33 44 55 66

;

run;

i want the output like: Accoding to number value it should read the corresponding variabe value into Final variable

Number	V1	V2	V3	V4	V5	Final
1	23	34	45	56	67	23
5	12	33	44	55	66	66

[Tom · Accepted solution]

Sounds like a simple use case of indexing into an array.

data want ;
  set have ;
  array x v1-v15 ;
  if 1 <= number <= dim(x) then final=x(number);
run;