Altair slc enhanced autoexec file and ultraedit insert text

Roger DeAngelis_21630

Altair slc enhanced autoexec file and ultraedit insert text;

Too long to post here, see github

github
https://github.com/rogerjdeangelis/utl-altair-slc-enhanced-autoexec-file-and-ultraedit-insert-text

CONTENTS

1 ENHANCED AUTOEXEC (file in this repo)

Added pesistent work library, so tables can persist between ultraedit program submissions.

Added enhanced options that no longer requires &_init_

Added handy macro variables


Whats happening


  1 The autoexec is run everytime you submit your code in ultraedit

    Normally this deletes the work directory,


  2 The enhanced autoexec assigns am additional persistent 'work' library

    libname workx wpd "d:/wpswrkx"

    This library and all its contents will be available next time submit your code.


  3 If you want to clear the contents of 'd:/wpswrk' just run this

    proc datasets lib=workx kill;

    run;quit;


  4 all the handy macro variables are assigned.

2 KEY MAPPING TO INSERT TEXT IN ULTRAEDIT (unfortunately, the SLC does not support sqlite passthru? )

Mapped the following code to keys alt + f4


 options set=RHOME "D:\d451";

 proc r;

 export data=class r=class;

 submit;

 library(sqldf)

 options(sqldf.dll = "d:/dll/sqlean.dll")

 table=sqldf('

    select

      *

    from

      class')

 print(table);

 endsubmit;

 import data=table r=table;

 run;

 quit;