Date:         Mon, 14 Jul 2003 13:34:38 -0700
Reply-To:     JM Doyle <doylejm@JMU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         JM Doyle <doylejm@JMU.EDU>
Organization: http://groups.google.com/
Subject:      simple data set merge/appending ??
Content-Type: text/plain; charset=ISO-8859-1

Hi,
I want to append/merge two data sets that look like this:

First data set is:

ID   YEAR    XVAR
1    2001    10
2    2001    16

Second data set is:

ID   YEAR   XVAR
1    2002   11
2    2002   17
3    2002   19

I want the combined data to allow for a missing obs. for ID=3 in 2001 like this:

ID   YEAR   XVAR
1    2001   10
1    2002   11
2    2001   16
2    2002   17
3    2001    .
3    2002   19

With a merge or a set command, I don't get the missing observation in 2001 for ID=3.

Any help would be appreciated. Thank you