Hello,
I'm using ODS Excel to output a data table and I've noticed that the output is being altered from the original by eliminating spaces.
Code:
ods excel file="\\hne_crms\hsra\RLafond\Quality\QIP\test3\&NAME._&LOB._QIP_Roster_&reportdate..xlsx";
ods excel options(sheet_name="&Name Roster &Month &Year");
PROC PRINT DATA = &NAME._&LOB._STEP2 NOOBS;
RUN;
ODS excel close;
Examples:
Source: VBC Group B
Output: VBC GroupB
Source: Adult BMI Assessment
Output: Adult BMIAssessment
Source: Appropriate Testing for Children with Pharyngitis
Output: Appropriate Testingfor Children withPharyngitis
It looks almost like some sort of formatting being done to replicate wrapping in Excel. Any idea why this is happening and how I can stop it? I've included an image showing what it looks like in Excel:
You should include the code used to create the output including the ODS Excel statement to show options.
Since many procedures can provide output we kind of need to know which specific procedure and options were involved.
Also, you need to know that the message windows on this forum will also reformat text. So you need to be very careful what is posted.
Actual plain text such as code, log and raw data are best posted into code boxes opened with either the forums {I} or "running man" icons to prevent such reformatting as leading space removal, multiple space compression and some HTML code insertion/replacements.
Updated original post with relevant code.
Hi:
I find that if I make the cell wide enough that ODS EXCEL doesn't automatically wrap the line:
I believe the number of columns you have can also impact the wrapping behavior. But adjusting width is a place to start.
Cynthia
So I ended up researching line returns and found that using the ODS Excel option
flow = 'tables'
Fixed the return issue.
Thanks for the direction!
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.