topic Re: Sum variables within unique IDs in SAS Programming

Sum variables within unique IDs

DrLoreto — Fri, 24 Nov 2017 06:11:02 GMT

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

Reeza — Fri, 24 Nov 2017 06:53:38 GMT

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

Here's an example:

RM6 — Fri, 24 Nov 2017 09:18:51 GMT

try this

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

DrLoreto — Mon, 27 Nov 2017 00:15:11 GMT

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.