04-25-2017 05:41 PM - edited 04-25-2017 05:42 PM
How to make age stay in the middle(center) of the cell?
ods listing close;
ods tagsets.excelxp file="C:\temp\test236.xls"
title "SAS help.class";
ods tagsets.excelxp options(absolute_column_width='30');
select age from sashelp.class;
ods tagsets.excelxp close;
04-25-2017 06:03 PM
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.