Date:         Tue, 15 May 2007 18:31:46 +1000
Reply-To:     "Johnson, David" <David.Johnson@CBA.COM.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Johnson, David" <David.Johnson@CBA.COM.AU>
Subject:      Re: missing records
Content-Type: text/plain; charset="us-ascii"

I am sure I have seen a sample on the support.sas.com website to
demonstrate this process.

Kind regards

David



"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet,
consectetur, adipisci velit..."

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
jeli0703@HOTMAIL.CO.UK
Sent: Tuesday, 15 May 2007 6:17 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: missing records

I have a dataset with 17 columns, and and upto 8million records.

What I want to do is be able to identify all totally blank columns and
delete them,

ie if 1 million records were read in and all 1 million are blank then
delete that whole column, however if only 1 record is popultated then
that whole column needs to stay

can you help.

************** IMPORTANT MESSAGE *****************************
This e-mail message is intended only for the addressee(s) and contains information which may be
confidential.
If you are not the intended recipient please advise the sender by return email, do not use or
disclose the contents, and delete the message and any attachments from your system. Unless
specifically indicated, this email does not constitute formal advice or commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please reply to this
e-mail by typing Unsubscribe in the subject line.
**************************************************************