Date: Tue, 8 Jun 2010 15:13:40 -0400
Reply-To: Randy <randistan69@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Randy <randistan69@HOTMAIL.COM>
Subject: Filling in Missing Observations
Dear All:
My Data Set is as follows:
ID1 ID2 VarA
A 1 29
A 1 26
A 1 23
A 1 25
A 1 .
A 1 .
A 1 0
A 1 .
A 2 45
A 2 .
A 2 .
A 2 23
A 2 0
A 2 .
B 1 87
B 1 16
B 1 23
B 1 .
B 1 0
B 1 .
I want to construct a VARB such that the Missing Observations are filled by
the previous observation that is an integer. So:
ID1 ID2 VarA VarB
A 1 29 29
A 1 26 26
A 1 23 23
A 1 25 25
A 1 . 25
A 1 . 25
A 1 0 0
A 1 . 0
A 2 45 45
A 2 . 45
A 2 . 45
A 2 23 23
A 2 0 0
A 2 . 0
B 1 87 87
B 1 16 16
B 1 23 23
B 1 . 23
B 1 0 0
B 1 . 0