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>
>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
>On Jan 14, 2008 11:10 AM, Andy Andrews <email@example.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
>> >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
>> >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.