Hello, SAS-L, I think I've lost your answer about this. So, I hope don't disturb you by replying my question. I have something like this in a flat file:

S904000 25 1994 1 12 776381.3 919053.4 1052423.8

.... up to 25 observations. Note that this number appears in the second line.

S504r01 20 1994 1 12 696686.2 948585.4 2993845.4

.... up to 20 observations. This number appears in the second line,too.

etc.

I have a SAS data set named KEYS, looking like this:

CODE KEY

S904000 BSC000000000 S504r01 BSC000000001

etc.

Finally, we want something like this in a flat file:

CODE=BSC000000000 DATA=25 FROM=1994 776381.3 919053.4 1052423.8 ... (left aligned)

CODE=BSC000000001 DATA=20 FROM=1994 696686.2 948585.4 2993845.4 ... (left aligned)

You'll see, there are two problems: 1) Code substitution. 2) Writing the final flat file. I think that the response could be a special style of INPUT, but I cannot find it.

Can you help me?

TIA __________________________________________

Juan Luis Perez Martinez Jefe de Servicio Apoyo Software Instituto Nacional de Estadistica Paseo Castellana 183 Despacho 113 28046 MADRID (Spain) E-mail: jlperez@ine.es __________________________________________