proc report some blank disappears

[Nasser_DRMCP]

Data have;
infile datalines dsd;
informat DIRECTION $70.  ;
input DIRECTION $ ;
datalines ;
DIR REGULARISATION CLIENT
DIRECTION DES CLIENTELES
run ;


%MACRO mc_export_table(p_chemincomplet) ;

ODS EXCEL FILE="$GRPFPU/REQUETES_PROD/have.xlsx" STYLE=HTMLBlue;
ODS Excel options (   SHEET_NAME = "Base"
                                          EMBEDDED_TITLES = "off"
                                          FROZEN_HEADERS = "yes"
                                          AUTOFILTER = "all"
                                          absolute_row_height='30'
                                          ROW_HEIGHTS="0,20,0,0,0,0,0");

PROC REPORT DATA=have NOWD
     STYLE(header)=[background=CX9BC2E6 foreground=white just=center]
     STYLE(column)=[cellwidth=3cm];
     COLUMN
DIRECTION

;

define DIRECTION / display "DIRECTION" ;
RUN;
ODS Excel CLOSE;
ODS LISTING;
%MEND mc_export_table;

%mc_export_table ;

hello

as you can see there is some blank in the direction's name.

But by exporting in a excel file, I get this

DIRREGULARISATIONCLIENT

DIRECTION DESCLIENTELES

thanks for your help

NassR

[Nasser_DRMCP]

solution found by adding this option

flow="tables"

[Tom]

Yes. That should solve the issue of SAS changing the values so that Excel will split the values into multiple lines.  Which you can see in this screen shot of the two different files.

Which is not what I took your original question to be about.