Slice and splice?

SQL is not well suited to this.

But why even go around this big circle? Presumably something will be done to the separate segments after they are separated but before they are reconnected. Why not apply that process to the single large dataset rather than to multiple shorter datasets? It's usually easier.

On Thu, 10 Jun 2004 15:11:17 -0400, Nicole Bibb <nicole.d.bibb@WELLSFARGO.COM> wrote:

>I have a very large dataset that needs to be broken down into small >datasets that will eventually be append after being created the first time. > >I am using proc sql to create the data primary dataset. However, I am not >sure how to break the dataset into the smaller datasets using proc sql. I >looked through the syntx but did not find anything allowing me to create >mulitple tables in the same proc sql. > >I know I can use the update statement to append the datasets when I have >them created. > >Any ideas??