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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.