how to export a crosstab?

[rainylsh]

how to export a crosstab .

example:
1 2 3 4
2 22 23 24
3 32 33 34
4 42 43 44
?

 

[tudorconstantin]

Could you be more specific with what you need?
Export from where to where?

 

[rainylsh]

Could you be more specific with what you need?
Export from where to where?

just to export to .txt file or browse
i want know how can do

 

[tudorconstantin]

This code produces exactly your output.

define variable i as integer no-undo.
define variable j as integer no-undo.

output to "c:\crosstab.txt".
do i = 1 to 4:
do j = 1 to 4:
if i eq 1 then put unformatted j " ".
else
if j eq 1 then put unformatted i " ".
else
put unformatted i j " ".
end.
put unformatted skip.
end.
output close.

Let me know if there is more or else that you need.

 

[sgs.prasad]

Hi,

You can do one thing. Create a extent based on number of columns i.e for example if you have 4 columns then have variable "x" of character with extent 4. then spool the data for respective index (array index). When the variable "x" is displayed it will display the values horizontally.