SAS BASE - Open viewtable via code in editor - Check for network error / connection time out

PegasusTT77 — Mon, 11 Dec 2023 11:13:05 GMT

Hello 😅

I have a special problem to solve.

Currently I try one way but need help but let me explain.

I have a program which includes a lot of others, saves my *.log and *.lst to my server to check for keywords. The program runs without errors or warnings BUT when I compare old data with new I recognized that there are datasets missing... Neither the VPN connection, nor the ping check, even my SAS log did not give an error but when I check the log, the program stopped without any information why and did not complete. So every time I have to check the compare manually.

Today I got an error while a viewtable was opened and I thought ... Ok, many of my issues starts there...

It would be great if I can open a viewtable automatically at the beginning of my runALL.sas program.

I found only half of the solution because that code runs only with the regular submit.

dm "vt libname.filename" ;

Source: https://www.lexjansen.com/wuss/2011/posters/Papers_Agarwal_M_74994.PDF

Regular submit means, when I just use the single "running man" but I have two "running men" which means (see screenshot) :

Does anyone have an idea to either solve my way or can provide a solution to check for connection time outs?

Re: SAS BASE - Open viewtable via code in editor - Check for network error / connection time out

ballardw — Mon, 11 Dec 2023 12:01:15 GMT

You should be able to EDIT (customize) that command to insert the viewtable command.

I see a potential problem with your desired action though. If you open a table in viewtable then it may get treated as "in use by you in another process" for code that you run.

I never bother to edit the menu though. I would suggest that you investigate creating a KEYS (window should open with F9 by default) and edit/create a key command to combine the VT and other window commands with a key stroke instead of clicking on the menu.

topic Re: SAS BASE - Open viewtable via code in editor - Check for network error / connection time out in SAS Programming

SAS BASE - Open viewtable via code in editor - Check for network error / connection time out

Re: SAS BASE - Open viewtable via code in editor - Check for network error / connection time out