Usage Note 50857: %di_job geo_prod_mts task generates error "ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant..."
The SAS® Markdown Optimization %DI_JOB geo_prod_mts task might generate the following error in the <ddmmmyyyy_hh_mm_ss>_mp.log.dipcl_etl_geo_prod_mts.<n>.log file.
NOTE 137-205: Line generated by the invoked macro "DIPCL_ETL_GEO_PROD_MTS".
71 begin,'l'); call symputx('final',final,'l'); run; data geo_prod_&parent_prod_hier_sk_val; do i = &begin to
-
22
71 ! &final; set gp_mts.geo_prod point=i; output; end; stop; run; proc sort data=geo_prod_
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, INPUT, PUT.
WARNING: Apparent symbolic reference BEGIN not resolved.
NOTE 137-205: Line generated by the invoked macro "DIPCL_ETL_GEO_PROD_MTS".
71 begin,'l'); call symputx('final',final,'l'); run; data geo_prod_&parent_prod_hier_sk_val; do i = &begin to
71 ! &final; set gp_mts.geo_prod point=i; output; end; stop; run; proc sort data=geo_prod_
-
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, INPUT, PUT.
WARNING: Apparent symbolic reference FINAL not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.GEO_PROD_<prod_hier_sk> may be incomplete. When this step was stopped there were 0 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
This error occurs when there are one or more low-level children of the PROD_HIER_SK identified in the log that do not have geo-prods in the DI_DM.GEO_PROD table. There are discrepancies between the DI_DM.PRODUCT_HIER_ASSOC_DM and the DI_DM.GEO_PROD tables.
Please contact SAS Technical Support for assistance with this issue.
Operating System and Release Information
SAS System | SAS Markdown Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise Edition | 3.2 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Standard Edition | 3.2 | | 9.1 TS1M3 SP4 | |
64-bit Enabled AIX | 3.2 | | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | medium |
Date Modified: | 2013-10-16 08:35:20 |
Date Created: | 2013-08-26 10:15:57 |