SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

Reply
Contributor SYN
Contributor
Posts: 39

DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

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.

Super User
Posts: 5,256

Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

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?

Data never sleeps
Contributor SYN
Contributor
Posts: 39

Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

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

Super User
Posts: 5,256

Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

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

Data never sleeps
Super Contributor
Posts: 349

Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

Hi Syn,

Try this hope it helps...

Thanks,

Shiva

CSV.PNG

Contributor SYN
Contributor
Posts: 39

Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

Thank you Shiva. I will try this.

Ask a Question
Discussion stats
  • 5 replies
  • 349 views
  • 0 likes
  • 3 in conversation