DocumentsDate added

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

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

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

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

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