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
Grid Mode Symmetric
Number of Compute Nodes 2
Number of Threads per Node 8


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 1.05 57.18%
Data Transfer from Client 0.01 0.49%
Computation 0.24 12.98%
Writing Output 0.54 29.34%