datapreprocess.impute action doesn't fill missing values in the output table

Melhamamsy — Thu, 11 May 2023 11:13:42 GMT

Hello all,

I'm trying to use datapreprocess.impute action to impute interval variables with their medians. However, when inspecting the output table, the missing values are not imputed.

The code is shown below, and, this is part of the "High-Performance Data Processing with CASL in SAS Viya" Course.

proc cas;
    inTbl={name="cars_raw", caslib="casuser"};
	outTbl={name="cars_imputed", caslib="casuser"};

    table.upload / 
        path="&path/data/my_data/cars_raw.sas7bdat"
        casOut=inTbl || {replace=TRUE};

    table.columnInfo /
        table=inTbl;

    simple.distinct / table=inTbl;

	datapreprocess.impute /
		table=inTbl,
		casOut=outTbl || {replace=TRUE},
		inputs={"EngineSize","Cylinders"},
		methodInterval="MEDIAN",
		copyAllVars=TRUE;


    table.columnInfo /
        table=outTbl;

    simple.distinct / table=outTbl;
quit;

Appreciate your explanation on this.

Re: datapreprocess.impute action doesn't fill missing values in the output table

DerylHollick — Mon, 15 May 2023 13:43:21 GMT

It's creating new variables with the imputed results:

Re: datapreprocess.impute action doesn't fill missing values in the output table

Melhamamsy — Tue, 16 May 2023 06:28:06 GMT

Thank you!

topic datapreprocess.impute action doesn't fill missing values in the output table in SAS Programming

datapreprocess.impute action doesn't fill missing values in the output table

Re: datapreprocess.impute action doesn't fill missing values in the output table

Re: datapreprocess.impute action doesn't fill missing values in the output table