topic Re: KNN - SAS Procedure to run KNN without target variable in SAS Procedures

KNN - SAS Procedure to run KNN without target variable

Shanmugavel_g — Mon, 10 Oct 2016 03:28:37 GMT

Hi All,

I'm trying to run KNN on set of standardized inputs and identify 20 neighbors using Euclidean distance or other similar distance.

I would like to get top N neighbor, distance between the neighbors and my item as output. I don't have a target variable in my dataset, so I need this procedure to identify my neighbors based only on input space. I have 21K items and 145 variables in my dataset, so I'm also looking for efficiency of the procedure.

I tried MBR node in Enterprise miner and PROC DISCRIM in base SAS, but both requires target variable.

Can anyone kindly point me to the right procedure that would be helpful to implement my problem. Let me know if any other details are needed.

Thanks in advance

Regards,

Shan

Re: KNN - SAS Procedure to run KNN without target variable

Reeza — Mon, 10 Oct 2016 03:38:34 GMT

Try: Proc Cluster, Aceclus and Fastclus

http://support.sas.com/documentation/cdl/en/statug/68162/HTML/default/viewer.htm#statug_cluster_syntax01.htm

Re: KNN - SAS Procedure to run KNN without target variable

PGStats — Mon, 10 Oct 2016 04:10:07 GMT

Try using proc modeclus with options neighbor and dk=

ods _all_ close;
proc modeclus data=myData dk=21 neighbor;
var var1-var145;
id Item;
ods output Neighbor=myNeighbors;
run;
ods listing;

test with a subset first!

Re: KNN - SAS Procedure to run KNN without target variable

Shanmugavel_g — Mon, 10 Oct 2016 04:27:49 GMT

Thanks for quick reply. I will take a look into these procedure, run it on my data and will let you know the results.

Re: KNN - SAS Procedure to run KNN without target variable

Shanmugavel_g — Mon, 10 Oct 2016 04:15:48 GMT

Thanks for quick reply.
I'll try your code on my dataset and let you know the results. Thanks for the help.

Re: KNN - SAS Procedure to run KNN without target variable

Ksharp — Mon, 10 Oct 2016 10:57:41 GMT

Coincidence .

http://blogs.sas.com/content/iml/2016/09/14/nearest-neighbors-sas.html

http://blogs.sas.com/content/iml/2016/09/19/nearest-neighbor-distances.html

http://blogs.sas.com/content/iml/2016/09/28/distance-between-two-group.html