Date:         Thu, 12 Mar 2009 19:29:31 -0400
Reply-To:     jmd <doylejm@JMU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         jmd <doylejm@JMU.EDU>
Subject:      Request help with missing observations

I have a panel of data, and want to insert missing values for certain
observations. The easiest way to explain is with this example.

What I have:
firm year var1
1 1991 110
1 1992 140
1 1993 135
2 1992 13
2 1995 15
3 1991 1200
3 1992 1234
3 1993 1269
3 1995 1300

What I want:
firm year var1
1 1991 110
1 1992 140
1 1993 135
1 1994 .
1 1995 .
2 1991 .
2 1992 13
2 1993 .
2 1994 .
2 1995 15
3 1991 1200
3 1992 1234
3 1993 1269
3 1994 .
3 1995 1300

I have tried a few things with a PROC SQL/outer join, etc. but it is not
working. Thank you in advance.
j