08-12-2017 12:29 AM
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..??
08-12-2017 01:04 AM
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.
08-12-2017 01:25 AM
If you don't need all the results, then why are you outputting them? Add a prompt to control what outputs are created.
08-12-2017 04:03 AM
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