topic Re: sas proc export into excel in SAS Programming

sas proc export into excel

Ronein — Wed, 04 Dec 2019 09:01:58 GMT

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

Re: sas proc export into excel

Ronein — Wed, 04 Dec 2019 09:07:56 GMT

I found solution to first problem by using justify=C

title justify=C 'xxxxxx';

Now still need solution to 2nd problem

Re: sas proc export into excel

art297 — Wed, 04 Dec 2019 14:08:08 GMT

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

Re: sas proc export into excel

ballardw — Wed, 04 Dec 2019 22:48:26 GMT

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.