Posts Tagged ‘ proc sql ’

Fast SQL moving average calculation without windowing functions

May 11, 2015
By
Fast SQL moving average calculation without windowing functions

In this post, I show a trick to do moving average calculation (can be extended to other operations requiring windowing functions) that is super fast.

Often, SAS analysts need to conduct moving average calculation and there are several options by the order of preference:

1. PROC EXPAND
2. DATA STEP
3. PROC SQL

But many...
Read more »

Tags: ,
Posted in SAS | Comments Off

How to split one data set into many

January 26, 2015
By
How to split one data set into many

Back in the day when the prison system forced inmates to perform "hard labor", folks would say (of someone in prison): "He's busy making little ones out of big ones." This evokes the cliché image of inmates who are chained together, forced to swing a chisel to break large rocks

The post Read more »

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

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

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.