BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
steeleye
Fluorite | Level 6

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:

steeleye_0-1606863842602.png

 

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

steeleye_1-1606863888940.png

 

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

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

 

 

View solution in original post

5 REPLIES 5
ballardw
Super User

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.

Reeza
Super User
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.
steeleye
Fluorite | Level 6

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;

ballardw
Super User

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.

 

 

steeleye
Fluorite | Level 6
Thank you for this @ballardw, it worked great!

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 661 views
  • 0 likes
  • 3 in conversation