I have data in a hold file like this,

LIST NAME1 COMP1
1 KENNEDY,HOLLY J 0
2 DALE,LUKE 319639
3 DALE,LUKE 0
4 DALE,LUKE 0
5 BIGELOW, RON 319629
6 KOLAR,BARBARA KAY 324095
7 DALE,LUKE 319653
8 DALE,LUKE 0
9 DALE,LUKE 0
10 BIGELOW, RON 319629
11 SMITHEY,ALAN W 324095
12 SMITHEY,ALAN W 0
13 DALE,LUKE 335338
14 DALE,LUKE 0
15 DALE,LUKE 0
16 BIGELOW, RON 319629

I need the following...Basically the zero's replaced with the first non zero value above them... How to achieve this.?

LIST NAME1 COMP1
1 KENNEDY,HOLLY J 0
2 DALE,LUKE 319639
3 DALE,LUKE 319639
4 DALE,LUKE 319639
5 BIGELOW, RON 319629
6 KOLAR,BARBARA KAY 324095
7 DALE,LUKE 319653
8 DALE,LUKE 319653
9 DALE,LUKE 319653
10 BIGELOW, RON 319629
11 SMITHEY,ALAN W 324095
12 SMITHEY,ALAN W 324095
13 DALE,LUKE 335338
14 DALE,LUKE 335338
15 DALE,LUKE 335338
16 BIGELOW, RON 319629

This message has been edited. Last edited by: Kerry,

how about

NEWFLD/D9=IF FIELD EQ 0 THEN LAST NEWFLD ELSE FIELD;

The "LAST" keyword is what you're looking for.