topic Re: Modifying Column Name Properties in a Table in SAS Programming

Modifying Column Name Properties in a Table

steeleye — Tue, 01 Dec 2020 23:07:35 GMT

Hello!

I am currently trying to display statistical data in a table for a series of ANOVA tests. Per the instructions from our professor, we are being asked to display the column labels at the bottom of the row, such as:

However, it seems like SAS automatically positions the labels to the top of the row. So, my table is displaying as:

How can I format the table so "Variable" and "P-Value" are positioned at the bottom of the row?

Thank you!

Re: Modifying Column Name Properties in a Table

ballardw — Tue, 01 Dec 2020 23:23:49 GMT

You need to show the code you are currently using to display the table before we can suggest any modifications.

Post code by copying from your editor and pasting into a code box opened with either the </> or "running man" icons at the top of the message box.

Re: Modifying Column Name Properties in a Table

Reeza — Tue, 01 Dec 2020 23:25:19 GMT

For default output from a proc that would be a pain.

If you're displaying your own tables, then you can control it a bit more. Please expand on what your requirements are in detail.

Re: Modifying Column Name Properties in a Table

steeleye — Thu, 10 Dec 2020 16:28:04 GMT

Here is the code I am currently using to generate the table, where ANOVAResuts contains variables Dependent FValue ProbF.

TITLE1 "Analysis of Variance Results";
FOOTNOTE1 "Created by Name";
PROC PRINT DATA = ANOVAResults
LABEL
SPLIT = '/'
OBS = 'Variable';
VAR Dependent FValue ProbF;
LABEL Dependent = 'Variable/Name'
FValue = 'F/Statistic'
ProbF = 'P-Value';
RUN;

TITLE;
FOOTNOTE;

Re: Modifying Column Name Properties in a Table

ballardw — Tue, 01 Dec 2020 23:48:07 GMT

You will need to provide a style override that looks like:

Var Dependent FValue ProbF / style=[vjust=bottom];

This is if you want to provide exactly the same style overrides to all the variables.

You can use a separate Var statement for different variables to provide different overrides. The order of the columns would be left to right from the order of the Var statements from top to bottom.

Re: Modifying Column Name Properties in a Table

steeleye — Tue, 01 Dec 2020 23:57:49 GMT

Thank you for this @ballardw, it worked great!