DocumentsDate added

The SAS/ACCESS® 9.1.x Interface to DB2 on the Mainframe Using the LIBNAME Enginehot!

11.12.2007

This paper provides an overview of the most important features and capabilities of the SAS/ACCESS Interface to DB2. General and technical product information is given for SAS/ACCESS and DB2 RDBMS users who need fast, seamless access to DB2 tables from the SAS System. The methods for accessing DB2 data are presented, along with examples.

Hits: 208

• Details
• Download
• View

The Basics of Using SAS® Indexeshot!

02.04.2008

This paper discusses how to create simple and composite SAS indexes, how to determine which variables make good index key variables, when creating and using indexes is appropriate, what centiles are, and how to generate index usage messages.

Hits: 145

• Details
• Download
• View

SAS web portal

27.03.2007

4SUC6 has developed a web reporting solution using SAS Base. This is the presentation about it.

Hits: 63

• 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

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