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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.