Skip to content

Latest commit

 

History

History
32 lines (17 loc) · 969 Bytes

File metadata and controls

32 lines (17 loc) · 969 Bytes

Import - Google Sheets

Description

The Import - Google Sheets custom step enables SAS Studio users to import public Google Sheets as a SAS table.

User Interface

  • Definition tab

  • About tab

Requirements

2022.12 or later

The Google Sheet must be shared publicly - Google Sheet defines this as "Anyone with the link".

Usage

Find a demonstration of this step in this YouTube video: Import - Google Sheets | Custom Step

You can use this publicly available example Google Sheet created by the author of this Custom Step. The spreadsheet ID is 19SnoqFxcgVnqk2cfMFOIcu_Y7F7EduckGuSW6rH2nCw and the second worksheet has the ID 2001095659.

Change Log

  • Version 1.0 (12JAN2023)
    • Initial version