Problem Note 60010: PROC IMSTAT SET fails to append tables and returns an error that secondary tables must be partitioned by the same variables as the primary table
A failure occurs when PROC IMSTAT SET is used to append tables that are partitioned on more than one variable.
An example is shown below.
26 /* partition on more than 1 column */
27 data lasrlib.carsmultipart (partition=(make model));
28 set sashelp.cars;
29 run;
NOTE: There were 428 observations read from the data set SASHELP.CARS.
NOTE: The data set LASRLIB.CARSMULTIPART has 428 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
30
31
32 proc imstat;
33 table lasrlib.carsmultipart;
34 partition make model;
35 run;
NOTE: The LASR Analytic Server action request for the PARTITION statement
completed in 0.018916 seconds.
36
37 table lasrlib.carsmultipart;
38 set &_templast_ / drop;
39 run;
ERROR: When appending tables to a partitioned LASR Analytic Server table the
secondary tables must be partitioned by the same variables as the primary table
or you must request that partitioning be removed from the primary table.
WARNING: The LASR Analytic Server action request for the SET statement did not
complete successfully.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS LASR Analytic Server | Microsoft® Windows® for x64 | 2.7 | 2.7 | 9.4 TS1M3 | 9.4 TS1M4 |
Linux for x64 | 2.7 | 2.7 | 9.4 TS1M3 | 9.4 TS1M4 |
*
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.
The PROC IMSTAT SET statement fails to append tables that have more than one partitioned variable.
Secondary tables must be partitioned by the same variables as the primary table
or you must request that partitioning be removed from the primary table.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2017-03-07 09:03:54 |
Date Created: | 2017-02-20 13:40:18 |