Creating datasets based on where filter

[shikpop]

I would like to create a new dataset for a different value in where.
For Example
I have data for 11 managers and I would like a seperate dataset for each manager
How do I accomplish a new table for a different name of the manager in where clause of proc sql

[Reeza]

The general concensus for such a request, is don't do it. SAS provides many methods for dealing with grouped data. No one usually listens though. 

https://blogs.sas.com/content/sasdummy/2015/01/26/how-to-split-one-data-set-into-many/

---

@shikpop wrote:
I would like to create a new dataset for a different value in where.
For Example
I have data for 11 managers and I would like a seperate dataset for each manager
How do I accomplish a new table for a different name of the manager in where clause of proc sql

---