DocumentsDate added

A Pragmatic Programmers Introduction to Data Integration Studio: Hands on Workshophot!

24.05.2007

ETL is the process of moving data from a source system (such as operational systems or a table in a database) into a structure that supports analytics and reporting (target). This workshop will guide participants through a structured, hands-on exercise designed to give them a broad overview of what things we can accomplish with Data Integration Studio. Here we will prepare data for use by extracting data from an external file, creating transformations that enrich our data, combining it with other data for completeness and finally loading the data into tables that are part of a star schema. The goal of this workshop will be to get users comfortable with the tool and demonstrate its capability.

Hits: 103

• Details
• Download

Improve Database Transaction Processing Using MODIFYhot!

11.12.2007

The MODIFY statement has been part of the SAS® set of tools for years, yet it is rarely used. Good programmers have written very complicated code to accomplish that what be done very readily usingthis statement.

Hits: 187

• Details
• Download
• View

odbc with SAShot!

07.01.2008

This document is designed to show you some of the ways that you can take advantage of ODBC when using SAS and
SPSS.

Hits: 116

• Details
• Download
• View

Play Nice with Others: Waiting for a Lock on SAS Tablehot!

21.01.2008

Multiuser access to sas data requries administration in order to avoid error messages such as "LOCK ERROR". This can be done with two strategies at least:  1. limiting access to dataset with password. 2. Setting lock on data.

1. Using sas tools, you make a specific table read-only by alter and write
protecting it. The dataset alter and write options prevent table modifications, deletions or replacements.

data nochangedoctor (alter=shhh write=secret);
  xray=1;
run;

data foo;
  set nochangedoctor;
run;

proc datasets lib=work nolist;
  modify foo (alter=xyzzy write=xyzzy);
run;

proc append base=foo(alter=xyzzy) new=foo;
run;

proc delete data=nochangedoctor(alter=shhh);
proc delete data=foo(alter=xyzzy);
run;

Use the dataset read= option to enforce a restricted access policy.
OS file attribute tools (such as unix chmod or windows cmd attrib) can also
protect the file containing a specific sas table.
libname option access=readonly can protect all tables in a library
 

2. This paper demonstrates how to use the LOCK statement in base SAS® to cause your program to wait until the tables you need are available. The techniques shown can be used to protect critical sections of code by locking multiple tables. Applying these concepts can greatly improve the reliability of programs that run in highly contentious batch environments.

Hits: 275

• Details
• Download
• View

Sas date functionshot!

17.04.2008

What are SAS date and time values? How are they used and why do we care? What are some of the more important of the many functions, formats, and tools that have been developed that work with these crucial elements of the SAS System?

Hits: 142

• Details
• Download
• View