Date:         Mon, 14 Jan 2008 13:26:49 -0500
Reply-To:     Andy Andrews <sas_andy@BOOSECAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andy Andrews <sas_andy@BOOSECAT.COM>
Subject:      Re: Delete emptry records

The two-step solution is exactly what I had planned to do.  I was going to
drop the "key" fields b/c I already have them stored in a macro variable.
Then any blank records would be deleted and any non-blank records would be
kept with recno = _n_ (or similar) for merging purposes.  If I run into
problems or if it gets ugly, I'll post an example (can't get into SAS this
very moment).  Thanks!


On Mon, 14 Jan 2008 11:21:52 -0600, data _null_, <datanull@GMAIL.COM>
wrote:

>Post some example data.  You can still do it but you might have to
>work a bit harder get the lists of variables to coalesce.
>
>A two step solution using the code I suggest would be to DROP the KEY
>variables and create a data set of observations numbers that need to
>be deleted.
>
>On Jan 14, 2008 11:10 AM, Andy Andrews <sas_andy@boosecat.com> wrote:
>> Well technically all fields minus some key fields, though I could manage
>> with all fields = missing.
>>
>> Thanks data _null_ - I'll give it a try!
>>
>>
>> On Mon, 14 Jan 2008 08:29:00 -0800, Terjeson, Mark
<Mterjeson@RUSSELL.COM>
>> wrote:
>>
>> >Hi Andy,
>> >
>> >What is your definition of an empty record?
>> >All fields set to missing?  All fields except
>> >for the key?  other?
>> >
>> >
>> >
>> >Mark Terjeson
>> >Senior Programmer Analyst, IM&R
>> >Russell Investments
>> >253-439-2367
>> >
>> >
>> >Russell
>> >Global Leaders in Multi-Manager Investing
>> >
>> >
>> >-----Original Message-----
>> >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>> >Andy Andrews
>> >Sent: Monday, January 14, 2008 8:20 AM
>> >To: SAS-L@LISTSERV.UGA.EDU
>> >Subject: Delete emptry records
>> >
>>
>> >Hi all, I'm trying to delete empty records from a dataset.  I feel this
>> >should be simple to do, however I'm not getting it today.  I can't
>> >hardcode any column names as I'll need it for multiple datasets.
>> >Thanks!
>> >
>> >AA
>>