Hi,

I have to display 5 regions with 10 different codes. That means always I have to display 50 rows of data.

Ex:
Table 1:
1 BMW MODEL1
2 JAGUAR MODEL2
2 TOYOTA MODEL3
3 BMW MODEL1
3 TOYOTA MODEL3

I want the output to be

1 BMW MODEL1
1 JAGUAR MODEL2
1 TOYOTA MODEL3
2 BMW MODEL1
2 JAGUAR MODEL2
2 TOYOTA MODEL3
3 BMW MODEL1
3 JAGUAR MODEL2
3 TOYOTA MODEL3

How can I do this? Thanks for your help.

This message has been edited. Last edited by: <Kathryn Henning>,

Look up:

RANKED BY
IN GROUPS OF

You're looking for all distinct combinations? Try this:

 TABLE FILE ibisamp/ggsales
 PRINT DST.REGION
 ON TABLE HOLD AS ggregion
 END

 TABLE FILE ibisamp/ggsales
 PRINT DST.PCD 
 ON TABLE HOLD AS ggpcd
 END

 SQL 
 select REGION, PCD
 from ggregion, ggpcd 
 ;
 TABLE ON TABLE HOLD AS cartesian
 END 
  
 TABLE FILE cartesian
 PRINT *
 END

sweet way to create a Cartesian product,db! beats manual McGyver-ing

PRINT with DST? does this work?
I would think that you get all the rows and not all the values.
Using your idea with FOCUS code:

  
-* File dbeagan01.fex
TABLE FILE ibisamp/ggsales
 SUM 
 COMPUTE ONE/I1=1;
 BY REGION
 ON TABLE HOLD AS ggregion FORMAT FOCUS INDEX ONE
 END

 TABLE FILE ibisamp/ggsales
 SUM 
 COMPUTE ONE/I1=1;
 BY PCD 
 ON TABLE HOLD AS ggpcd FORMAT FOCUS INDEX ONE
 END

 JOIN ONE IN GGREGION TO ALL ONE IN GGPCD AS C
 TABLE FILE GGREGION
 PRINT REGION PCD
 END

Danny-SRL,

I like it. Might be preferred as a more pure FOCUS approach.