Creating Data Grid on SAS Viya Intelligent Decisioning

FerhatD — Mon, 18 Oct 2021 14:25:01 GMT

Hi expert,

I would like to create a data grid that checks for the row numbers in SAS Intelligent Decisioning. As given below I create a Datagrid named 'mpsValidationResult' and want to assign it to 'id_val_row' that I declare before assigning. When I tried to test that code 'id_val_row' returns missing. You can find the code and log as attached.

Could you please help with what I am missing?

Thanks in advance,

Regards

package "${PACKAGE_NAME}" /inline;

method execute(double total_cover_amount,

double Cash_and_Cash_Equivalents,

in_out package datagrid mpsValidationResult

);

dcl int id_val_row ;

DataGrid_addCharacterColumn(mpsValidationResult, 'VALRESCODE') ;

DataGrid_addCharacterColumn(mpsValidationResult, 'VALRESVAR') ;

DataGrid_addNumericColumn(mpsValidationResult, 'id_val_row') ;

/*2*/

if missing(total_cover_amount) then do ;

id_val_row= DATAGRID_ADDROW("mpsValidationResult") ;

DataGrid_Set("mpsValidationResult",'VALRESCODE', id_val_row,'MISSING') ;

DataGrid_Set("mpsValidationResult",'VALRESVAR', id_val_row,'total_cover_amount') ;

end ;

else if (total_cover_amount < 0) then do ;

id_val_row=DATAGRID_ADDROW("mpsValidationResult") ;

DataGrid_Set("mpsValidationResult",'VALRESCODE',id_val_row,'INVRANGE') ;

DataGrid_Set("mpsValidationResult",'VALRESVAR',id_val_row,'total_cover_amount') ;

end ;

/*3 rule OK, logic?*/

if missing(Cash_and_Cash_Equivalents) then do ;

id_val_row=DATAGRID_ADDROW("mpsValidationResult") ;

DataGrid_Set("mpsValidationResult",'VALRESCODE',id_val_row,'MISSING') ;

DataGrid_Set("mpsValidationResult",'VALRESVAR',id_val_row,'Cash_and_Cash_Equivalents') ;

end ;

else if (Cash_and_Cash_Equivalents < 0) then do ;

id_val_row=DATAGRID_ADDROW("mpsValidationResult") ;

DataGrid_Set("mpsValidationResult",'VALRESCODE',id_val_row,'INVRANGE') ;

DataGrid_Set("mpsValidationResult",'VALRESVAR',id_val_row,'Cash_and_Cash_Equivalents') ;

end ;

endpackage;

topic Creating Data Grid on SAS Viya Intelligent Decisioning in SAS Viya

Creating Data Grid on SAS Viya Intelligent Decisioning