I have this requirement, below is the example data:

 
ID      Description
001     AAA
001     BBB
002     CCC
002     DDD
003     EEE
 

I need to output it like:

 
ID      Description
001     AAA BBB
002     CCC DDD
003     EEE
 

How can I concatenate the description of the same ID in one row ?
Thanks.

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

Try below code. It will help you.

APP PATH IBISAMP
-******** Ensure data is sorted on right column. Here it is COUNTRY. In your case it should be ID column *********
TABLE FILE CAR
PRINT
COMPUTE ALL_CAR/A200V = IF COUNTRY EQ LAST COUNTRY THEN ALL_CAR | ' , ' | CAR ELSE CAR; AS 'ALL CARS'
COMPUTE A_CAR_LEN/I3=ARGLEN(200,ALL_CAR,'I3'); NOPRINT
BY COUNTRY 
BY TOTAL HIGHEST 1 A_CAR_LEN NOPRINT
END

Thanks,
Ram

Thanks Ram, this works perfectly.