topic Drop all columns except the few I want in SAS Programming https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84876#M256911 <HTML><HEAD></HEAD><BODY><P>Greetings all.&nbsp; I'm hitting a DB2 table that has around 100 columns, and I only want 5 of them.&nbsp; 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?</P><P>Greg</P></BODY></HTML> Wed, 03 Oct 2012 20:18:42 GMT gsnidow 2012-10-03T20:18:42Z Drop all columns except the few I want https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84876#M256911 <HTML><HEAD></HEAD><BODY><P>Greetings all.&nbsp; I'm hitting a DB2 table that has around 100 columns, and I only want 5 of them.&nbsp; 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?</P><P>Greg</P></BODY></HTML> Wed, 03 Oct 2012 20:18:42 GMT https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84876#M256911 gsnidow 2012-10-03T20:18:42Z Re: Drop all columns except the few I want https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84877#M256912 <HTML><HEAD></HEAD><BODY><P>Instead of DROP=&nbsp; use KEEP= for the variables you want.</P><P></P><P>The pain is when the desired number is about half of the variables...</P><P><BR /> </P></BODY></HTML> Wed, 03 Oct 2012 20:20:50 GMT https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84877#M256912 ballardw 2012-10-03T20:20:50Z Re: Drop all columns except the few I want https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84878#M256913 <HTML><HEAD></HEAD><BODY><P>Thank you, I knew it had to be something easy like that.</P><P></P><P>Greg</P></BODY></HTML> Wed, 03 Oct 2012 21:20:20 GMT https://communities.sas.com/t5/SAS-Programming/Drop-all-columns-except-the-few-I-want/m-p/84878#M256913 gsnidow 2012-10-03T21:20:20Z