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 |
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;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.