Hi - Apologies if this isn't in the relevant forum or question not worded clearly as am my SAS knowledge is fairly basic:
I have a frame that runs a standard piece of code over any file I have created that has all the relevant variables on it. In practice, this means I run the .sas code to produce my factor file and then open the frame, type in the file's name and some dates and then hit run to kick off the SCL code in the frame.
What I'd like to do is to automate this so that within my frame, I can enter the location of the .sas code I wish to run, have the frame open that code and run it and when it has finished automatically move on to the rest of the SCL code that runs when I press run now.
At the moment, my ugly solution is to run the code in one SAS session, open the frame in a 2nd session with a line of code that sets it to wakeup at a defined time later in the morning.
I have found the following way of opening up a list of external files in the frame and getting that filename in the textbox but am stumped as to how I could have the SCL open the code saved at that location and run it within the frame. Anyone know if its possible and able to give any guidance?
*---------------------------------------------*;
* Initialize SCL Variables *;
*---------------------------------------------*;
INIT:
*** Maximize the window ***;
call execcmd('ZOOM ON');
*** Populate text box with initial value ***;
txt_SasProg.text = "Click on the Choose Program button.";
RETURN;
*---------------------------------------------*;
* Select PC File to Submit *;
*---------------------------------------------*;
SELECT:
*** Open File Dialog box to choose program ***;
rc=filedialog('open',selfile,'','/sas','*.sas');
*** Set value of text box to selected file ***;
txt_SasProg.text = selfile;
RETURN;
Again, sorry if my explanation is confusing! Thanks in advance for reading and any help you can offer.
Cheers, Mike
... View more