topic Re: how to keep variable in single box in SAS Programming

how to keep variable in single box

thanikondharish — Fri, 16 Aug 2019 15:21:13 GMT

ods html file='E:\class.html' ;
proc report data=sashelp.class
nowd;
column name ('demgraphic' sex age height) ;
run;
ods _all_ close ;

If i apply below coding
column name ('demgraphic' sex age height) one structure is coming if we observe html file
The column 'name' above one empty box is there so how to avoid that empty box and 'name' should be in singe box
Note:Remove line above name column and keep single box

Re: how to keep variable in single box

VDD — Fri, 16 Aug 2019 16:03:07 GMT

change this

column name ('demgraphic' sex age height) ;

to this

column name (sex age height) ;

Re: how to keep variable in single box

thanikondharish — Fri, 16 Aug 2019 16:06:16 GMT

demograhic should be display

Re: how to keep variable in single box

VDD — Fri, 16 Aug 2019 16:16:50 GMT

this paper will tell you how to span columns and such that will suppress and or remove the empty cell you want to remove.

https://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf

Re: how to keep variable in single box

ballardw — Fri, 16 Aug 2019 17:57:24 GMT

If location of the "name" is sufficient then this may suffice:

proc report data=sashelp.class;
   column ('Name' name) ('Demographic' sex age height)
   ;
   define name / ' ';
run;

Otherwise I suspect that you may be entering into the realms of the data step Report Writing Interface to merge the cell.

Re: how to keep variable in single box

VDD — Fri, 16 Aug 2019 18:28:39 GMT

or have a title statment


ods html file='E:\class.html' ;
title "Demographic";
proc report data=sashelp.class
nowd;
column name (sex age height) ;
run;