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.