tagsets.excelxp align value in the middle of excel cell

[GeorgeSAS]

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

[Reeza]

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