Date:         Tue, 14 Feb 2006 22:34:27 -0500
Reply-To:     SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM>
Subject:      Creating Multiple Datasets from one large dataset

Hi All,

I have been trying to create multiple datasets from one large dataset
which has already been created in one permanent library. The large data
set has 1 million observations and 1000 columns.

I need to create 5 datasets from the large datgaset based upon some
selection criteria. And also, I have a complex selection criteria such as
column1 starts with "MTG", "SPS" and "GF" and "MR" are not anywhere in the
column2 etc... This selection criteria is different for each different
dataset that I need to create.

I can do this by having 5 different data steps and then use "SET" to the
large datastep. But it takes lot of time.

I also tried using PROC SQL, but I couldn't as the selection criteria for
each dataset is completely different.

Any help will be greatly appreciated.

Thanks,