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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.