Blank Spaces lost in ods tagest excelxp

[draroda]

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;

[SuzanneDorinski]

Usage Note 44126: ASIS=ON does not maintain leading or trailing blanks in the output generated by th... shows a modification to the tagset that you can use.

[Cynthia_sas]

Hi:
I think that ODS EXCEL does respect ASIS=ON. You can also use indent= with ODS EXCEL.

Cynthia

[draroda]

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

[draroda]

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

[Cynthia_sas · Accepted solution]

Hi:

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

Cynthia

[draroda]

Thanks a lot Cynthia.

It worked with ODS Excel.

Regards,

Rajesh