The HPSAMPLE Procedure

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

When the input data set resides on the SAS appliance, the SAS appliance performs all samplings, writes out a sample on the SAS appliance, and reports the frequency results back to the client. In the following statements, the input data resides in the MyLib library (which is a distributed data source), and the output data set is a distributed data set in the MyLib library. You can use PROC DATASETS to delete the output table if it already exists on the SAS appliance. The ods output FreqTable=Freqtab; statement saves the frequency table to a SAS data set called Freqtab on the client.

 /*MyLib is a libref for a distributed data source
   In this case, the computation is automatically done
   on the SAS appliance.*/
 option set=GRIDHOST       = "&GRIDHOST";
 option set=GRIDINSTALLLOC = "&GRIDINSTALLLOC";
 libname MyLib &LIBTYPE 
         server  ="&GRIDDATASERVER" 
         user    =&USER 
         password=&PASSWORD 
         database=&DATABASE;  
 proc delete data=MyLib.out_smp_ex3; run;

 proc hpsample data=MyLib.hmeq_example out=MyLib.out_smp_ex3 samppct=10 seed=1;
     var loan value delinq derog;
     class job reason;
     target  job reason;
     ods output FreqTable=Freqtab;
 run;

Output 8.3.1 shows the performance environment information.

Output 8.3.2 shows the number of observations in each stratum (constructed by a combination of the levels of each of the two targets) in the data set MyLib.Hmeq and in the sample.