PROJECT_LIST= LIBNAME Statement Option

Specifies a list of projects to access on Google Cloud Platform.

Valid in: LIBNAME statement that connects to an external data source
Category: Data Access
Default: none
Data source: Google BigQuery
Notes: Support for this option was added in SAS 9.4M9. Support was added at SAS 9.4M8 in December 2025.
This option applies only when submitting FedSQL and DS2 programs in PROC FEDSQL and PROC DS2.
See: PROJECT= connection option, QUALIFIER= LIBNAME option
Example: 
project_list="project1,project2,project3"

Table of Contents

Syntax

PROJECT_LIST="project-ID-1<,project-ID-2...>"

Syntax Description

project-ID

specifies a list of Google Cloud Platform projects to access.

Details

When you specify this option, SAS/ACCESS does not query the full list of projects in your data source. As a result, you can improve the response time to access one or more Google Cloud Platform projects.

In addition to the projects that you specify in the PROJECT_LIST= option, SAS/ACCESS also accesses these projects:

  • a project specified for the PROJECT= connection option
  • a project specified for the QUALIFIER= LIBNAME option
  • the Google BigQuery public data project (bigquery-public-data)

If you specify PROJECT_LIST="" (empty string), this turns off querying all projects. In this case, only projects specified for PROJECT=, QUALIFIER=, and the Google BigQuery public data project would be accessed.

Last updated: February 3, 2026