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

SAS DI Studio Custom Transformation Help

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

SAS DI Studio Custom Transformation Help

[ Edited ]
 

Accepted Solutions
Solution
‎12-13-2017 05:04 AM
Super User
Posts: 5,852

Re: SAS DI Studio Custom Transformation Help

Posted in reply to illusoryduck
I can't grasp the whole scenario in detail but is sounds like that each step could be preformed by other standard transformations.
Again, the join part is not a good fit for a user written transformation.
Data never sleeps

View solution in original post


All Replies
Super User
Posts: 5,852

Re: SAS DI Studio Custom Transformation Help

Posted in reply to illusoryduck
Well macro is the direction. But without writing the actual code for you...bu it will involve analysing how many input tables you have, and perform various %do loops for joining criteria.
But, building a macro for joining various no of input table is signalling to me at least that there perhaps is not much reusability here. Why not use the standard Join transformation?
Data never sleeps
Solution
‎12-13-2017 05:04 AM
Super User
Posts: 5,852

Re: SAS DI Studio Custom Transformation Help

Posted in reply to illusoryduck
I can't grasp the whole scenario in detail but is sounds like that each step could be preformed by other standard transformations.
Again, the join part is not a good fit for a user written transformation.
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 219 views
  • 1 like
  • 2 in conversation