ODS EXCELXP tagset and indentation fix

[vandhan]

Hi,

I have one variable in dataset is having indentation for few rows. but when i craeating excel file using ODS EXCELXP tagset... the identation is coming in excel file..

please help

ex:

variable in dataset:

name

James

 david

excel file

James

david

where david having left identation in dataset.. but i can't see in excel file.

[Ksharp · Accepted solution]

That is what supposed to be . Add a TAB character before it to imitate a blank.

data have;
input name $20.;
if name='david' then name=cats('09'x,name);
cards;
James
david
;
run;

option nobyline;
ods tagsets.excelxp file='c:\temp\tresto.xml' style=sasweb;
proc report data=have nowd;
run;
ods tagsets.excelxp close;