Hi everyone, I have a dataset where one column is filled with column headers, and I was to return the value from that header back to that row. For example SAS DAta Set: Name Lookup 1 2 3 Return John 2 a d v d Tim 2 a c v c Kat 3 c d v v Jim 1 c c d c So as you can see from above if lookup = 2 then return the value from column 2. Now my dataset is much larger so I cant just use if/then to bring back every combination.. Any ideas? Cheers
... View more