SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner

marianaalcos — Mon, 18 Jun 2018 22:01:10 GMT

Hi there,

I'm trying to use SAS Enterprise Miner to run KNN. My task is to run KNN with 20 different values for k and select the best K based on misclassification rates.

I definitely don't want to put 20 blocks in my diagram, so I decided to code it using the SAS Code block. This is the first time I'm using this block, so I guess I need some help, because my code below did not run.

Here's the piece of code that I put inside a SAS block (the first proc dmdb I included after reading it was necessary for proc pmbr to run).

%macro pmbr (run=1,method =scan, k=12);
*** create mandatory dmdb database for PROC PMBR *****************************; 
proc dmdb
	data=&em_import_data
	dmdbcat=work._cat;
   class %em_target;
	var %em_interval_input / level = interval;
   target %em_target / level = binary ;
run;
 
*** classify with PROC PMBR SCAN method **************************************; 

proc pmbr
	data=&em_import_data
	dmdbcat=_cat
	method=scan
	k=&k.; 
	score data=clusters_test out=score_pmbr_scan; 
	target %em_target ; 
	var %em_interval_input ;
   ods output fitStatistics=fitStats&run.;
 
run; 

data fitStats&run.;
     length method $ 10;
     length runLabel $ 64;
     set fitStats&run.;
     run = &run;
     runLabel = "&runLabel";
     method="&method.";
     k=&k.;
   run;
 

proc print data=fitStats&run.;
run;
 
proc append base=fitStats data=fitStats&run.;
run;
 
%mend pmbr;
 
%pmbr(run=1,runLabel=Scan k=1,method=scan,k=1);
%pmbr(run=2,runLabel=Scan k=2,method=scan,k=2);
%pmbr(run=3,runLabel=Scan k=3,method=scan,k=3);
%pmbr(run=4,runLabel=Scan k=4,method=scan,k=4);
%pmbr(run=5,runLabel=Scan k=5,method=scan,k=5);
%pmbr(run=6,runLabel=Scan k=6,method=scan,k=6);
%pmbr(run=7,runLabel=Scan k=7,method=scan,k=7);
%pmbr(run=8,runLabel=Scan k=8,method=scan,k=8);
%pmbr(run=9,runLabel=Scan k=9,method=scan,k=9);
%pmbr(run=10,runLabel=Scan k=10,method=scan,k=10);
%pmbr(run=11,runLabel=Scan k=11,method=scan,k=11);
%pmbr(run=12,runLabel=Scan k=12,method=scan,k=12);
%pmbr(run=13,runLabel=Scan k=13,method=scan,k=13);
%pmbr(run=14,runLabel=Scan k=14,method=scan,k=14);
%pmbr(run=15,runLabel=Scan k=15,method=scan,k=15);
%pmbr(run=16,runLabel=Scan k=16,method=scan,k=16);
%pmbr(run=17,runLabel=Scan k=17,method=scan,k=17);
%pmbr(run=18,runLabel=Scan k=18,method=scan,k=18);
%pmbr(run=19,runLabel=Scan k=19,method=scan,k=19);
%pmbr(run=20,runLabel=Scan k=20,method=scan,k=20);

So basically my diagram has the data block (I've attached the data - the 10 first columns are interval inputs and the 11th column is the binary target), a transform block to standardize the input variables and finally this SAS Code block with the code above.

I currently don't even know how to debug this =/ , just started using SAS EM.

Any help is appreciated!

Re: SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner

WendyCzika — Thu, 05 Jul 2018 16:29:49 GMT

A few changes to make:

1) You need to add the runlabel parameter to the %macro statement:

%macro pmbr (run=1, runLabel=, method =scan, k=12);

2) Need to remove " / level=level " from the VAR and TARGET statements in PROC DMDB.

3) I'm not sure what/where clusters_test data is, but using that causes an error for me after that.

4) I don't think PROC PMBR creates an ODS table FitStatistics

So I'm not sure this approach will work, but two things you can do to help figure out where your program is failing:

1) add

options mprint;

to the Project Start Code so your Log will be more helpful. And then...

2) View the Log in the Results of the SAS Code node after running it to see what errors are occurring.

Re: SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner

marianaalcos — Sat, 14 Jul 2018 01:33:26 GMT

Thanks for all valuable info Wendy! I was able to make it run!

topic SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner in SAS Data Science

SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner

Re: SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner

Re: SAS Code to run KNN (PMBR) with multiple K's in SAS Enterprise Miner