Creating datasets based on where filter

shikpop — Mon, 19 Nov 2018 19:04:46 GMT

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

Re: Creating datasets based on where filter

Reeza — Mon, 19 Nov 2018 19:10:18 GMT

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

topic Re: Creating datasets based on where filter in SAS Programming

Creating datasets based on where filter

Re: Creating datasets based on where filter