KNN - SAS Procedure to run KNN without target variable

[Shanmugavel_g]

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

[Reeza]

Try: Proc Cluster, Aceclus and Fastclus

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

[Shanmugavel_g]

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

[PGStats · Accepted solution]

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!

[Shanmugavel_g]

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

[Ksharp]

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