SAS how to open the last file when using a remote connection

Question

This is an extension of this question In Base SAS, how can I automatically update Explorer?

RawFocus gives me a way to open a file, but it does not work for me, since I use rsubmit. The updated code initially did not work, but now it opens the wrong file. v3 rather v7. According to this pic.

The code I used for the hotkey is as follows:

dm 'keydef F4 "submit ''rsubmit; %nrstr(%sysrput lastDS=&syslast;) endrsubmit;''; vt rwork.%scan(&lastDS,2,.)"'; 

Any questions please let me know
J

Answer 1

If you need to separate the two keys, but the following can satisfy your needs:

 dm 'keydef F3 "submit ''%nrstr(rsubmit; %sysrput lastds=&syslast; endrsubmit;)''; "'; dm 'keydef F4 "vt r%nrstr(&lastds); "'; 

Press F3 to refresh, then F4 to open the table. This will only work if the last table is in RWORK! I am sure this can be improved with a macro.