If you could successfully narrow it down to this, opening a track with SAS technical support is now in order.
Use the {i} button for non-SAS code, text files, logs. Use the "little running man" for SAS code.
@konnos wrote:
Thank you for your reply. I am new in this, can you please explain what is the {i} button please.
You see it on top of the main posting window, it's the 6th icon; "little running man" is the 7th.
Make sure you are in "Rich Text" mode when posting.
My other argument is still valid. Different behaviour on subsequent runs points to some uninitialized resource, where the 'null' or random value encountered in the first run is replaced with some (default?) value and causes the second and following runs to fail.
That is an observation from 4 decades of programming, not specific to VBA. I don't even touch that with a ten-yard pole, but you should review your code along this aspect. It might be that some module you use is not safe for reuse in the same context, and mandates a restart of Excel.
Software that behaves different on subsequent runs points to an uninitialized resource, where the state from the first execution carries over to the following executions.
If you could successfully narrow it down to this, opening a track with SAS technical support is now in order.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.