• Print |
• E-mail  |
• Bookmark

SQL errors and other errors can occur when you perform tasks on Excel data that has been stored in a metadata server. The errors will be similar to the following:

  PROC SQL;
  CREATE VIEW WORK.SORTTempTableSorted
  AS SELECT Age FROM EXCELLIB.Sheet1$;
                                   _
                                   22
                                   _
                                   200

  ERROR 22-322: Syntax error, expecting one of the following: a name, ;,
  (, ',',

This problem occurs because the SAS^® Add-In for Microsoft Office is not referring to the sheet name correctly. The sheet should be referred to as follows:

  FROM EXCELLIB.'Sheet1$'n;

To circumvent the problem, do ONE of the following:

• Open the Excel file directly into Excel.
• Make the data source active without opening it into Excel. You can do this by selecting SAS > Active Data > Select Data Source instead of SAS > Open Data Source > Into Worksheet.

Operating System and Release Information

A fix for this issue for Add-In for Microsoft Office 2.1 is available at: