BookmarkSubscribeRSS Feed
Calcite | Level 5


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

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.

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.



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!
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
  • 3 in conversation