topic Re: Why numbers are not getting grouped? in New SAS User

Why numbers are not getting grouped?

POOJA_J — Mon, 16 Oct 2023 12:01:59 GMT

Writing the above code, I expected the result to be grouped by my first variable name i.e bankid. But it's grouping on Marital status which is 2nd variable. Plz explain why its not getting grouped by bankid though it's written as 1st variable in group by!

Re: Why numbers are not getting grouped?

PaigeMiller — Mon, 16 Oct 2023 12:05:00 GMT

Maybe you want a different ORDER BY statement?

Re: Why numbers are not getting grouped?

POOJA_J — Mon, 16 Oct 2023 12:33:25 GMT

The code and the result generated in correct, it gives exact ans while solving MCQ's but I didn't understand the logic that even after writing bankid first in the GROUP BY statement, the table is getting grouped by marital status first and then within the marital status the bankid is getting grouped.

I was assuming the marital status to be grouped within the bankid.

There is my confusion.

Re: Why numbers are not getting grouped?

PaigeMiller — Mon, 16 Oct 2023 12:58:19 GMT

Your ORDER BY statement groups the data by descending COUNT, that's what is happening. That's the order of the output data. If you want some other order, you need a different ORDER BY statement. The GROUP BY statement does not determine the order of the output data.

Re: Why numbers are not getting grouped?

POOJA_J — Mon, 16 Oct 2023 13:01:02 GMT

Great its solved now. Thanks for explaining.