Desktop productivity for business analysts and programmers

Enterprise Guide Export Step

Reply
Contributor
Posts: 42

Enterprise Guide Export Step

can someone explain to me how does the EG Export step works?  not proc export, but the part where you right click a dataset (on the server) and then click export as Excel format.  this step is taking a long time if the dataset is large.  any way to improve the speed?  thanks.

Respected Advisor
Posts: 3,060

Re: Enterprise Guide Export Step

When you export via EG table viewer export, EG and your PC are reading the table from the server and then writing out the Excel workbook to the folder of your choice. You are limited to the processing ability of your PC and the speed it can read and write data across your network. There is not really much you can do to speed it up.

 

Your SAS server can do this much faster so that is the best option. Even if you don't have SAS/ACCESS to PC Files you can still export CSV's which Excel can read.

Ask a Question
Discussion stats
  • 1 reply
  • 256 views
  • 2 likes
  • 2 in conversation