TAGSETS.EXCELXP indent cell contents.

[data_null__]

If I want to indent the cell contents of a column is there an option?

It appears that tagset would need to add INDENT to the XML as below.

This is original XML
[pre]

[Eric_SAS]

Indent is a style attribute. It can be defined in a style element or as a style over-ride. This example shows both ways, It just depends upon which classlev statement you use. With proc print, report or tabulate the style or over ride can be specified in many ways.

proc template;
define style mystyle;
parent=styles.default;
style myclasslev from data/
indent=10;
end;
run;

ods listing close;
ods pdf file="file.pdf" style=mystyle;
ods tagsets.excelxp file='temp.xls' style=mystyle;
title ;footnote;
proc tabulate data=sashelp.class; * missing;
class name age / order=data;
/*classlev name / s=myclasslev;*/
classlev name / s=data[indent=10];
table name=' ' all="Total",
age=' '*(N COLPctN='%') / box="Agegp" ;
run;

ods _all_ close;

[data_null__]

Thanks so much, just what I needed to see. Here is example of what I was trying to do.

[pre]
proc template;
define style mystyle;
parent=styles.default;
style rightIndent from data /
indent=4
just=right;
end;
run;

ods tagsets.excelxp file='temp006.xml' style=mystyle;
proc report nowd data=sashelp.class;
define _numeric_ / display style(column)=rightIndent;
run;
ods _all_ close;
[/pre]