Date:         Fri, 29 May 2009 11:51:13 -0700
Reply-To:     Lex Jansen <lexjansen@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lex Jansen <lexjansen@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Splitting a file using Visual Basic (SAS conference paper)
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I think it's Alan Churchill's paper:

How to Generate 10,000 Excel Spreadsheets in 10 Minutes (Or Less)
(http://www2.sas.com/proceedings/forum2007/001-2007.pdf)
Alan K. Churchill (SAS Global Forum, 2007-04)
Keywords: excel ods export spreadsheet

Lex "SAS proceedings librarian" Jansen

On May 29, 10:10 am, sbuc...@SCHOOLS.NYC.GOV (Scott Bucher) wrote:
> I have a vague memory of reading a SAS conference paper that explained that
> to create many Excel files from a SAS data set it can be much more efficient
> to simply export the data set in its entirety and split it using Visual
> Basic (or perhaps some other Microsoft technology) rather than having SAS
> export the data to each workbook separately. I have searched the net and
> Lexjansen for this paper, but cannot find it. Does anyone recall the name or
> location of such a paper?
>
> Thanks,
> Scott