topic Re: proc report : wrap text inside the excel celles in SAS Programming

proc report : wrap text inside the excel celles

Nasser_DRMCP — Thu, 15 Dec 2022 10:14:45 GMT

ODS LISTING CLOSE;
ODS EXCEL FILE="$GRPFPU/REQUETES_PROD/TEST_NASSER2.xlsx" STYLE=HTMLBlue;
ods excel options(flow='tables'
                  row_heights='0,14,0,0,0,0,0'
                  sheet_name='Using flow and row_height');
  
proc report data=sashelp.baseball(obs=10)
STYLE(column)=[cellwidth=1cm ];
  column name team league division natbat nhits nruns nrbi;
  define _all_/style={tagattr='wrap:no' verticalalign=T just=l} ;

run;

ods excel close;

hello

Hello

this is the code I executed and this is the result.

the name "Allanson, Andy" has no return carriage inside the formula bar (as attended)

But by cliking inside the cell A2, a RC appears; maybe because the "wrap text button" is activate.

by desactivate it, the RC disapears, this is what I want. how to deal with that "issu" ?

thanks a lot in advance;

regards,

Nasser

Re: proc report : wrap text inside the excel celles

ChrisNZ — Sun, 18 Dec 2022 22:18:21 GMT

Have you seen these pages?

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-Issues/td-p/593710

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Excel-PROC-ODSTEXT-and-tagattr-wraptext/td-p/556826

Re: proc report : wrap text inside the excel celles

Nasser_DRMCP — Mon, 26 Dec 2022 15:37:28 GMT

hello

many thanks for your help.

I am sorry but I do not find the solution. certainly, i do not understand your suggestions.

this "basic" code below works well. I mean there is no RC

ODS LISTING CLOSE;
ODS EXCEL FILE="$GRPFPU/REQUETES_PROD/TEST_NASSER2.xlsx" STYLE=HTMLBlue;
ods excel options(sheet_name='sheet'
			 	Absolute_Column_Width="10" 	);
  
proc report data=sashelp.baseball(obs=10) ;

  column name team league division natbat nhits  ;
 
 run;

ods excel close;

and then, by adding the column "nruns", a RC appears inside row 6 column A. I wonder why.

thanks for your time.

regards

Re: proc report : wrap text inside the excel celles

Nasser_DRMCP — Tue, 27 Dec 2022 10:16:54 GMT

hello,

I copy/past the excel result in ultraedit and then I notice that a RC appears (but also quotes)

manu thanks for your hep