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

[ankush23]

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?

[Reeza]

WHERE Stores > 10

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

[ankush23]

Hi,

I want to add this to the Proc SQL

[ankush23]

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

[Reeza · Accepted solution]

Then add the line after your FROM statement.

[ankush23]

Thank you Reeza,

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

Thanks a lot

Regards

Ankush