sas proc export into excel

[Ronein]

Hello

When I export sas table (or print) into excel there are 2 problems that I wan to solve:

1-I want that the title will be located on multiple cells (merge cells) and not in one cell.

2-I want that the sheet will be right to left direction and not left to right (please note that my excel is defined by right to left but when i export  table from sas into excel then the sheet is left to right and not right to left)

thank you

Joe

[Ronein]

I found solution to first problem by using justify=C

title  justify=C    'xxxxxx';

Now still need solution to 2nd problem 

[art297]

I might not understand what you need but, if you only want to reverse the order of your variables, the following should work:

proc sql noprint;
  select name into :names separated by ' '
    from dictionary.columns
      where libname='SASHELP' and
            memname='CLASS'
        order by varnum  descending
  ;
quit;

data need;
  retain &names.;
  set sashelp.class;
run;

Art, CEO, AnalystFinder.com

[ballardw]

It may help to show the code you are using to "export".

Since you mention Title it is almost certain that you are not using Proc Export to export data. So you are creating output of some sort and different options come into play depending on how you are creating that output.