I have data as follows,

DEPTH........NAME
1...........DAVE
2...........KIM
3...........RODNEY
1...........MARGARET
2...........ROJA


I need to add spaces to the NAME field depending on the value of DEPTH. For example I need to add 1 space to DAVE and two spaces to KIM and so on. I put dots and brackets to illustrate here but are not needed.

DEPTH........NAME
1...........(.)DAVE
2...........(..)KIM
3...........(...)RODNEY
1...........(.)MARGARET
2...........(..)ROJA

Thanks.

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

TABLE FILE CAR
SUM MAX.SEATS
ON TABLE SAVE
END
-RUN
-READ SAVE &FORMAT1.A3.
-SET &FORMAT2= 24 + &FORMAT1;
TABLE FILE CAR
PRINT SEATS
COMPUTE DOTS/A&FORMAT1.EVAL = DECODE SEATS(1 '.' 2 '..' 3 '...' 4 '....' 5 '.....' ELSE ''); NOPRINT
COMPUTE NEWCOL1/A&FORMAT2.EVAL = DOTS || MODEL; NOPRINT
COMPUTE NEWCOL2/A&FORMAT2.EVAL = CTRAN(&FORMAT2.EVAL, NEWCOL1, 46, 32, NEWCOL2);
ON TABLE SET SHOWBLANKS ON
END

John

If you use STRREP, you would have to worry less about the DECODE I believe.

TABLE FILE CAR
SUM MAX.SEATS
ON TABLE SAVE
END
-RUN
-READ SAVE &FORMAT1.A3.
-SET &FORMAT2= 24 + &FORMAT1;
TABLE FILE CAR
PRINT SEATS
COMPUTE MODEL1/A&FORMAT2 = '#' | MODEL; NOPRINT
COMPUTE MODEL2/A&FORMAT2 = STRREP (&FORMAT2,MODEL1,1,'#',SEATS-1,'          ',&FORMAT2,'A&FORMAT2');
ON TABLE SET SHOWBLANKS ON
END

Alan quite right however my concern with doing that is that you have to use a replacement string greater than the declared replacement string length.

Knowing the way the developers in New York seem to have a passion for making subtle changes
to subroutines there is always the possibility that it might not work in the future.

Thank you both for your suggestions..that will work for me..
I am trying to understand the logic here.
Why are you both adding 24 here to the max value??

The reason for the 24 is quite simple, It's the original length of the field MODEL from the car file.