The HPIMPUTE Procedure

Example 7.2 Running Client Data on the SAS Appliance

This example uses the same data set as in Example 7.1.

When the input data set resides on the client and a PERFORMANCE statement that includes a NODES= option is specified, as in the following statements, PROC HPIMPUTE copies the data set to the SAS appliance, where the imputation is performed:

 /*Perform the computation on the SAS appliance using 2 nodes*/
 option set=GRIDHOST="&GRIDHOST";
 option set=GRIDINSTALLLOC="&GRIDINSTALLLOC";
 proc hpimpute data=sampsio.hmeq out=out2;
     input mortdue value clage debtinc;
     impute mortdue / value  = 70000;
     impute value   / method = mean;
     impute clage   / method = random;
     impute debtinc / method = pmedian;
     performance nodes=2 details
     host="&GRIDHOST" install="&GRIDINSTALLLOC";
 run;

Output 7.2.1 shows the imputation results.

Output 7.2.1: Imputation Results

The HPIMPUTE Procedure

Imputation Results
Variable	Imputation Indicator	Imputed Variable	N Missing	Type of Imputation	Imputation Value (Seed)
MORTDUE	M_MORTDUE	IM_MORTDUE	518	Given value	70000
VALUE	M_VALUE	IM_VALUE	112	Mean	101776
CLAGE	M_CLAGE	IM_CLAGE	308	Random	5.00000
DEBTINC	M_DEBTINC	IM_DEBTINC	1267	Pseudo Median	34.81696

Output 7.2.2 shows the performance information.

Output 7.2.2: Performance Information

Performance Information
Host Node	<< your grid host >>
Install Location	<< your grid install location >>
Execution Mode	Distributed
Number of Compute Nodes	2
Number of Threads per Node	32

Output 7.2.3 shows the timing information.

Output 7.2.3: Procedure Task Timing

Procedure Task Timing
Task	Seconds	Percent
Startup of Distributed Environment	5.30	98.76%
Data Transfer from Client	0.01	0.16%
Computation	0.02	0.34%
Writing Output	0.04	0.74%

Last updated: July 22, 2020