topic Re: SQL and HASH in SAS Programming

SQL and HASH

GPatel — Sun, 03 Sep 2017 21:40:05 GMT

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;

Re: SQL and HASH

LinusH — Sun, 03 Sep 2017 21:53:15 GMT

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?

Re: SQL and HASH

art297 — Sun, 03 Sep 2017 22:29:36 GMT

@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

Re: SQL and HASH

LinusH — Mon, 04 Sep 2017 10:14:23 GMT

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