The Information Maps
engine only reads information maps and their data sources. If you
want to update an information map directly, you can use the INFOMAPS
procedure or SAS Information Map Studio.
The engine supports
accessing metadata in a metadata server to process the information
map. Using the engine and SAS code, you can do the following:
-
read data that is retrieved via
an information map (input processing)
-
create a new data set by using
an information map (output processing)
Note: The new data set is created
in Base SAS software, not on the data server.
The Information Maps
engine does not support the following:
-
The engine does not pass WHERE clauses to the SAS server
for processing. Therefore, all of the data that is retrieved via the
information map is passed back to the SAS client. The SAS client applies
the WHERE clause to restrict the data for the result set.
Performance is degraded
whenever a large number of observations are returned, especially from
a remote data source, for processing by SAS. You can use information
map filters to restrict the query and reduce the number of observations
that must be processed. A filter contains criteria for subsetting
data in an information map.
For more information about filters, see FILTER= Data Set Option. For additional information about improving the performance of the
Information Maps engine, see Hints and Tips for Using the INFOMAPS Procedure or the Information Maps Engine.
-
The engine does not sort data in the result set for BY-group
processing. BY-group processing requires that the result set be sorted.
However, the engine has no control over sorting the data. This means
that you will have to manually sort the data in the result set that
is supplied by the engine before you use it with a BY-group statement.
For example:
libname mylib infomaps ... ;
proc sort data=mylib.results_set out=work.sorted;
by sorted_var;
run;
proc print data=work.sorted;
by sorted_var;
run;
The one exception is
the SQL procedure. You can use BY-group processing with the Information
Maps engine's result set because the SQL procedure automatically sorts
the result set before it applies the BY-group statement.
-
The engine does not support OLAP
data.
-
The engine does not support updating
or deleting an information map, nor does it support updating the underlying
data.
-
The engine does not provide explicit
SQL pass-through support.