We’re smarter together. Learn from this collection of community knowledge and add your expertise.

How to do SQL joins in SAS University Edition

by Community Manager ‎10-09-2015 03:42 PM - edited ‎10-09-2015 03:43 PM (295 Views)

Probably the most important thing you can learn in SAS University Edition is how to work with data. And one of the most powerful tools for working with data is Proc SQL. In this blog post, SAS’ Robert Allison shows you how. RobertAllison.PNG

 

Robert has worked at SAS for more than 20 years and may be the foremost expert in creating custom graphs using SAS/GRAPH. His educational background is in Computer Science, and he holds a BS, MS, and PhD from NC State University. He is the author of several conference papers, has won a few graphic competitions, and has written a book (SAS/GRAPH: Beyond the Basics).

 

Was this post helpful? Tell us about it in the comments!

Comments
by Regular Contributor
‎10-09-2015 07:25 PM - edited ‎10-09-2015 07:25 PM

I use PROC SQL in about 80% of the SAS code I write; everything from bringing data in from my SQL Server database to cleaning, manipulating and sub-setting my data, SQL is always my first stop.  One of the big advantages for me is the ability to write the SQL in SQL Server Management Studio and then copy the SQL into SAS: with a little bit of tweaking, SAS can use that SQL.  Not only that, but SAS has added some pretty cool addtional features not available in standard SAS.  One of my favourites is the ability to use PERL for truly powerful text analytics.  I highly recommend Using PRX to Search and Replace Patterns in SAS® Programming by Hu and Zhang, found here for ideas.

 

Chris

by Valued Guide
on ‎02-17-2017 12:28 PM

I don't think much of the sql JOIN utility in University Edition Visual Programmer

by SAS Employee samdupont
on ‎02-20-2017 09:47 AM

@Peter_C  I am very interested to learn more from you about why you "don't think much of the SQL JOIN feature". Would you take a few minutes to share your frustrations or things you would like to see changed. The only way to improve something is to get data from our users so any input is incredibly helpful.

 

Thx. 

by Valued Guide
on ‎02-20-2017 01:29 PM
A problem of some sort.... either my navigation through the query or something below the user layer..... So I posted... see
https://communities.sas.com/t5/SAS-Studio/visual-programmer-QUERY-in-SAS-Studio-ue/m-p/334218#M1897
Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.