topic Re: Hi all, calculating average of observations and create a new variable. in SAS Programming

Hi all, calculating average of observations and create a new variable.

Mandy5 — Sat, 08 Oct 2022 10:56:58 GMT

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!!!

Re: Hi all, calculating average of observations and create a new variable.

HB — Tue, 11 Oct 2022 21:12:55 GMT

Proc SQL is not allowed? So this is homework?

Re: Hi all, calculating average of observations and create a new variable.

Reeza — Tue, 11 Oct 2022 21:43:07 GMT

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!!!

Re: Hi all, calculating average of observations and create a new variable.

Mandy5 — Wed, 12 Oct 2022 11:35:58 GMT

Yes, this is part of homework:)

Re: Hi all, calculating average of observations and create a new variable.

PaigeMiller — Wed, 12 Oct 2022 11:40:41 GMT

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

Re: Hi all, calculating average of observations and create a new variable.

Mandy5 — Thu, 13 Oct 2022 00:41:19 GMT

Thank you!
I tried but couldn’t get it.. took help from friend and got it.. thank you for replying:))

Re: Hi all, calculating average of observations and create a new variable.

Mandy5 — Thu, 13 Oct 2022 00:43:29 GMT

Yes, we have learned using proc means and summary.. haven’t learned about sql yet. Thank you!