Posts Tagged ‘ Basics ’

Delete non-exact duplicates in SAS

May 12, 2011
By

When deleting non-complete duplicates in SAS, in each duplicate set you may want to keep a particular record identified by a rule: it may be the oldest, newest, first, or last observation in each set. You need a identifier to be unique, but you can&#82...
Read more »

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

C# Dictionary of US State Abbreivation to Names using SAS

April 19, 2011
By

I need C# code to convert United States state postal abbreviations (like AL) to full state names (like Alabama), but I’m afraid of making a typo retyping the abbreviation list from the USPS—and that just seems tedious. However, it’s e...
Read more »

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

Strip Non-Printable ASCII Characters (SAS)

March 30, 2011
By

Say in your SAS data set, which comes from a text file, XML, or database, has non-ASCII characters that look like garbage—perhaps an odd square. These are probably control characters that mean something to some system, but they may be useless to ...
Read more »

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

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...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

SAS: “The query requires remerging summary statistics back with the original data”

September 22, 2009
By

Coming from a background writing SQL code directly for “real” RDBMS (Microsoft SQL Server, MySQL, and SQLite), I was initially confused when SAS would give me the following ‘note’ for a simple summary PROC SQL query: 429 proc sq...
Read more »

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

Simple PROC BOXPLOT example

August 28, 2009
By

Here’s a simple PROX BOXPLOT showing how to produce Box and Whisker graphs in SAS. data presidents; input name $ cm 3.; datalines; George_W_Bush 183.1 George_W_Bush 182.9 George_W_Bush 183.3 George_W_Bush 188.3 Barrack_Obama 188.0 Barrack_Obama 1...
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.