topic Re: cluster analysis [how to improve your question] in SAS Programming

cluster analysis

EloarL — Tue, 06 Aug 2019 12:39:31 GMT

hello, could anyone help me with an example of Proc for cluster analysis with graph plot Error?

Re: cluster analysis [how to improve your question]

Community_Guide — Tue, 06 Aug 2019 12:43:24 GMT

Hello @EloarL,

Your question requires more details before experts can help. Can you revise your question to include more information?

Review this checklist:

Specify a meaningful subject line for your topic. Avoid generic subjects like "need help," "SAS query," or "urgent."
When appropriate, provide sample data in text or DATA step format. See this article for one method you can use.
If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message.
It also helps to include an example (table or picture) of the result that you're trying to achieve.

To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message. From there you can adjust the title and add more details to the body of the message. Or, simply reply to this message with any additional information you can supply.

SAS experts are eager to help -- help them by providing as much detail as you can.

This prewritten response was triggered for you by fellow SAS Support Communities member @Rick_SAS

Re: cluster analysis [how to improve your question]

EloarL — Tue, 06 Aug 2019 13:08:18 GMT

I need to generate a cluster analysis in SAS Guide using the K means and centroids method and plot the elbow graph. However I need the help or example of some Proc in this regard.

Re: cluster analysis [how to improve your question]

Reeza — Tue, 06 Aug 2019 15:13:20 GMT

Did you try PROC CLUSTER? The examples in the documentation is pretty straightforward:

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_cluster_examples01.htm&docsetVersion=15.1&locale=en

@EloarL wrote:
I need to generate a cluster analysis in SAS Guide using the K means and centroids method and plot the elbow graph. However I need the help or example of some Proc in this regard.

Re: cluster analysis [how to improve your question]

EloarL — Tue, 06 Aug 2019 17:49:11 GMT

yes, i tested them all but i didn't get any results i need because i need a Procesar with a cluster parsing function in R language.
Code used in the R language was as follows:
erro = 0
for (i in 2:20){
erro[i] <- ml_compute_cost(
ml_kmeans(
variaveis_clusters_tratado, CODCLI ~ ., k=i), variaveis_clusters_tratado)
}

plot(erro)

I need a function similar to this in SAS GUIDE

Re: cluster analysis [how to improve your question]

PaigeMiller — Tue, 06 Aug 2019 18:25:36 GMT

Can you explain what the R code does? Most of us don't understand R.

Re: cluster analysis [how to improve your question]

EloarL — Tue, 06 Aug 2019 19:35:48 GMT

cluster <- ml_kmeans(variaveis_clusters_tratado, CODCLI ~ ., k = 5) Create a K-MEANS model with dataset data variaveis_clusters_tratado,following the formula CODCLI ~ ., com 5 Clusters, isto é, k=5.clusters <- ml_predict(cluster, variaveis_clusters_tratado) predict the values of variaveis_clusters_tratado using the template that was created in the first line, that is, the clusters. While doing so, this line overlaps the created model in R's memory. That is, it uses the model and then replaces it with the prediction result, which is likely to be a dataframe.

How to do this in SAS GUIDE?

Re: cluster analysis [how to improve your question]

Reeza — Tue, 06 Aug 2019 19:43:12 GMT

Sounds like you're scoring a data set after? You first create your clusters and then you want to apply that logic to a different data set? If so, take a look at PROC SCORE and PLM.

Re: cluster analysis [how to improve your question]

PaigeMiller — Tue, 06 Aug 2019 20:19:03 GMT

Certainly, SAS can do K-means clustering, its in PROC FASTCLUS.

https://documentation.sas.com/?docsetId=statug&docsetVersion=14.2&docsetTarget=statug_fastclus_overview.htm&locale=en

If that doesn't do what you want, please describe in detail exactly what you need, give us a complete description of what you need, starting from the beginning; instead of making us ask question after question as we have been doing to get this far.