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;
Hi:
My recommendation is to switch to ODS EXCEL, if possible. Either ASIS=ON or INDENT= works with ODS EXCEL, as shown below.
Cynthia
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.
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
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
Hi:
My recommendation is to switch to ODS EXCEL, if possible. Either ASIS=ON or INDENT= works with ODS EXCEL, as shown below.
Cynthia
Thanks a lot Cynthia.
It worked with ODS Excel.
Regards,
Rajesh
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.