Date:         Mon, 28 Jan 2002 13:35:07 -0800
Reply-To:     Yvette <hollied@OLIN.WUSTL.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yvette <hollied@OLIN.WUSTL.EDU>
Organization: http://groups.google.com/
Subject:      Re: deleting duplicates
Content-Type: text/plain; charset=ISO-8859-1

Hello all,

I guess I should clarify what I am trying to do.  I only want to
assign a missing value where there are duplicate values.  I don't want
to delete the entire record because in a duplicate for about 5 of my
variables is not so for some other variables.  This is primarily
because I am working with unbalanced data sets that I merged.  This is
why I have found the NODUP other commands to be unsuccessful.  I need
to be able to specify the NODUP (or assigning missing value when
duplicate) by variable rather than by record.

Thoughts????




hollied@olin.wustl.edu (Yvette) wrote in message news:<2a62df28.0201280959.5f717fe0@posting.google.com>...
> Hello all,
>
> I am tryin to write a line (or two) of code that will allow my data to
> read if if this observation minus the next observation does not equal
> zero then put a '.'  Although I haven't been very successful.
>
> I tried the if first.year command but it put missing variables for all
> of my data beyond the first year.  I want it to perform this function
> by both ID and year - by this I mean I won't it to put a missing value
> when not the first obs for the firm and year.
>
> For example:
>
> if not first.year for 1990 1991 and 1992 then put varA = '.'
>
> I realixe the syntax is not correct but this is what I am trying to
> get at.
>
> Any help would be greatly appreciated.