Problem Note 32770: Values containing “%AR” might cause errors when importing data using SAS® Enterprise Guide
 |  |  |  |
In SAS Enterprise Guide, one or more of the following errors might occur when using the Import Data task to import Microsoft Excel or other data.
ERROR: Invalid AR process name "". ABORT; * '%AR' ERROR INSERTED ABORT STATEMENT; ERROR: Macro library damaged. Cannot execute macro AR. ERROR: The macro AR will stop executing. ERROR: Read Access Violation In Task [ DATASTEP (2) )
If the Import Data task is run a second time, the following errors might occur:
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, NONE. ERROR 76-322: Syntax error, statement will be ignored.
The problem can occur when one or more columns or data values contains the string '%AR'. SAS/ETS calls a macro by using %AR. Because %AR is a reserved name, the import process fails.
To circumvent the problem, edit the data and change any column or value from '..%AR..' to something different. For example, use '.._%_AR_..' or '.._Percent_AR_..'.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-07-25 14:02:40 |
| Date Created: | 2008-07-23 11:28:09 |