I believe the usual reply when someone asks for help with homework is: please give it a try first, on your own, and if you get stuck, please come back and show us the code you have created, and we will be happy to help.
Also, please answer the question from @Reeza
I believe the usual reply when someone asks for help with homework is: please give it a try first, on your own, and if you get stuck, please come back and show us the code you have created, and we will be happy to help.
Also, please answer the question from @Reeza
So your course has likely either taught you one of two methods - using a data step to calculate averages or proc means/summary/univariate. Which topic has been covered so far? Then google that term plus summary to find many, many examples and questions of this nature.
@Mandy5 wrote:
Data..
Dataset xyz;
Input ID$ month checking expense;
Data lines;
X 2020/9 300 100
X. 2020/10 400 .
X 2020/11 . 60
Y 2020/9 400 .
Y 2020/10 200 50
Z 2020/19 . .
;
Run;
Result should be like this..
ID Monthsnum Average_ check averageexlense
X 3 350 80
Y 2 300 50
Z 1 . .
Any help would be greatly appreciated. I am beginner to sas programming. Proc sql is not allowed to use.
Thank you!!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.