topic Re: Average in New SAS User

Average

nhev — Wed, 07 Jul 2021 22:57:36 GMT

1)How to calculate average using proc summary by cars and road? Then use the summary to calculate the average of customers who applied for open market cars for a debt consolidation.

2)Then merge that average with another average. Decide which field to merge on.

Re: Average

Reeza — Wed, 07 Jul 2021 23:04:49 GMT

Only the first part of your first question makes sense. The rest does not - remember we literally only see exactly what you post not your homework assignment so have no idea what you mean by 'Then use the summary to calculate the average of customers who applied for open market cars for a debt consolidation.'

Either ask very specific questions (How do I calculate the average mpg_city for the sashelp.cars data set for each Origin), or more generic questions (How to calculate an average for each group in a data set)

Re: Average

nhev — Wed, 07 Jul 2021 23:16:40 GMT

Sorry the second question just meant use the average you just calculate and another average from another question and merge them together using 2 different variables roads and cara and also the method they used to apply debt consolidation and the question asking you to decide which average to merge first

Re: Average

Reeza — Thu, 08 Jul 2021 02:10:39 GMT

The "order" of a merge shouldn't matter unless you're filtering.

Why do you think it matters? Does doing it different ways give you different results?

The fastest way to answer some of these types of questions is to try them both and see what works.

@nhev wrote:
Sorry the second question just meant use the average you just calculate and another average from another question and merge them together using 2 different variables roads and cara and also the method they used to apply debt consolidation and the question asking you to decide which average to merge first

Re: Average

PaigeMiller — Thu, 08 Jul 2021 10:24:23 GMT

Hello, @nhev, you have been asked to clarify and provide more detailed information. We really can't move forward without this information.

Re: Average

nhev — Thu, 08 Jul 2021 10:42:28 GMT

It’s just a requirement of the question choosing what to merge first

Re: Average

nhev — Thu, 08 Jul 2021 10:43:48 GMT

@Paige do you know by any chance how to use KEEP statement in SQL?

Re: Average

Kurt_Bremser — Thu, 08 Jul 2021 10:56:46 GMT

SQL does not have a KEEP statement or clause, but you can use the KEEP= dataset option on incoming and outgoing datasets.

In most cases, this is not needed, as you define the variables to be kept/created in the SELECT clause/statement.

Re: Average

nhev — Thu, 08 Jul 2021 11:05:05 GMT

Thank you very much

Re: Average

nhev — Thu, 08 Jul 2021 11:13:38 GMT

What about RENAME in sql?

Re: Average

nhev — Thu, 08 Jul 2021 11:14:40 GMT

How can I calculate the aversion in a proc sql using group by statement?

Re: Average

nhev — Thu, 08 Jul 2021 11:15:20 GMT

How can I calculate the average in a proc sql using group by statement?

Re: Average

PaigeMiller — Thu, 08 Jul 2021 11:18:47 GMT

@nhev wrote:
@Paige do you know by any chance how to use KEEP statement in SQL?

So far, one other person and myself have asked you to explain the problem in more detail. You are just going to ignore this request; and this is not a good way to get help on your problem. The people in this forum provide excellent help, but we can't help if you don't explain further.

Also, when the original problem talks about PROC SUMMARY and then you switch to SQL without providing a reason, then we are further confused. Again, confusing us is not a good way to get help.

Re: Average

Kurt_Bremser — Thu, 08 Jul 2021 11:19:40 GMT

@nhev wrote:
How can I calculate the average in a proc sql using group by statement?

Simple:

proc sql;
create table want as
  select
    sex,
    avg(age) as avg_age
  from sashelp.class
  group by sex
;
quit;

Re: Average

nhev — Thu, 08 Jul 2021 11:20:13 GMT

It is just two different questions so I just didn’t switch from sql to proc summary but Thank you

Re: Average

Kurt_Bremser — Thu, 08 Jul 2021 11:20:22 GMT

@nhev wrote:
What about RENAME in sql?

Same as KEEP.

Re: Average

ballardw — Thu, 08 Jul 2021 16:06:19 GMT

@nhev wrote:
How can I calculate the aversion in a proc sql using group by statement?

How do you calculate an "aversion" in SQL without a group by statement? I haven't ever had to calculate an "aversion" before and haven't a clue where to start.

This forum prefers that a question relates to a single topic, or interactive topics around a process.

Adding random questions not related to a previous question we prefer to see a new thread that is easier for folks to read and follow when they find the topic from a search somewhere. Adding non-related topics to the subject line makes that harder for inexperienced SAS users to find solutions to their problems.