topic Re: Best Proc SQL book in SAS Software for Learning Community

Best Proc SQL book

Minku — Sun, 19 Dec 2021 10:30:55 GMT

Hello All,

I'm interested to learn "PROC SQL". Please suggest one best book.

Thanks,

Re: Best Proc SQL book

FreelanceReinh — Sun, 19 Dec 2021 10:47:13 GMT

I recommend Howard Schreier's excellent book PROC SQL by Example: Using SQL within SAS® (from which I learned it), especially if you already know some DATA step programming.

Re: Best Proc SQL book

Reeza — Sun, 19 Dec 2021 18:43:35 GMT

The basics of SQL are the same across many languages.

I would try this tutorial first and then learning a SAS specific version.

https://www.w3schools.com/sql/

And this paper covers the basics

https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/257-30.pdf

There is rarely "one best book"

Re: Best Proc SQL book

Minku — Mon, 20 Dec 2021 07:15:02 GMT

Thank you 🙂

Re: Best Proc SQL book

Minku — Mon, 20 Dec 2021 07:15:44 GMT

Thank you

Re: Best Proc SQL book

PeterClemmensen — Mon, 20 Dec 2021 07:24:47 GMT

I can recommend PROC SQL: Beyond the Basics Using SAS by @KirkLafler 🙂

Re: Best Proc SQL book

KirkLafler — Mon, 20 Dec 2021 11:02:58 GMT

Thank you, Peter!

Re: Best Proc SQL book

sureshn208 — Wed, 12 Jan 2022 21:20:54 GMT

@KirkLafler are there any new edition expected for this Book ? Or it already cover all the latest techniques .