LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 11 May 2009 02:25:08 -0700
Reply-To:   chumba <vikas.dharamsattu@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   chumba <vikas.dharamsattu@GMAIL.COM>
Organization:   http://groups.google.com
Subject:   breaking a large dataset into smaller ones
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset=ISO-8859-1

Hi All,

I need to break a large dataset into smaller ones.

My huge dataset has about 2 million records, I need to split them into separate ones each having 65000 records so that I can export them to individual worksheets of an excel file.

I am sure the distinguished programmers here must have faced such a problem, can someone please help me out with this.

I have a loop in place but I dont know how to restrict the loop till the last record.

I am trying to build a code which works even for those datasets for which the records are impossible to find without hanging SAS.

Any help will be greatly appreciated.

Thanks


Back to: Top of message | Previous page | Main SAS-L page