BookmarkSubscribeRSS Feed
adeliefan
Fluorite | Level 6

I have a large number of variables (>1k) in a dataset and I'd like to change most of them to the USE of No from their present setting of Default. Is a way to do this please?

 

Thank you!

6 REPLIES 6
Reeza
Super User
It's not clear what you're trying to do here, can you provide a small example?
adeliefan
Fluorite | Level 6
Sorry yes – I am using SAS Enterprise Miner. I have added a data source and I want to change the variables USE for a Variable Selection node from Default to No for the majority of the variables. I know how to change them one by one, but there are a lot of them. Is there a way to select multiple variables and change their USE to No please? Thank you!



PaigeMiller
Diamond | Level 26
Which interface of SAS are you using? Enterprise Miner?
--
Paige Miller
adeliefan
Fluorite | Level 6
Sorry yes – I am using SAS Enterprise Miner. I have added a data source and I want to change the variables USE for a Variable Selection node from Default to No for the majority of the variables. I know how to change them one by one, but there are a lot of them. Is there a way to select multiple variables and change their USE to No please? Thank you!
PaigeMiller
Diamond | Level 26

To select many variables that appear sequentially

I believe you can click on one variable and then shift-click on the last one in sequence, so they are now all highlighted. Then changing one variable to NO changes all the selected variables to NO

--
Paige Miller
adeliefan
Fluorite | Level 6
Thank you for your prompt response! Yes – that worked. Thank you so much!!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1021 views
  • 0 likes
  • 3 in conversation