BookmarkSubscribeRSS Feed
Radhi
Calcite | Level 5

Hello

Before running an aggregation of data(passing from individual observation to groups ones one should use some test.Whould you mind inform about command to do those tests(if they exist) and the command related to the aggregation command itself

Thank you

2 REPLIES 2
art297
Opal | Level 21

Two of the procs you can use to aggregate data are proc summary and proc sql.

I'm not familiar with any related test unless you are considering doing something like factor analyses, cluster analyses, multidimensional scaling, decision trees, neural nets and/or a reliability analysis.

PGStats
Opal | Level 21

You don't give much detail about the type of problem you are working on but the following may be of general help.

Think about what information will be lost when aggregating your data. For example, say you are summarizing some measure (e.g. blood pressure) for groups of people. The summary value will not contain any information about the effect of sex, age, social status, time of day, etc. So, you must either accept to loose that information or test that it is unrelated to blood pressure, at least, within your groups. You may test for the presence of such effects prior to aggregation with an analysis of variance, of which there are several flavours available in SAS, i.e. PROC GLM, PROC MIXED, PROC GENMOD and many others.

PG

PG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Discussion stats
  • 2 replies
  • 1165 views
  • 0 likes
  • 3 in conversation