The SAS Output Delivery System and reporting techniques

Blank Spaces lost in ods tagest excelxp

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

Blank Spaces lost in ods tagest excelxp

Hi All,

 

I have below sample data and i want to create report in .xml .But when i output the report blank spaces are not visible.

 

Below is the sample data, proc report code and screenshot attached.

data new;
input text $1 -20;
datalines;
1000
  Fever
  ;
data new;
 set new;
 if _n_=2 then text="         "||text;
run;

ods Tagsets.ExcelXP style=sasweb
file='\\C:Users\Desktop\Table.xml' 
options(orientation='landscape' sheet_name="Index" embedded_titles='yes'  ); 
proc report data=new split='*' headskip spanrows spacing=0 nowd style(header)=[fontweight=bold ];
columns text ;
 define text /"Sample data" style(column)=[cellwidth=150 just=left];
run;
ods Tagsets.ExcelXP close;

Accepted Solutions
Solution
‎05-29-2018 12:16 PM
SAS Super FREQ
Posts: 9,431

Re: Blank Spaces lost in ods tagest excelxp

Hi:

  My recommendation is to switch to ODS EXCEL, if possible. Either ASIS=ON or INDENT= works with ODS EXCEL, as shown below.

Cynthia

ods_excel_indent.png

View solution in original post


All Replies
Frequent Contributor
Posts: 123

Re: Blank Spaces lost in ods tagest excelxp

SAS Super FREQ
Posts: 9,431

Re: Blank Spaces lost in ods tagest excelxp

Posted in reply to SuzanneDorinski
Hi:
I think that ODS EXCEL does respect ASIS=ON. You can also use indent= with ODS EXCEL.

Cynthia
Contributor
Posts: 67

Re: Blank Spaces lost in ods tagest excelxp

Posted in reply to Cynthia_sas

Hi Cyntia,

 

Indent option is not working for ods tagset excelxp.Please suggest if by any way i can achieve the desired output.

 

Regards,

Rajesh

Contributor
Posts: 67

Re: Blank Spaces lost in ods tagest excelxp

Posted in reply to SuzanneDorinski

Hi Suzzane,

 

Thanks for the solution but seems same is not working in my case.

 

While i tried for ods tagset excelxp code from documentaion , it is giving unresolved macro variable error.

 

Regards,

Rajesh

Solution
‎05-29-2018 12:16 PM
SAS Super FREQ
Posts: 9,431

Re: Blank Spaces lost in ods tagest excelxp

Hi:

  My recommendation is to switch to ODS EXCEL, if possible. Either ASIS=ON or INDENT= works with ODS EXCEL, as shown below.

Cynthia

ods_excel_indent.png

Contributor
Posts: 67

Re: Blank Spaces lost in ods tagest excelxp

Posted in reply to Cynthia_sas

Thanks a lot Cynthia.

 

It worked with ODS Excel.

 

Regards,

Rajesh

☑ This topic is solved.

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

Discussion stats
  • 6 replies
  • 307 views
  • 0 likes
  • 3 in conversation