BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
draroda
Fluorite | Level 6

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;
1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ

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

6 REPLIES 6
Cynthia_sas
SAS Super FREQ
Hi:
I think that ODS EXCEL does respect ASIS=ON. You can also use indent= with ODS EXCEL.

Cynthia
draroda
Fluorite | Level 6

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
Fluorite | Level 6

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
SAS Super FREQ

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

draroda
Fluorite | Level 6

Thanks a lot Cynthia.

 

It worked with ODS Excel.

 

Regards,

Rajesh

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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