topic Re: SAS Excel Addin in SAS Enterprise Guide

SAS Excel Addin

DipeshGupta — Sat, 12 Aug 2017 04:29:28 GMT

i have a SAS stored process program which runs fine but the problem is when I run it directly through SAS then it takes less time as compared to when it is run through VBA using Excel Add in.

Any speific reason for that..??

Re: SAS Excel Addin

Reeza — Sat, 12 Aug 2017 04:54:49 GMT

Is SAS on the server?

Are the results being displayed in Excel as well?

Re: SAS Excel Addin

DipeshGupta — Sat, 12 Aug 2017 05:01:51 GMT

Yes,

Yes results are displayed

Re: SAS Excel Addin

Reeza — Sat, 12 Aug 2017 05:04:19 GMT

Then likely the download time needs to be added. You're seeing the results but I bet it's the transfer to Excel(local computer) that takes the time. You can add some timers and check where the difference in time for your process occurs.

Re: SAS Excel Addin

DipeshGupta — Sat, 12 Aug 2017 05:05:49 GMT

How can I stop the transfer of results so that some of the time taken is saved

Re: SAS Excel Addin

Kurt_Bremser — Sat, 12 Aug 2017 05:25:37 GMT

If you don't need all the results, then why are you outputting them? Add a prompt to control what outputs are created.

Re: SAS Excel Addin

DipeshGupta — Sat, 12 Aug 2017 08:03:17 GMT

I want the output to be created for other purpose but dont want them to be displayed in excel.

I have even untick the option of Automatic output in the tools option in SAS Excel Add in