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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.