How do i Calculate average GPA(numeric variable) for seat locations(categorical variable)

[nikky]

I will like to calculate average GPA(numerical variable) for seat locations(categorical variable).

How can i set this up in SAS. Am making use of an imported data.

[novinosrin · Accepted solution]

Hello @nikky  Do you have a imported SAS dataset?

If yes, 

1. Have you looked at descriptive stats procedures like proc summary,means etc?

2. If you want SQL, have you looked at functions like mean/avg ?

[ballardw]

What does your existing data look like?

Very likely proc summary with seat as CLASS variable (or By variable) will work if you need a data set.

Procs Report or Tabulate will create report for people to read.

So, which do you need?