Date:         Wed, 14 Apr 2010 15:54:47 -0400
Reply-To:     JKR <jayakumarreddy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         JKR <jayakumarreddy@GMAIL.COM>
Subject:      Replacing null values with existing values

Hi
i have a dataset like this

num npi
12
12 1234
12 1234
12 1234
12 1234
12 1234
13
13
13 4567
13 4567
14
14
14 5664
14 5664
14 5664
14 5664
.
.
.
.

i want to populate missing npi with npi in the column for that num and
should have the following dataset

num npi
12 1234
12 1234
12 1234
12 1234
12 1234
12 1234
13 4567
13 4567
13 4567
13 4567
14 5664
14 5664
14 5664
14 5664
14 5664
14 5664
.