03-01-2016 09:23 PM
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.
03-01-2016 10:40 PM
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.