topic Re: Group by and Sum only if value greater than a specific value in SAS Programming

Group by and Sum only if value greater than a specific value

ankush23 — Thu, 25 Aug 2016 19:19:29 GMT

I have the below sample datalike

Product	Subsidiary	Stores	Sales
Boot	Addis Ababa	12	$29,761
Men's Casual	Addis Ababa	4	$67,242
Men's Dress	Addis Ababa	7	$76,793
Sandal	Addis Ababa	10	$62,819
Slipper	Addis Ababa	14	$68,641
Sport Shoe	Addis Ababa	4	$1,690
Women's Casual	Addis Ababa	2	$51,541
Women's Dress	Addis Ababa	12	$108,942
Boot	Algiers	21	$21,297

I want to Group by data basis the Product but only for Subsidiaries where count of stores is > 10. Then I want Group by of Product with count of such store and total sales from such Products (where store count is >10).

How to do this in SAS?

Re: Group by and Sum only if value greater than a specific value

Reeza — Thu, 25 Aug 2016 19:24:05 GMT

WHERE Stores > 10

This can be added to a SQL or PROC or Data step query. Which one are you intending to use?

Re: Group by and Sum only if value greater than a specific value

ankush23 — Thu, 25 Aug 2016 19:48:28 GMT

Hi,

I want to add this to the Proc SQL

Re: Group by and Sum only if value greater than a specific value

ankush23 — Thu, 25 Aug 2016 19:49:56 GMT

HI Reeza I want to add this inside the Proc Sql code

Re: Group by and Sum only if value greater than a specific value

Reeza — Thu, 25 Aug 2016 19:53:33 GMT

Then add the line after your FROM statement.

Re: Group by and Sum only if value greater than a specific value

ankush23 — Thu, 25 Aug 2016 20:42:01 GMT

Thank you Reeza,

Its working, I got the mistake I was doing. Was adding where statement after Group By.

Thanks a lot

Regards

Ankush