# Connecting SAS to Access 2007 (.accdb)

June 4, 2010
By

Here is a working example of how to connect SAS 9.1.3 SP4 to a Microsoft Office Access 2007 .accdb data source. First, let’s use a pass through query. The file is called c:\saves.accdb and contains a table called table1. proc sql; /* create an OD...

# How To Get What You Want Out of a Data Step Merge

June 3, 2010
By

This Fall my daughter will be going to kindergarden. So like all other hyper-attentive parents we have started introducing her to the concept of homework. The other night I got out her crayons and introduced her to set theory. After about an hour I ...

# Literature and SAS: Or, How studying Melville has made me a better SAS user

I think this blog would be so much more literate, if I started it with a classic opening line, like “Call me Ishmael” or “riverrun, past Eve and Adams”. Those are the opening lines of Melville’s Moby-Dick and Joyce’s Finnegans Wake, re...

# Did you know… you can sort searches by date

June 2, 2010
By

We don't display dates on our Web pages. We used to do that. Some people felt that content was less useful if it was older. That isn't always true. support.sas.com contains some great samples that show language usage best practices. These sam...

# Boost to tackle nonlinearity

June 1, 2010
By

data nonlinear; do x=1 to 627; p=(sin(x/100)+1)*0.45; do j=1 to 100; x1=x+(j-1)/100; if ranuni(8655645)<=p then y=1; else y=0; output; drop p j; end; end; run; proc rank data=nonlinear out=nonlinearrank...

# Example 7.39: Nelson-Aalen estimate of cumulative hazard

May 31, 2010
By

In our previous example, we demonstrated how to calculate the Kaplan-Meier estimate of the survival function for time to event data. A related quantity is the Nelson-Aalen estimate of cumulative hazard. In addition to summarizing the hazard incurred ...

# Memorial Day — putting names to the numbers

May 29, 2010
By

Contributed by Dr. Robert Allison, Research & Development, SAS Memorial Day is a U.S. federal holiday to commemorate the U.S. men and women who died while in military service. My SAS graphs are often about numbers and trends — but for...

# Convert data to CSV file

May 28, 2010
By

In addition to the export file wizard and proc export (section 1.2.3 of SAS and R), SAS provides a the nifty little %ds2csv macro that can do this quickly and easily.  The advantages to this approach are that there are a few extra options and that...

# What Time Do They Roll Up the Sidewalks in Cary?

May 28, 2010
By

When you travel as much as a typical SAS instructor, you get to be an expert on hotels, restaurants and entertainment. Anyone can figure out where to eat or what to do in downtown Chicago or in Manhattan, but it takes a dedicated traveler to show...

## 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.