By running the following statemant to export the results of a "proc tabulate" to EXCEL, SAS did a perfect job, except that I miss the the class variable (ir_Nr_GTAP) at the top of each tables (see above):
ods xml file="G:\GTAP\SAS_OUTPUT_XLS\DK_NAMA_EU_BT.csv" type=csvall;
PROC tabulate DATA = DK.SZ_EU_SG_IrG_ErG;
CLASS sct_Nr_GTAP ir_Nr_GTAP er_Nr_GTAP;
VAR BT__;
TABLE ir_Nr_GTAP, sct_Nr_GTAP, er_Nr_GTAP *(BT__ * mean * F=10.6 )
/ PRINTMISS RTS = 14;
RUN; quit;
ods xml close;
All the tables look like this, without reporting the ir_Nr_GTAP variable at teh top of each table:
RESULT in EXCEL :
er_Nr_GTAP
1 2 3
BT__ BT__ BT__
Mean Mean Mean
sct_nr_GTAP . 0.000000 20.000.000
1
2 . 0.000000 20.000.000
3 . 2.296.143 43.079.649
4 . 1.368.650 50.468.266
5 . 0.000000 45.000.000
6 . . .
7 . . 11.000.000
er_Nr_GTAP
1 2 3 4
BT__ BT__ BT__ BT__
Mean Mean Mean Mean
sct_nr_GTAP . . . .
1
2 . . . .
3 1.000.000 . . 91.200.000
4 0.787551 . 56.068.537 11.601.399
5 1.000.000 . . 5.000.000
6 . . . .
7 . . . .
Has anybody any hint to solve this Problem ?
An other trial was: I tried to export the tables by HTML, but the file size is to big an EXCEL can't open the files (ERROR no response of EXCEL)
thanks
... View more