The SAS Output Delivery System and reporting techniques

ODS EXCELXP tagset and indentation fix

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

ODS EXCELXP tagset and indentation fix

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.


Accepted Solutions
Solution
‎03-02-2016 04:29 AM
Super User
Posts: 9,867

Re: ODS EXCELXP tagset and indentation fix

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;

 

 

View solution in original post


All Replies
Solution
‎03-02-2016 04:29 AM
Super User
Posts: 9,867

Re: ODS EXCELXP tagset and indentation fix

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;

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 390 views
  • 0 likes
  • 2 in conversation