BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

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

 

 

3 REPLIES 3
Ronein
Onyx | Level 15

I found solution to first problem by using justify=C

title  justify=C    'xxxxxx';

 

Now still need solution to 2nd problem 

art297
Opal | Level 21

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
Super User

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 710 views
  • 1 like
  • 3 in conversation