Date:         Mon, 14 Apr 2003 15:11:08 -0600
Reply-To:     William Kossack <kossackw@NJC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         William Kossack <kossackw@NJC.ORG>
Organization: Posted via Supernews, http://www.supernews.com
Subject:      Re: eliminated variables with missing values
Content-Type: text/plain; charset=us-ascii

I need to eliminate both variables and IDs.

In my example the only data that has any value is for ID 1 and var3.  Therefore the resulting dataset

should not have ID 2 or 3 and it should not have var1 or var2.

Prasad S Ravi wrote:

> This is confusing,  can you provide some sample data you are dealing with.
>
> Do you mean removing observations or variables?.
>
> If it is observations you may want to consider using FIRST.ID and LAST.ID
> to achieve what you want.
>
> Prasad Ravi
>
>                          William Kossack
>                          <kossackw@NJC.ORG>     To:    SAS-L@LISTSERV.UGA.EDU
>                          Sent by: "SAS(r)       cc:
>                          Discussion"            Subject: eliminated variables with missing values
>                          <SAS-L@LISTSERV.UGA.E
>                          DU>
>
>                          04/14/2003 01:32 PM
>                          Please respond to
>                          William Kossack
>
> I have a dataset that is mostly missing data.  The data is organized by
> ID and date.
>
> I need to remove variables from the dataset that do not have two values
> by sort order.
>
> If sorted by id and then date and I don't have two dates with values for
> an id I want to eliminate the variable from the dataset.
> Similarly, if an id does not have two dates with values I want to
> eliminate the id.
>
> Ids with only one value on one date are eliminated.  Variables with only
> missing values or only one value per id have been elimiated.