https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6713#M691 We get the data from ODIN (oracle database) using proc sql. It got 20M records and indexed by 'acct_id'. I need to pull all the records and I'm forced to not to query them all with a single query for some reasons (memory limitation so on) <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /> <BR /> What's the best way to get all the data with, let's say, 20 queries. Ideally, I want to set up a macro program and call it 20 times. I thought if I know the acct_ids for the 1Mth, 2Mth,..., and 19Mth record, then I can condition it on them. Now, the problem is how do I even get those acct_ids using queries?<BR /> <BR /> I was also trying to use 'rownum' and the following conditon does not work here:<BR /> //where rownum between 2 and 10//<BR /> <BR /> Is there any standard solution for big queries? <BR /> <BR /> Thanks.<BR /> <BR /> -Nilan Fri, 01 Feb 2008 20:59:03 GMT deleted_user 2008-02-01T20:59:03Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6713#M691 We get the data from ODIN (oracle database) using proc sql. It got 20M records and indexed by 'acct_id'. I need to pull all the records and I'm forced to not to query them all with a single query for some reasons (memory limitation so on) <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /> <BR /> What's the best way to get all the data with, let's say, 20 queries. Ideally, I want to set up a macro program and call it 20 times. I thought if I know the acct_ids for the 1Mth, 2Mth,..., and 19Mth record, then I can condition it on them. Now, the problem is how do I even get those acct_ids using queries?<BR /> <BR /> I was also trying to use 'rownum' and the following conditon does not work here:<BR /> //where rownum between 2 and 10//<BR /> <BR /> Is there any standard solution for big queries? <BR /> <BR /> Thanks.<BR /> <BR /> -Nilan Fri, 01 Feb 2008 20:59:03 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6713#M691 deleted_user 2008-02-01T20:59:03Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6714#M692 Hi:<BR /> You may want to consult with Tech Support. This is a big enough file that you need a data-specific and database-specific solution. And also, once you create your various BIG files, there may be efficiency considerations to take into account when you are doing subsequent processing or analysis with SAS.<BR /> <BR /> To contact Tech Support, go to <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> and in the left-hand navigation pane, click on the link entitled "Submit a Problem".<BR /> <BR /> cynthia Fri, 01 Feb 2008 22:29:29 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6714#M692 Cynthia_sas 2008-02-01T22:29:29Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6715#M693 Hi Cynthia,<BR /> <BR /> I'll do that. <BR /> <BR /> Thanks for the direction. <BR /> <BR /> -Nilan Mon, 04 Feb 2008 14:18:27 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-get-the-acct-id-of-the-1-000-000th-record-from-a-table/m-p/6715#M693 deleted_user 2008-02-04T14:18:27Z