If anyone can give me a hint on how to use sql hints in SAS ie (select /*+parallel (alias,2)*/ ...) or
ie (select /*+ use_hash (alias)*/ ...)
any help on this would be much appreciated.
Thanks in advance.
Signed
stumped SAS Guy
I upgraded to SAS 8.2 and the problem disappeared. It had something to do with a memory problem which they fixed in version 8.2 ... Thanks for taking the time to reply. I suggest the upgrade if you have not already, It seams that they have solved quite a few of my Proc SQL; dilemmas.
Here is my dilemma,
When my WORK.bn2000 table hits the IN statement in verifies that a bus_reg_nb(PK) is not in the BN2001 table. The problem is that as soon as i reference a second
table(t2_income_stmt t2_is), it gives me a shared memery address error. I need to use the 2 tables in the query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.