Hi:
You can put a label (or remove a label) on the DEFINE statement. By default, since you have no label information on the DEFINE statement, your variable labels or names are used for the spanning headers. So, for example, to remove the label for the variable VALUE, you would have (quote, space, quote) as the label (the quoted string on the DEFINE statement):
[pre]
COLUMNS 'SHA code'n mlk, value total;
DEFINE 'SHA code'n / GROUP;
DEFINE value / ANALYSIS SUM ' ' ;
DEFINE mlk /ACROSS ;
DEFINE total / COMPUTED FORMAT=nlmny15.0;
[/pre]
If you selectively experiment with the ' ' (quote, space, quote) in your DEFINE statements, you will see that it is possible to remove
column headers that you do NOT want...or to assign headers that you DO want.
If you find that you have a row of empy cells when you assign blanks as the label for your header, you may want to rearrange the order of the variables you list in your COLUMN statement...and instead of what's above, try this, as well to see whether that gives you headers closer to what you want.
[pre]
COLUMNS 'SHA code'n
value,mlk total;
[/pre]
Also, for future reference, this is a very handy forum posting that explains how to post questions and still maintain the indenting of code and of output that you want to show:
http://support.sas.com/forums/thread.jspa?messageID=27609毙
cynthia