Data Problem

[RahulBandgar]

I have a dataset in which there a 3 columns.

A       B       C

1       .          1

1       .          2    

1       .          3

1       0            

2       .          1

2        .          2

2        0        

3         .          1

3         .          2

3        0         

So question is like this when B=0 then we have to carry forward  the values of C.

for example:

A       B       C    

1       .          1   

1       .          2   

1       .          3   

1       0         1

1       0         2         

1       0         3

This type of output I want. Can anyone please help me ??pro

[LinusH]

Please avoid duplicate postings.

[Ksharp]

Code: Program

data have;
input A   B   C;
cards;
1 . 1
1 . 2  
1 . 3
1 0 . 
2 . 1
2 . 2
2 0 .
3 . 1
3 . 2
3 0 .
;
run;
proc sql;
create table want as 
 select a.*,b.c
  from (select distinct A,B from have) as a,
   (select distinct A,C from have where C is not missing) as b
   where a.A=b.A
   order by a.a,a.b,b.c;
quit;