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

tagsets.excelxp align value in the middle of excel cell

GeorgeSAS — Tue, 25 Apr 2017 21:42:21 GMT

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 — Tue, 25 Apr 2017 22:03:14 GMT

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.