Currently we only support local files.įollow the steps below to import SAS Data Sets data using standard SQL:įrom the ribbon in Excel, click Power Query -> From Other Data Sources -> From ODBC. URI: Set this to the folder containing your.Set the following connection properties to connect to your SAS DataSets files: You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). This article details how to use the ODBC driver to import SAS Data Sets data into Microsoft Power Query.Ĭonnect to SAS Data Sets as an ODBC Data Source The CData ODBC Driver for SAS Data Sets enables you to link to SAS Data Sets data in Microsoft Power Query, ensuring that you see any updates.
0 Comments
Leave a Reply. |