topic Re: ODS EXCELXP tagset and indentation fix in ODS and Base Reporting

ODS EXCELXP tagset and indentation fix

vandhan — Wed, 02 Mar 2016 08:37:16 GMT

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.

Re: ODS EXCELXP tagset and indentation fix

Ksharp — Wed, 02 Mar 2016 09:11:05 GMT

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;