9.4. Types of Problems

The leading causes of SQL programming problems include misusing the language syntax; referencing data, especially column data, incorrectly; ignoring or incorrectly specifying system parameters, and constructing syntactically correct but illogical code that does not produce results as expected.

Usage errors can cause the SAS System to stop processing, produce warnings, or produce unexpected results. The following table illustrates the four types of usage errors and briefly describes each.

Types of Usage Errors

ProblemDescription
SyntaxSyntax problems are a result of one or more violations of the SQL procedure language constructs. These problems can prevent a program from processing until you make the required changes. For ...

Get PROC SQL: Beyond the Basics Using SAS® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.