topic Re: Formatting Column Names in Output in SAS Programming

Formatting Column Names in Output

PhatRam33 — Wed, 13 Feb 2013 22:20:25 GMT

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.

Re: Formatting Column Names in Output

Reeza — Wed, 13 Feb 2013 22:29:52 GMT

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.

Re: Formatting Column Names in Output

PhatRam33 — Wed, 13 Feb 2013 22:33:19 GMT

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.

Re: Formatting Column Names in Output

Reeza — Wed, 13 Feb 2013 23:18:34 GMT

Exactly.

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

Re: Formatting Column Names in Output

ballardw — Thu, 14 Feb 2013 00:06:29 GMT

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.

Re: Formatting Column Names in Output

VD — Thu, 14 Feb 2013 09:50:28 GMT

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.

Re: Formatting Column Names in Output

PhatRam33 — Thu, 14 Feb 2013 16:28:21 GMT

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