topic Re: Data Discovery Action Set in SAS Programming

Data Discovery Action Set

luca87 — Tue, 15 Mar 2022 11:16:15 GMT

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

Re: Data Discovery Action Set

HarrySnart — Tue, 15 Mar 2022 14:42:16 GMT

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;

Re: Data Discovery Action Set

luca87 — Tue, 15 Mar 2022 15:27:15 GMT

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