topic Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE? in SAS Data Management

DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

SYN — Mon, 28 May 2012 09:20:22 GMT

I have a requirement in DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE.

I have SAS user written code it is using 3 input tables and creating 5 output tables.

Now I have to impliment this existing code in DATA INTEGRATION STUDIO 3.4 using USER WRITTEN CODE transformation.

Can any one help me to give me the process flow for this requirement.

How can I connect 3 input tables to SER WRITTEN CODE transformation and how can i connect 5 output tables.

LinusH — Mon, 28 May 2012 09:34:31 GMT

Well, 3.4 isn't quite flexible, and you would love to upgrade...

From the documentation 3.4 about User Written Code:

"This approach works particularly well with jobs that need quick custom code or require only one input and output and no parameters."

Since I'm on 4.21 I can't really test this, bit I think you can use the SQL Join transform, and make that "User Written".

Perhaps you can split you code logic, and use part of it in a succeeding Split transform to handle multiple outputs?

SYN — Mon, 28 May 2012 10:17:17 GMT

Thank you for your comment LinusH.

There is no other go, we need to use DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE.

Provide me exact flow for this requirement. Thanks in advance

LinusH — Mon, 28 May 2012 10:26:53 GMT

Sorry,

since I don't have 3.4 no more, It's hard to provide exact instructions.

You'll have to experiment around my guidelines...

shivas — Mon, 28 May 2012 14:28:46 GMT

Hi Syn,

Try this hope it helps...

Thanks,

Shiva

SYN — Mon, 28 May 2012 14:59:19 GMT

Thank you Shiva. I will try this.