Pass-Through Facility: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Valid in: | PROC SQL steps (when accessing PC files data using SAS/ACCESS software) |
Syntax | |
Arguments | |
Details | |
Example |
Syntax |
DISCONNECT FROM PCFILES |<alias> |
Arguments |
specifies an alias for the connection that was defined in the CONNECT statement.
Details |
The DISCONNECT statement ends the connection with the data source. If the DISCONNECT statement is omitted, an implicit DISCONNECT is performed when PROC SQL terminates. The SQL procedure continues to execute until you submit a QUIT statement, another SAS procedure, or a DATA step.
Any return code or message that is generated by the data source is available in the macro variables SQLXRC and SQLXMSG after the statement executes. See Return Codes for more information about these macro variables.
Example |
After connection and SQL processing, this example uses the DISCONNECT statement to disconnect the connection from the database and the QUIT statement to quit the SQL procedure:
DISCONNECT FROM PCFILES; QUIT;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.