Code Generation Mode SAS DI Studio

[jdmarshg]

I'm looking to change identical settings to child jobs within SAS DI studio.

Looking for verification regarding using a find and replace by changing the Code generation mode: to user written body.

Then doing the find an replace.

My question is that does this mode still process what is processed in Automatic mode.

Just a sanity check.

Regards,

Jonathan

[Patrick]

If you change from automatic to user written body then the initial code you get is still fully working doing the same as before. Once you change the code there is no going back to automatic mode and you loose a lot of the advantages DI Studio gives you.

I would only go for user written if you absolutely must. May be if you explain us in detail what you need to do (and why) someone can come up with an approach which doesn't require changing over to user written.

[jdmarshg]

Hey Patrick,

The reason I change to user written body is when changing code that is the same in many child jobs.

I have started incorporating includes and more parameters to try to make sure this isn't necessary but not completely.

One example is the table loader for say like 50 child jobs.

They all have expressions for x amount of columns.

Instead of copy and pasting for each child job I was looking for a solution to change that in the code by using a search and replace.

Our team is still going through a migration and we are trying to make changes as quickly as possible.

What are your thoughts?

Jonathan

[LinusH]

Not sure if I understand the concept fully, but I agree with Patrick, user written is seldom best practice, and reduces the value of your DI investment. There are many other better ways to resuse code.

• Job in job
• Smaller parmeterized jobs
• User written Transformation
• ...

[Andy90]

On the contrary, it is seldom best practice to deploy generated code to a production environment. Only in cases where inefficient use of resources is permissible - perhaps because of the lack of qualified programmers, or due to underused servers or databases (not likely, but theoretically possible) - should code that is designed to be quick and easy to produce without knowledge of programming and optimization techniques be used in production.

[jdmarshg]

Thank you guys for your input this has been very helpful.

Much appreciated.

Jonathan