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>
Subject: Re: deleting duplicates
Content-Type: text/plain; charset=ISO-8859-1
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.
email@example.com (Yvette) wrote in message news:<firstname.lastname@example.org>...
> 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.