topic Re: Blank Spaces lost in ods tagest excelxp in ODS and Base Reporting

Blank Spaces lost in ods tagest excelxp

draroda — Sun, 27 May 2018 07:30:23 GMT

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;

Re: Blank Spaces lost in ods tagest excelxp

SuzanneDorinski — Sun, 27 May 2018 15:58:58 GMT

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

Re: Blank Spaces lost in ods tagest excelxp

Cynthia_sas — Sun, 27 May 2018 16:43:31 GMT

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

Cynthia

Re: Blank Spaces lost in ods tagest excelxp

draroda — Mon, 28 May 2018 05:05:49 GMT

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

Re: Blank Spaces lost in ods tagest excelxp

draroda — Mon, 28 May 2018 05:13:33 GMT

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

Re: Blank Spaces lost in ods tagest excelxp

Cynthia_sas — Mon, 28 May 2018 14:25:50 GMT

Hi:

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

Cynthia

Re: Blank Spaces lost in ods tagest excelxp

draroda — Tue, 29 May 2018 16:17:27 GMT

Thanks a lot Cynthia.

It worked with ODS Excel.

Regards,

Rajesh