Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Difference between data columns

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 02-12-2019 03:06 AM
(1035 views)

Hello

I am asking for your help,

I have 5 continuous variables while each of it has 5 categories.

For example, a variable of the "firm age" has five existing categories such as an observation can be shown only in one category.

Or a variable of "firm size" has also 5 categories and a single observation can only be in one of the existing categories.

My question - what are the statistical ways for checking the difference between the categories (columns)? F test is the only way?

Thanks for your help

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

@Kurt_Bremser thanks for your reply.

I hope that my following sample will be clearer.

I have the following data:

Firm stages | |||||

variables / stages | 1 | 2 | 3 | 4 | 5 |

Sales Growth (%) | 6 | 11 | 4 | 2 | -3 |

Firm Age | 30 | 33 | 34 | 34 | 30 |

Debts / T. assets (%) | 60 | 62 | 55 | 57 | 51 |

These figures are based on 5000 observations.

The variables figures are means in each firm stage.

There are criterions for each firm stage and the variables figures are divided into the firm stages by these criteria.

I want to check if there is a statistical significance between the firm stages means.

I believe I can check every 2 stages with the t-test, but I wonder if there is any other way to check it?

Thanks a lot for your remarks

Have a nice day

Yael

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I want to check if there is a statistical significance between the firm stages means.

You can't do this with the data as presented. You need some estimate of the standard deviations in order to perform statistical tests.

--

Paige Miller

Paige Miller

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

DATA

STEP

WITH

DATALINES.

Please.

What you posted tells us __NOTHING__ about the structure and attributes of your dataset.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Thanks a lot! Yael

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

It's really unclear what you are saying, as as suggested above by @Kurt_Bremser, providing a portion of your actual data, and an example of the desired output, would make this whole situation clear. Specifically:

I have 5 continuous variables while each of it has 5 categories.

This sentence really is hard to decipher. Continuous variables cannot have 5 categories.

My question - what are the statistical ways for checking the difference between the categories (columns)? F test is the only way?

What difference are you referring to? What statistic? Difference in means? Difference of standard deviations? Difference in distributions?

What variable are we looking at to find a difference?

--

Paige Miller

Paige Miller

**SAS Innovate 2025** is scheduled for May 6-9 in Orlando, FL. Sign up to be **first to learn** about the agenda and registration!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.