Posts Tagged ‘ SQL Server ’

Stored Processes: SAS’s voice on Business Intelligence

April 19, 2012
By
Stored Processes: SAS’s voice on Business Intelligence

Everyday I write SAS scripts to extract, transform and load data from various sources, which is a step before the database, and also pull out data to do analysis such as aggregation and regression in SAS, which is a step after the database. According t...
Read more »

Tags: ,
Posted in SAS | Comments Off

SAS & IWA: Host Name Aliases and SPNs

April 7, 2012
By

I’m quite keen on using host name aliases, rather than their physical host names, when referring to machines in SAS® platform installations. It does however mean a little extra configuration is required when using Integrated Windows Authenti...
Read more »

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

SAS and IWA: Two Hops

January 23, 2012
By

In an earlier post I mentioned that I would jot down a few notes about my experiences with SAS® software and Integrated Windows Authentication (IWA). This is the first of these posts and concerns the initial configuration. Chances are, if you knew...
Read more »

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

Using SQL for data management

December 31, 2011
By
Using SQL for data management

Every weekday I pull out data from IBM DB2 database and do analysis in SAS. I use SQLite to record my personal chores, such as credit card transactions. And I am taking courses of database development by Microsoft SQL Server. Then I have pretty enough...
Read more »

Tags: , ,
Posted in SAS | Comments Off

SAS and IWA (Integrated Windows Authentication) Notes

December 31, 2011
By

Over the past year I have worked on a number of SAS® 9.2 platform installations helping to get Integrated Windows Authentication (IWA) working nicely for single sign-on (SSO) for the SAS platform. Whilst it’s relatively easy to turn IWA on, ...
Read more »

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

Four ways to add row number in SQL Server

December 25, 2011
By
Four ways to add row number in SQL Server

It is easy to sort any data in SQL Server, while it is not a trivial job to add a new variable of row number to an existent table. Here I come with four ways to realize the purpose. /********** 0. Input data source *********************/ use...
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.