In reality I have a SAS table having very many rows, think milions, and I want to split it into sub-tables. The reason for this is that I will export the data and those who will process it use a system that cannot process so many rows at once, so it has to be split. For clarity I will provide an demonstrative example that would solve my problems.
Assume I have a SAS table consisting of 334 rows. Now I want to split this table into 3 tables, since 334/3 is 111.3333 the function would return: - table1 consisting of 111 rows.
- table2 consisting of 111 rows.
- table3 consisting of 112 rows.
So I just say that I want 3 tables and then it puts the suitable amount of observations in each new table (111, 111 and 112 rows in this case).
Any ideas on how to achieve this?
... View more