I have a rather simple question with regard to DI Studio. When I am editing SAS code in a User Written Transformation I would like to directly insert a comment line containing Date, Time and some fixed text using a keyboard shortcut. I have defined a keyboard shortcut for this in Enterprise Guide using editor macros, but I cannot find a comparable functionality in DI Studio. Maybe I didn't look well enough or maybe you have another idea on how to achieve this.
... View more
Thanks for the responses. In our specific case we wouldn't be worried about file locking etc. because we are actually working on a temporary file, specific for a user and a specific selection of data, which is then later incorporated in an overall file. But as said it is no problem to have the user press the edit button, it is just good to know that we don't have to look for the option as it is not available. There are so many possibilities to interact with the add-in that you can easily miss a possibility when looking for it. Thanks
... View more
You want to look for parameterized job. You map the values from your control table to macro variables that you can resolve in your specific job. And then you define your metadata object (SAS file = SAS table?) using the macro variable as part of the physical name.
http://documentation.sas.com/?docsetId=etlug&docsetTarget=p0vak6rd3mdyxhn100mrlh4jzg2b.htm&docsetVersion=4.903&locale=en
... View more