Greetings all. I'm hitting a DB2 table that has around 100 columns, and I only want 5 of them. Is there a quick way to drop them all excluding the 5 I want, without having to explicitly type them all out in a drop statement?
Greg
Instead of DROP= use KEEP= for the variables you want.
The pain is when the desired number is about half of the variables...
Instead of DROP= use KEEP= for the variables you want.
The pain is when the desired number is about half of the variables...
Thank you, I knew it had to be something easy like that.
Greg
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.