We are running a stored proces, which is triggered from Excel (a VBA button calling the STP). This STP creates a SAS file, which is then opened in the SAS Excel add-in , to be edited by the Excel user. The user now has to manually click the "Begin Edit" button in the SAS add-in menu bar to be able to edit the data set. This works fine and is not a real problem of course, but we thought it would be nicer to open the edit mode automatically from VBA without necessary user interaction in Excel.We have been looking to find if this is possible, but have not been able to find the option to do this.   As said, no real issue but any ideas or pointers are welcome.   ... View more

I would like to use a control table (sas table) to define (part of) the name of the input file (sas table) in a DIS job.   For instance in the case where we have a large number of jobs reading year specific input files (sas files)   I would like to create a control table (containing for instance the current year 2017) and then be able to use the content of this control table to steer the inputfile name into my job. So in this case my job will start to use the INPUT_A_2017 and INPUT_B_2017 sas files as input for the job and when I change the datafield in the control file to current year 2018, it will run the same job using the INPUT_A_2018 and INPUT_B_2018 as inputfiles. Where of course these input files 2017 and 2018 have the exact same structure.   If someone could point in a direction I could be persuing to achieve this or to existing information that relates to this question that would be nice. I am trying to use as much standard transformations or user defined transformations to keep it flexible and DIS like, rather than coding it out completely. ... View more