SQL and HASH

[GPatel]

Can somebody assist me .....How following query can be translated into either SAS HASH code (preferred)

or SAS QUERY code?

Below is a given SQL NATIVE Query ( note that there is + sign in a where clause):

SELECT DISTINCT A1.acod as acode,
                               A1.descp as FDESC,
                             catx(' - ', B1.scod,B1.tcod) as stcode
FROM X X0,
           A A1,
          B B1,

          C C1

WHERE
         A1.OFFICEID(+)  = X0.officeid
AND B1.STATUSCD(+) = x0.STATUSCD 

AND C1.Post(+) = X0.Post 

AND C1.Pre(+)  = X0.Pre

AND X0.Pre(+)  = C1.Pre

AND X0.Post(+) = C1.Post

     ;

Quit;

[LinusH]

Giving you a SAS data step hash program tight will probably not help you to understand how to do it yourself next time. I suggest that you study it, give it a try, and then come back with more specific questions.

This SQL of yours, what does the + sign do/mean?

[art297 · Accepted solution]

@LinusH: I think the (+)  indicates a left or right outer join depending upon whether it is on the left or right variable (see: https://chartio.com/resources/tutorials/left-and-right-joins-using-the-plus-sign-in-oracle/ )

Art, CEO, AnalystFinder.com

[LinusH]

Oh.
Then I assume the SQL part of the question would resolve to - use LEFT/RIGHT JOIN...ON... in SAS (ANSI) SQL.