SAS Excel Addin

[DipeshGupta]

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..??

[Reeza]

Is SAS on the server?

Are the results being displayed in Excel as well?

[DipeshGupta]

Yes,

Yes results are displayed

[Reeza]

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. 

[DipeshGupta]

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

[Kurt_Bremser]

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

[DipeshGupta]

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