Considerations for Manually Editing Code

Before You Manually Edit Code

The code generation features in SAS Visual Data Builder can generate a lot of SAS statements with a few simple clicks. Depending on your needs, you might benefit by using the Design tab for adding input tables, performing joins, and filtering data before you customize the generated code.
The following features and settings must be specified before you unlock the code:
Unique values
Selecting this check box determines whether the DISTINCT keyword is included in the generated PROC SQL statement. After you unlock the code, the check box cannot be used to include the keyword.
Append data
Selecting this check box enables you to use the generated SAS statements for appending data to the output table before you unlock the code.
Output table
You must specify the table name, location, and library, and you must save the query before you unlock the code. When you save the query, the metadata for the table is registered.
Use a staging table
Selecting this check box registers the metadata for the table when you save the query. Select the check box, specify the library, and save before you unlock the code.

Input and Output Libraries

When you unlock the code for manual editing, you must specify the libraries to use for your tables. You can do this with LIBNAME statements. If you dragged and dropped the tables onto the workspace before you unlocked the code for manual editing, the LIBNAME statements for the tables are automatically included.

See Also

SAS Statements: Reference
SAS/ACCESS for Relational Databases: Reference

Output and Staging Tables

Specify the table names, locations, and libraries on the Properties tab just as you do on the Design tab.
Note: Specify the tables and save the query before you unlock the code. If you do not specify the table name or the table name is already in use, you are not able to save the query.

See Also

SAS Language Interfaces to Metadata

Validating Custom Code

If you entered SAS statements in the Preprocess or Postprocess views, those statements are not validated when you click Validate query.
If you unlock the code in the All Code view, the Validate query button is disabled. You cannot validate customized code.
Copyright © SAS Institute Inc. All rights reserved.