Posts Tagged ‘ proc sql ’

Real-world analytics for Analytics 2013!

June 12, 2013
By

You might have seen my previous blog, where I plotted some interesting tourist attractions on a geographical map of the British Isles (which may be of interest to Analytics 2013 Conference delegates)... Well this blog uses even more powerful analytics,...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off

Proc SQL and the power of select into

May 16, 2013
By

I have referenced this paper many times. Great help in using the power of proc sql with macro variables. Great for building lists of values and dynamic code. http://www.nesug.org/Proceedings/nesug97/coders/eddlesto.pdf Syntax: SELECT object-item ... ...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off

Index tuning in SAS for high-volume transactional data

June 4, 2012
By
Index tuning in SAS for high-volume transactional data

Why use indexes in SAS? A page is the smallest I/O unit that SAS can read or write, including data set page and index file page. Index files in SAS are sorting and searching structures made by B-trees. “When an index is used to process a request,...
Read more »

Tags:
Posted in SAS | Comments Off

Use the set operator UNION in PROC SQL

May 18, 2012
By
Use the set operator UNION in PROC SQL

SQL syntax contains a few set operators, such as UNION, EXCEPT and INTERSECT. The UNION operator concatenates the results of multiple SQL queries vertically into a single table for all matching rows, which I found particularly useful in PROC SQL while...
Read more »

Tags:
Posted in SAS | Comments Off

Top 10 tips and tricks about PROC SQL

May 3, 2012
By
Top 10 tips and tricks about PROC SQL

Interestingly, I just found that the most searched keyword is PROC SQL, through the traffic analysis of my tiny blog. The reason possibly is: nowadays everybody knows SQL, more or less; then someone can do some parts of the SAS job by PROC SQL wit...
Read more »

Tags: ,
Posted in SAS | Comments Off

Go home on time with these 5 PROC SQL tips

April 24, 2012
By

How can you go home on time? Take a quick tour with these 5 tips that I was able to summarize for my students in the SAS SQL 1: Essentials class yesterday. Since they found it handy and asked if it could become a blog post, I thought I’d share
Read more »

Tags: ,
Posted in SAS | Comments Off

Jedi SAS Tricks: Some Experience Required

February 28, 2012
By

As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.”  I've always had difficulty solidly learning new programming techniques in a traditional class...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

Few of my favourite things – SAS informats

September 23, 2011
By

Australian merino wool sweaters, Russian watches, Swiss chocolate, Chinese silk blouses, Canadian country music, American sweatshirts, English knitting patterns, Californian pistachios, French muesli, Egyptian bracelets, Scottish kilts, the list goes o...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.