Posts Tagged ‘ Optimization ’

Date and datetime: accuracy vs storage and I/O costs (SAS)

March 12, 2013
By

How much storage space and I/O resources can be saved by using the LENGTH statement to shrink the storage of date and datetimes while maintaining sufficient precision? In my experience, saving I/O generally makes SAS run faster (such as in a DATA step)...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Birthday gift code puzzle

September 19, 2011
By

This is a SAS code puzzle. The code works as is, but can you make it simpler? We do this while enjoying simulation and the quirkiness of the Gregorian calendar. The problem A person receives a gift on a random day. Relative to his birthday, how many da...
Read more »

Tags: ,
Posted in SAS | Comments Off

Make SAS much faster with data set compression

August 13, 2010
By

R is fast at processing data sets, but it is limited by memory (physical RAM plus swap). SAS processes much larger data sets, but it is slow because it keeps the data sets on the hard drive. Although computer processors have become faster and memory la...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Make SAS PROC SQL UPDATE faster with CALL EXECUTE

August 6, 2010
By

I have an ETL job that updates 10,000 rows in a large, remote Microsoft SQL table with 700,000 rows (1.4%). (The specific brand of remote SQL database doesn’t matter: this should work equally well for any ODBC RDMS.) This tutorial shows two ways ...
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.