ACCESS Procedure
         
         
         
         
         
         
            
         
         
         
            PROC ACCESS Statement
            
            Accesses relational DBMS data
            
            
            
            
               Syntax 
               
               
               
                  
                     Optional Arguments
                     
                     - ACCDESC=libref.access-descriptor
 
                        - 
                           
specifies an access
                              descriptor. ACCDESC= is used with the DBMS= option to create or update
                              a view descriptor that is based on the specified access descriptor.
                              You can use a SAS data set option on the ACCDESC= option to specify
                              any passwords that have been assigned to the access descriptor.  
                           
                           Note: The ODBC interface does not
                              support this option.
                           
 
                         
                     
                     - DBMS=database-management-system
 
                        - 
                           
specifies which database
                              management system you want to use.  This DBMS-specific option is required.
                              See SAS/ACCESS documentation for your DBMS.
                           
                         
                     
                     - OUT=libref.member-name
 
                        - 
                           
specifies the SAS data
                              file to which DBMS data is output. 
                           
                         
                     
                     - VIEWDESC=libref.view-descriptor
 
                        - 
                           
specifies a view descriptor
                              through which you extract the DBMS data. 
                           
                         
                     
                   
                
             
          
       
      
      
      
         Copyright © SAS Institute Inc. All rights reserved.