Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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: