Problem Note 69100: Scoring data by using an Analytic Store might appear to run indefinitely
When you score new data with a model that is an Analytic Store (Astore), the process might appear to run indefinitely. For example, you encounter this issue in the following scenarios:
- You use a Score Data node in a pipeline that never completes using SAS® Model Studio.
- You run PROC ASTORE that appears to stop responding in SAS® Studio.
A likely cause of this issue is that at least one of the variables in your score table whose data type or format (if present) does not match with the data type or format of an input variable in the Astore model.
You can examine the data types and formats for the input variables of an Astore by using the DESCRIBE statement in the ASTORE procedure:
proc astore;
describe rstore=<caslib>.<the Astore table>;
run;
To examine the types and formats of the variables in the score table, use the CONTENTS procedure:
proc contents data=<caslib>.<the score table>;
run;
Workarounds
There are a couple of workarounds for this issue.
Workaround 1:
Make sure that the types and formats in the score table match to those in the Input Variables in PROC ASTORE.
Workaround 2:
Consider training the model by using data without formats and also remove all formats in the score table by using the code below:
* Remove formats from a SAS table;
libname mylib "<path of the SAS table>";
proc datasets lib=mylib;
modify <table>;
format _all_;
run;
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Viya | Linux for x64 | 3.5 | | Viya | |
Microsoft Windows Server 2019 | 3.5 | | Viya | |
Microsoft Windows Server 2016 | 3.5 | | Viya | |
Microsoft Windows Server 2012 R2 Datacenter | 3.5 | | Viya | |
Microsoft Windows Server 2012 R2 Std | 3.5 | | Viya | |
*
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: | Problem Note |
Priority: | high |
Date Modified: | 2022-05-13 09:09:08 |
Date Created: | 2022-04-18 12:08:57 |