DATA Step, Macro, Functions and more

How to read variable value?

Accepted Solution Solved
Reply
Contributor
Posts: 56
Accepted Solution

How to read variable value?

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


Accepted Solutions
Solution
‎04-13-2017 05:40 PM
Super User
Super User
Posts: 6,502

Re: How to read variable value?

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;

View solution in original post


All Replies
Solution
‎04-13-2017 05:40 PM
Super User
Super User
Posts: 6,502

Re: How to read variable value?

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;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 169 views
  • 2 likes
  • 2 in conversation