DATA Step, Macro, Functions and more

tagsets.excelxp align value in the middle of excel cell

Reply
Regular Contributor
Posts: 241

tagsets.excelxp align value in the middle of excel cell

[ Edited ]

Hello,

 

 

How to make age stay in the middle(center) of the cell?

 

ods listing close;

ods tagsets.excelxp file="C:\temp\test236.xls"

style=analysis;

title "SAS help.class";

ods tagsets.excelxp options(absolute_column_width='30');

proc sql;

select age from sashelp.class;

quit;

ods tagsets.excelxp close;

ods listing;

run;

 

Thanks

 

Super User
Posts: 19,804

Re: tagsets.excelxp align value in the middle of excel cell

Posted in reply to GeorgeSAS

proc sql doesn't allow for control of the output along those dimensions.

 

You'll need to switch to PROC REPORT or TABULATE that allow style formats.

 

Try PROC REPORT. 

 

This resource has all of the Tagsets features listed plus links to papers with example code. 

https://vasug.files.wordpress.com/2011/07/excelxppaperindex.pdf

Ask a Question
Discussion stats
  • 1 reply
  • 101 views
  • 0 likes
  • 2 in conversation