Posts Tagged ‘ hash object ’

Optimize many-to-one mapping by user-defined functions

March 31, 2011
By
Optimize many-to-one mapping by user-defined functions

In many occasions, fast access into a lookup table to find desired value is necessary. In computer science, linked list, associative array, and hash table are widely used to construct the relationship between values and keys. Hash function, like value...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

The efficiency of five SAS methods in multi-dataset merging

November 28, 2010
By
The efficiency of five SAS methods in multi-dataset merging

Introduction: Merging two or multiple datasets is essential for many ‘data people’. Yes, it is a dirty and routine job. Everyone wants to get it done quick and accurate. Actually, SAS has many ways to tackle this job. In two competing papers fro...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Table Look Up in SAS, practical problems

August 4, 2010
By

One guy asked in a SAS forum about a typical table look up problem: He has a data with two IDs: id1 id2 a b a e b c b e c e d e and he wants to generate a new data set with the following structure according to above...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Tweak PROC FASTCLUS for 1-Nearest Neighbor / Closest Match

September 23, 2009
By

In most table lookup tasks, we are doing EXACT matching. However, sometimes we are looking for closest match in the lookup table. By 'closest', we mean smallest Eucleadian distance: ||X-Y||2 Typically we have to manually code the search function ...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

encoding data points for use with google charts api calls

June 1, 2009
By
encoding data points for use with google charts api calls

first step, build encoding tables based on the documentation: data encSimple encEnhanced; s='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'; format raw 8. enc $8.; raw=.; enc='_'; output encSimple; enc='__'; output encEnhanced;...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

encoding data points for use with google charts api calls

June 1, 2009
By

first step, build encoding tables based on the documentation: data encSimple encEnhanced; s='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'; format raw 8. enc $8.; raw=.; enc='_'; output encSimple; enc='__'; output encEnhanced;...
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.