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 on Convert CHAR to NUM in PROC SQL

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 on Rolling Window Regression of Time Series

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 on Regularized Discriminant Analysis

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 on A SAS data miner without Enterprise Miner

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 on The efficiency of five SAS methods in multi-dataset merging

Rename all vars in a dataset using SASHELP

November 18, 2010
By

*Create a temporary dataset... DSN;data dsn;a=1;b=2;c=3;d=4;e=5;f=6;run;%macro test(lib,dsn);*/1)*/ data _null_;      set sashelp.vtable(where=(libname="&LIB" and memname="&DSN"));      call symput('nvars',nvar);run;*/2)*/ data ...
Read more »

Tags: ,
Posted in SAS | Comments Off on Rename all vars in a dataset using SASHELP

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 on Multi-study research on Bovine respiratory disease

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 on Table Look Up in SAS, practical problems

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: tal.galili@gmail.com

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.