BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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?
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Look at using the VVALUEX function in a DATA step.

Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
That did the trick, I hadn't heard of that function before. Thanks.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1546 views
  • 0 likes
  • 2 in conversation