Cynthia, thanks for your time, The core of my question deals with lines feeds that are being generated by ODS EXCEL. I have created this file, d.xlsx. In it, an XML file named \\xl\sharedStrings.xml resides. It reads: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="8" uniqueCount="8">
<si></si>
<si><t>Min</t></si>
<si><t>Median</t></si>
<si><t>Max</t></si>
<si><t>edu</t></si>
<si><t>4 YEARS OF COLLEG 4 YEARS OF
COLLEGE</t></si>
<si><t>1 YEAR OF GRAD SC 1 YEAR OF
GRAD SCHOOL</t></si>
<si><t>4 OR MORE YEARS O 4 OR MORE YEARS OF
GRAD SCHOOL</t></si>
</sst> Note the line feeds here, on certain long lines. This file was not opened by EXCEL after SAS and ODS Excel created the file. Now consider the code that produced it: proc format;
value EDUCLAM
16 = '4 YEARS OF COLLEG 4 YEARS OF COLLEGE'
17 = '1 YEAR OF GRAD SC 1 YEAR OF GRAD SCHOOL'
18 = '2 YEARS OF GRAD S 2 YEARS OF GRAD SCHOOL'
19 = '3 YEARS OF GRAD S 3 YEARS OF GRAD SCSCHOOL'
20 = '4 OR MORE YEARS O 4 OR MORE YEARS OF GRAD SCHOOL'
;
run;
data nowrap;
infile datalines;
input edu;
format edu EDUCLAM.;
datalines;
16
17
20
;
run;
ods excel file="d.xlsx"
style=Sasweb;
PROC TABULATE DATA=WORK.NOWRAP ;
VAR edu/ style=[tagattr='wraptext:no' ];
TABLE edu,(min Median max)*F=EDUCLAM.;
run;
ods excel close; No line feeds... It is not one of the principles of SAS output that the data that is provided for output is presented for output without modification. Yet this is happening, added linefeeds appear. I don't think it should be doing this, or specifically, it should do this only if the user specifically request this behavior. Is this grounds for a more formal error report --- in your opinion? thanks again
... View more
