DATA Step, Macro, Functions and more

Value of VAR1 to ID which of VAR2-VARn to use

Reply
N/A
Posts: 0

Value of VAR1 to ID which of VAR2-VARn to use

VAR1 contains the name of a second variable that I would like to choose for further processing. The value of VAR1 could be VAR2, VAR3, VAR4, VARn etc. I would like to create a new variable, NEW1, that would take the value of either VAR2, VAR3, VAR4, VARn etc. depending on the value of VAR1. Also, the # of possibilities, "n", could be different at different points in time and I would like the code to check for that.

Is there a simple way to do this without writing a very large if-then-do piece of code that will list each VAR2-VARn individually?
Super Contributor
Super Contributor
Posts: 3,174

Re: Value of VAR1 to ID which of VAR2-VARn to use

Posted in reply to deleted_user
Look at using the VVALUEX function in a DATA step.

Scott Barry
SBBWorks, Inc.
N/A
Posts: 0

Re: Value of VAR1 to ID which of VAR2-VARn to use

That did the trick, I hadn't heard of that function before. Thanks.
Ask a Question
Discussion stats
  • 2 replies
  • 162 views
  • 0 likes
  • 2 in conversation