BookmarkSubscribeRSS Feed
thanikondharish
Calcite | Level 5

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
Calcite | Level 5
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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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