Coding Standards for SAS Production Programs

Very Good article about Coding Standards penned down....

Tricks for Programming with Extremely Large SAS Data Sets

Common Sense Tips and Clever Tricks for Programming with Extremely Large SAS® Data Sets

Source Link

SAS Programming Efficiencies

The purpose of this document is to provide tips for improving the efficiency of your SAS programs. It suggests coding techniques, provides guidelines for their use, and compares examples of acceptable and improved ways to accomplish the same task. Most of the tips are limited to DATA step applications.

Efficiency

For the purpose of this discussion, efficiency will be defined simply as obtaining more results from fewer computer resources. When you submit a SAS program, the computer must:

• load the required software into memory 
• compile the program 
• find the data on which the program will execute 
• perform the operations requested in the program 
• report the result of the operations for your inspection

All of these tasks require time and space. Time and space for a computer program are composed of CPU time, I/O time, and memory.

Read more…

Advanced SAS tutorials (Slides) for Beginners !!!

SAS Slides 12 : Macros

SAS Slides 13 : Using Proc SQL

SAS Slides 14 : SAS Access / SAS Connect

SAS Slides 15 : Improving Effeciency With options in SAS

These links below would help to install Oracle SQL, Database client DbVisualizer and to practice accessing data on DBMS with SAS.

Oracle SQL Primer – Learn basic SQL statements.
Installing Oracle 9i – learn to install Oracle 9i.
Installing DbVisualizer – learn to install and use Database client DbVisualizer to query Oracle DBMS.