Data Discovery Action Set

[luca87]

Hi, 

I am trying to use on tables saved in CAS the Data Discovery Action Set function:

                proc cas;
                loadactionset / actionSet="dataDiscovery";
                run;
                dataDiscovery.profile result=r / table={name="&table."},
                casOut={name="&table._P", replace=true};
                run;
                loadactionset / actionSet="datapreprocess";
                run;
                datapreprocess.rustats /
                table={name="&table."}
                requestPackages={
                {
                locs={"mean", "median", "biweight"}
                scales={"std"}
                }
                }
                nominalStats={iqv=True topK=5 bottomK=5}
                casOut={name="&table._R",replace=true};
                run;

where &table is sashelp.cars.

I don't understand why it doesn't fill in the rowid=1001 field related to the Data type

Thanks

Luca

[HarrySnart]

Hi @luca87 PROC CAS works against in-memory CAS tables. You'll need to load the sashelp.cars table into memory first. 

E.g. 

libname casuser cas;

data casuser.cars;
set sashelp.cars;
run;

%let table=casuser.cars;

[luca87]

the table is already in cas. The code works but does not populate the relative field Data type (rowid=1001)