Chapter Contents |
Previous |
Next |
Doing More with SAS/ASSIST Software |
Edit | Enhanced Editor |
Enhanced Editor Window
WHERE A.FLIGHT=B.FLIGHT
) at the end of the SQL code to complete the
join.
length=3
at the end of
the B.ORIG column description.
The edited query is shown in the following display. The display is scrolled forward so that you can see the WHERE clause.
Edited SQL Query
Note: You can also run your query from the Enhanced Editor window by selecting
Run
from the RUN menu.
Including and Writing SQL Code to External Files |
Include Window
Type an external file name and select OK to copy the SQL code into the SQL Editor window.
To write your SQL code to an external file, select Store SQL from the File menu. The Store SQL...window prompts you for the external file name, as shown in the following display.
Store SQL Window
Type an external file name and select OK to write the SQL code to your external file.
Note: You can include IBM QMF
queries in the SQL Editor window if you convert
them for use in Query and Reporting. See Migrating from QMF to SAS/ASSIST Software for more information.
Correcting Errors in SQL Code |
Using the example from earlier in this chapter, if you incorrectly type the A.FLIGHT column name as A.FLIGHTT in the WHERE clause and you run the program, the Report Log window appears, informing you that an error has occurred.
Select View SAS Log from the Run menu to open a SAS log that is customized for SAS/ASSIST software. The following display indicates that the A.FLIGHTT column was not found in the AIRLINE.DELAY table.
SAS Log Window
Select Close from the File menu twice to return to the SQL Editor window. Correct your code and run it again.
When you run your SQL code successfully, your output appears in the Report Output window (or in the output window that is defined for your system). From the SQL Editor window, you can select Report Log from the View menu to see the most recent SAS log for your output.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.