Hi all, I have to work with datasets in the 5-10 million record range, I roll the data up as much as possible to get the datasets in the 2-3 million records range, which I currently bridge to MS Excel pivot tables via MS Access or the MS Addin (my preferred methodology). In our current environment, I can't use the scheduler in the AMO to kick the job off, and need to manually run the bridging process from SAS to Excel. My manager asked me to look into running this process using ODS. I tried using the methodology outlines by Parker in Paper 003-2010, but run out of memory before even 100,000 records transfer over.
Does anybody know how to dump 2 million plus records into Excel using ODS? Any other recommendations? Thanks for your help....