topic Re: How do i Calculate average GPA(numeric variable) for seat locations(categorical variable) in SAS Studio

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

nikky — Wed, 18 Sep 2019 18:22:04 GMT

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 — Wed, 18 Sep 2019 18:31:16 GMT

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 — Wed, 18 Sep 2019 20:53:30 GMT

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?