Posts Tagged ‘ Data Manipulation ’

Convert CHAR to NUM in PROC SQL

November 19, 2013
By

Use TO_NUMBER function in PROC SQL. proc sql;   connect to oracle (user=xxx orapw=yyy path="@zzz");     create table temp as       select * from connection to oracle    &nb...
Read more »

Tags: ,
Posted in SAS | Comments Off

Rolling Window Regression of Time Series

August 10, 2011
By

More often than not, we encounter a problem where an OLS over a rolling time window is required, see , , , , , , , for a few examples. One solution is to resort to SAS MACRO, but it is extremely inefficient and can't handle lar...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Regularized Discriminant Analysis

April 10, 2011
By

Demo SAS implementation of Regularized (Linear) Discriminate Analysis of J. Friedman (1989). Simpler introduction can be found at . Regularized QDA follows similarly. To save coding, I called R within SAS to finish the computation. For details...
Read more »

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

A SAS data miner without Enterprise Miner

December 13, 2010
By
A SAS data miner without Enterprise Miner

SAS Enterprise Miner (EM) is indeed a fancy tool for a SAS programmer who wants to switch to the field of data mining. It is like the point-and-click camera: you drag several nodes onto the diagram, run it and everything is settled. And I was quite i...
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

Multi-study research on Bovine respiratory disease

September 22, 2010
By
Multi-study research on Bovine respiratory disease

Situation:The purpose of this research was to (1) to explore a recent multi-study approach (Arends, et al. 2008) in combining observational survival data instead of traditional meta-analysis, and (2) to develop multivariate random-effects models with o...
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

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.