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
change this
column name ('demgraphic' sex age height) ;
to this
column name (sex age height) ;
this paper will tell you how to span columns and such that will suppress and or remove the empty cell you want to remove.
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.
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.