topic Re: Code Generation Mode SAS DI Studio in SAS Programming

Code Generation Mode SAS DI Studio

jdmarshg — Fri, 17 Jan 2014 23:45:51 GMT

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

Re: Code Generation Mode SAS DI Studio

Patrick — Sat, 18 Jan 2014 00:25:06 GMT

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.

Re: Code Generation Mode SAS DI Studio

jdmarshg — Wed, 22 Jan 2014 15:49:40 GMT

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

Re: Code Generation Mode SAS DI Studio

LinusH — Thu, 23 Jan 2014 12:44:34 GMT

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
...

Re: Code Generation Mode SAS DI Studio

Andy90 — Thu, 23 Jan 2014 16:19:01 GMT

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.

Re: Code Generation Mode SAS DI Studio

jdmarshg — Thu, 23 Jan 2014 17:19:32 GMT

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

Much appreciated.

Jonathan