Excluding blanks is easiest: EXCLUDE COND=(1,9,CH,EQ,C' ')
Including only numeric I'm not as sure of. You might try: INCLUDE COND=(1,9,FS,EQ,NUM) -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:ibm-m...@bama.ua.edu] On Behalf Of Howard Brazee > Sent: Tuesday, May 25, 2010 10:59 AM > To: IBM-MAIN@bama.ua.edu > Subject: Quick Sort question > > We have a lot of jobs that use the following SORTIN > > SORT FIELDS=(01,009,A), > FORMAT=CH > SUM FIELDS=NONE > > What is the simplest ways to change this to ensure that either we > exclude blank data or only include numeric IDs here? > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
