topic Re: Calculate the average of X and Y by Group. in SAS Programming

Calculate the average of X and Y by Group.

sas1018 — Thu, 30 Apr 2020 04:17:18 GMT

hi I am new to sas preparing for certification.Can somebody help me with the below program:

Create 3 groups for Cvar:A-G is group=1;H-N is group=2;o-z is group=3.

All variations of the variables should be in the same group i.e "A" or "a" should be in group=1.

Calculate the average of X and Y by group.

My question is :Do i need to create new variables X and Y to calculate average?

Re: Calculate the average of X and Y by Group.

Kurt_Bremser — Thu, 30 Apr 2020 06:15:07 GMT

X and Y should already be present in your input dataset.

Re: Calculate the average of X and Y by Group.

ballardw — Thu, 30 Apr 2020 14:18:59 GMT

Existing data.

Show us what you have.

Better would be to use a small example and then the desired result for the given example.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the <> icon or attached as text to show exactly what you have and that we can test code against.

"Groups" of values within a single variable can often be done with custom format applied to the variable in a reporting or summarizing procedure.

Also, do you need a data set for output (for further analysis) or a report (people read these).

Details: does your CVAR only have one character or is it longer? Is the group based on a single variable or multiple (which is why we ask you to show an example of your data).

Re: Calculate the average of X and Y by Group.

sas1018 — Thu, 30 Apr 2020 18:43:30 GMT

I have attached my program file below.

Thank you.

Re: Calculate the average of X and Y by Group.

ballardw — Thu, 30 Apr 2020 19:50:43 GMT

Don't see any values or even variables X and Y in your program. Anywhere. So where are the values of X and Y supposed to come from. To be a "mean" there needs to be at least one numeric value to make sense of the question.

Re: Calculate the average of X and Y by Group.

Kurt_Bremser — Fri, 01 May 2020 05:46:10 GMT

You do not need to attach SAS programs as files. Copy/paste the code into a window opened with the "little running man".

Also take a little time to read the articles in the "Welcome" section on how to post questions and how to get fast, helpful answers.

Re: Calculate the average of X and Y by Group.

sas1018 — Fri, 01 May 2020 19:12:13 GMT

Thank you. Got the solution with the X and Y variables.They were already in another dataset. I thought I need to create one.Thanks a lot.

Re: Calculate the average of X and Y by Group.

sas1018 — Fri, 01 May 2020 19:13:20 GMT

Sure. From next time I will do that. Thank you.