Solved
New Contributor
Posts: 2

# Sum variables within unique IDs

 ID DATE DIST 1 04/21/15 244 1 04/21/15 320 1 05/20/15 400 1 05/20/15 390 2 04/21/15 260 2 04/21/15 310 3 04/20/15 280 3 04/20/15 320 3 05/19/15 380 3 05/19/15 410

How can I create a dataset with an average of a variable (DIST) by ID and Date from the dataset above

The final dataset should look like the following

 ID DATE DIST 1 04/21/15 282 1 05/20/15 395 2 04/21/15 285 3 04/20/15 300 3 05/19/15 395

Accepted Solutions
Solution
‎11-26-2017 07:11 PM
Contributor
Posts: 24

## Re: Sum variables within unique IDs

try this

Proc Sql;
create table xyz as
select ID,DATE,sum(DIST) as DIST
from Data
group by ID,Date;
Quit;

All Replies
Super User
Posts: 23,343

## Re: Sum variables within unique IDs

Use PROC MEANS with the grouping variable in a CLASS or BY statement.

Here's an example:

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic

Solution
‎11-26-2017 07:11 PM
Contributor
Posts: 24

## Re: Sum variables within unique IDs

try this

Proc Sql;
create table xyz as
select ID,DATE,sum(DIST) as DIST
from Data
group by ID,Date;
Quit;
New Contributor
Posts: 2

## Re: Sum variables within unique IDs

Thanks for the solution, that pretty much solved it. I just changed SUM(DIST) to AVG(DIST) to get the average of the DIST values per DATE.

☑ This topic is solved.