Hi all

I am trying to MERGE two data Sources using the "MATCH" Command it seems not working. Need help big time!!!!!!!!!!!!!!!!!
The issue is the Field by which i am MERGING "STK_NBE" column in one source is of "A18" format and the other is "A8".

STK_NEB = '100011' --- Sample data Source with "A8" format
STK_NEB = '000000000000100011' ----- Same data in the "A18" fromat.

For MATCH Both STK_NEB Should be in the same format. So i did a
"SET ASNAMES =ON
DEFINE FILE STK
LDZ/D8.2S=EDIT(STK_NEB);
AG/A8=FTOA(LDZ, '(D8c)', AG);"

To convert STK_NEB column in "A18" Fromat to "A8". But the solution seems not working. The coverted STK_NEB field data (AG calculated field)is printing properly (as 100011 for sample Data) but not working with MATCH. The result is shown below.

PAGE 1

STK_NEB Descr. DESC_TEXT
100011 CRANBE *****
100011 ***** CRANE
100011 ***** CRANE

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

Can you post your code between the code tags (red carats on the right)? What you are doing sounds right.

Just curious why you would use EDIT and FTOA to convert the A18 column to an A8 column?

I would use Substring:

SUBSTR(inlength, parent, start, end, sublength, outfield)

AG/A8 = SUBSTR(18, STK_NEB, 11, 18, 8, 'A8');

Why not convert them both in I8?

And if possible in the master file.
(This only would work if the real data is in fact numeric)

hi all

Sloved atlast. Insted of using

  
SET ASNAMES =ON
DEFINE FILE STK
LDZ/D8.2S=EDIT(STK_NEB);
AG/A8=FTOA(LDZ, '(D8c)', AG);
END

I used

 
SET LEADZERO=OFF
TABLE FILE STK
PRINT
     COMPUTE AG/A8 = TRIM('L', STK_NEB, 18, '0', 1, 'A8');
     STK_INFO
ON TABLE HOLD AS SPDATA
END

Then use the HOLD file in the Merge it works. But still not sure why the previous way it didnt work.

I'd pay a visit to your "data designers" if I were you and preach the benefits of "same name same format" especially when key fields are involved - oh wait - perhaps they've not had training

T

Hi all

Found the reason why it didn't work with

SET ASNAMES =ON
DEFINE FILE STK
LDZ/D8.2S=EDIT(STK_NEB);
AG/A8=FTOA(LDZ, '(D8c)', AG);
END  

After the define we have to give a COMPUTE in the TABLE level.

COMPUTE STK_NEB1/A8 = RJUST(8,AG,STK_NEB1);

in both the MERGE tables.(This is to align the data in the SORT BY Field properly).

NOw run the procedure it will work

in