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 |
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
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.