proc report some blank disappears

Nasser_DRMCP — Tue, 07 Apr 2026 07:48:47 GMT

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

Re: proc report some blank disappears

Nasser_DRMCP — Tue, 07 Apr 2026 08:14:00 GMT

solution found by adding this option

flow="tables"

Re: proc report some blank disappears

Tom — Wed, 08 Apr 2026 14:07:40 GMT

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.

topic proc report some blank disappears in SAS Programming

proc report some blank disappears

Re: proc report some blank disappears

Re: proc report some blank disappears