Posts Tagged ‘ sql ’

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

Building an SQL subquery in SAS Enterprise Guide

June 28, 2013
By
Building an SQL subquery in SAS Enterprise Guide

Many SAS Enterprise Guide users practically live in the Query Builder. For those who understand their data tables, the Query Builder provides a tremendous amount of flexibility to pull and manipulate data. The Query Builder produces SQL programs behind the scenes, which translates well for database-centric work. Sometimes a complex
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Describe Your Table in SAS to Write the SQL Code

May 22, 2013
By
Describe Your Table in SAS to Write the SQL Code

SQL Describe Code

Ever had the need to write SQL create statements for existing tables but felt too lazy to write it by hand?  Ever wanted to reverse ...

The post Describe Your Table in SAS to Write the SQL...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

LearningR!

February 9, 2013
By
LearningR!

I spent almost all of my blogging time last month to follow an online course in Coursera, Computing for Data Analysis (with R) by Dr. Roger  Peng of Johns Hopkins, Biostatistics Department. I already checked out bunch of Coursera courses just to take a look at what else MOOC look like, this R course...
Read more »

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

A database professional’s best friend

February 4, 2013
By

To optimize a Structured Query Language (SQL), the database professional must befriend this order and perhaps even embrace it. Who is your best friend? I’m talking about the order in which SQL processes your statements. Simply put, in what order does...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

How to Jump into SAS Data Integration Studio

January 12, 2013
By
How to Jump into SAS Data Integration Studio

This is for for SAS programmers who might be reluctant to check out a GUI tool like SAS Data Integration Studio (DIS for short, which is graphic tool to implement ETL processes: extract, transform, load). DIS translates all users dragged nodes, transformations and process into SAS codes which are traditionally written by SAS programmers....
Read more »

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

How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)

January 11, 2013
By
How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)

SAS programmers are longing for row number function used in Proc SQL, like ROW_NUMBER() in Oracle SQL and it will act like data step system variable _N_. When you google this question, most likely you will get MONOTONIC() function, which might be one of the most famous undocumented features shipped by SAS. You can...
Read more »

Tags: ,
Posted in SAS | Comments Off

NOTE: ODBC Performance

November 28, 2012
By

SAS is great at getting data from a huge variety of sources. With its SAS/ACCESS connectors, SAS can get data from these sources in an optimised fashion, i.e. using the native capabilities of the source data provider. In these days of increasingly larg...
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.