BookmarkSubscribeRSS Feed
thanikondharish
Fluorite | Level 6

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

5 REPLIES 5
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

change this

 

column name ('demgraphic' sex age height) ;

to this

column name (sex age height) ;
thanikondharish
Fluorite | Level 6
demograhic should be display
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

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

ballardw
Super User

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.

VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

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;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1183 views
  • 0 likes
  • 3 in conversation