08-25-2016 03:19 PM
I have the below sample datalike
|Men's Casual||Addis Ababa||4||$67,242|
|Men's Dress||Addis Ababa||7||$76,793|
|Sport Shoe||Addis Ababa||4||$1,690|
|Women's Casual||Addis Ababa||2||$51,541|
|Women's Dress||Addis Ababa||12||$108,942|
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?
08-25-2016 04:42 PM
Thank you Reeza,
Its working, I got the mistake I was doing. Was adding where statement after Group By.
Thanks a lot
Need further help from the community? Please ask a new question.