Posts Tagged ‘ sql ’

Reusing calculated columns in Netezza and SAS queries

June 8, 2016
By

Netezza and SAS allow a query to reference a calculated column by name in the SELECT, WHERE, and ORDER BY clauses. Based on the DRY principle, this reduces code and makes code easier to read and maintain.

Some people call calculated columns derived or computed columns.

In Microsoft SQL Server, SQLite, and other RDBMSs...
Read more »

Tags: ,
Posted in SAS | Comments Off on Reusing calculated columns in Netezza and SAS queries

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

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 on Building an SQL subquery in SAS Enterprise Guide

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 on Describe Your Table in SAS to Write the SQL Code

LearningR!

February 9, 2013
By

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 on LearningR!

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 on A database professional’s best friend

How to Jump into SAS Data Integration Studio

January 12, 2013
By

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 on How to Jump into SAS Data Integration Studio

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

January 11, 2013
By

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 on How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)

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.

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
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.