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.
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?
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
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...
Hi Syn,
Try this hope it helps...
Thanks,
Shiva
Thank you Shiva. I will try this.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.