Adding Having clause inside Extract node without adding it inside the ...

kmdsas · Posted 02-11-2016 03:59 AM

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!

LinusH · Posted 02-11-2016 04:39 AM

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.

Data never sleeps

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

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

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

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

The 2025 SAS Hackathon Kicks Off on June 11!