topic Adding Having clause inside Extract node without adding it inside the user written code in SAS Data Management

Adding Having clause inside Extract node without adding it inside the user written code

kmdsas — Thu, 11 Feb 2016 08:59:29 GMT

Hi everyone!

I am currently using SAS Data Integration version 4.9 for data management. Is there a way to add a having clause inside the extract node without changing the code inside the user written code tab?

Thank You in advance!

Re: Adding Having clause inside Extract node without adding it inside the user written code

LinusH — Thu, 11 Feb 2016 09:39:45 GMT

Not really, and I have asked for a having tab int the transformation...

But, you could use the SQL Join transformation for this, so it should be no brainer. Even if it's called Join, it doesn't have to be a join, just remove the second input - and for clarity, add/change the transformation description.