<div>
Here's an example of a stored procedure to page large tables or data sets that you could use to &quot;page&quot;(create) your record sets (#temp tables for instance ) each having 800 records by whatever criteria you need.<br />
<br />
<a href="http://www.mssqltips.com/sqlservertip/1699/sql-server-stored-procedures-to-page-large-tables-or-queries/" rel="ugc">http://www.mssqltips.com/sqlservertip/1699/sql-server-stored-procedures-to-page-large-tables-or-queries/</a>
</div>


Here's an example of a stored procedure to page large tables or data sets that you could use to "page"(create) your record sets (#temp tables for instance ) each having 800 records by whatever criteria you need.

http://www.mssqltips.com/sqlservertip/1699/sql-server-stored-procedures-to-page-large-tables-or-queries/ [http://www.mssqltips.com/sqlservertip/1699/sql-server-stored-procedures-to-page-large-tables-or-queries/]

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I am creating over 30 output files &nbsp;from an input file. &nbsp;Every 800 records I need to create another file. &nbsp;Does anyone know of a way to loop through the file either in a data step or Proc Sql to create the output file based on the _n_ value of the input?
</div>
</div>


Experts,

I am creating over 30 output files  from an input file.  Every 800 records I need to create another file.  Does anyone know of a way to loop through the file either in a data step or Proc Sql to create the output file based on the _n_ value of the input?

Creating over 32 output datasets in SAS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.