Formatting Column Names in Output

[PhatRam33]

I feel dumb asking this and I warn you I am new to SAS.  My column name in the output window is displayed in multiple lines

example:  Percent_

               Increase

How do I make my program format it so that the column name is all in one line like this: Percent_Increase. I would like to do this for all my column names eventually.

Many thanks in advance.

[Reeza]

What are you using the output in the window for?

You should always output to some other destination (RTF, PDF, HTML) and use that instead...in my opinion.

[PhatRam33]

Well right now just to view the data but will eventually export to an excel file.. I suppose it won't matter then because I am assuming it will place the column header all in one line?

Right now I am using a proc print procedure to display my data.

[Reeza · Accepted solution]

Exactly.

What you should do is set up labels so that your data looks appropriate ie Percent_Increase = Percent Increase or % Increase

[ballardw]

Also for proc print you can explicitly control the output column widths in ODS destinations (not the output widow).

Example:

proc print data=mydataset noobs label;

var firstvar / style=[cellwidth= 1.2in];

var secondvar / style=[cellwidth= .75in];

/*etc*/

run;

And make the cell widths either long enough for you labels to fit one row or to wrap comfortably.

[VD]

Yes it should display correctly once you export it to Excel. It is appearing on two lines now just to preserve the output window space.

[PhatRam33]

Thank you everyone for the help. This is perfect =).