Sum variables within unique IDs

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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 RM6
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;

View solution in original post


All Replies
Super User
Posts: 21,546

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 RM6
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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 156 views
  • 2 likes
  • 3 in conversation