topic Re: segmentation using fastclus in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306186#M60971 <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/18408">@Ksharp</a><BR />I might sound weird but is there a way to convert categorical data to continuous data ? Fri, 21 Oct 2016 05:50:18 GMT deega 2016-10-21T05:50:18Z segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305594#M60929 <P>Hi,</P><P>&nbsp;</P><P>I am trying to do segmentation using fastclus procedure but most of the data points fall into just one cluster. My input is&nbsp;a utility matrix that I created by customer purchase history and customer's demographic data. Could anybody please tell me whats wrong...</P><P>My input looks as follows</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>S.No</TD><TD>PromotionID</TD><TD>F</TD><TD>R</TD><TD>Total_P</TD><TD>return</TD><TD>A1</TD><TD>A2</TD><TD>A3</TD><TD>A4</TD><TD>A5</TD><TD>A6</TD><TD>A7</TD><TD>A8</TD><TD>A9</TD><TD>A10</TD><TD>A11</TD><TD>A12</TD><TD>A13</TD><TD>A14</TD><TD>A15</TD><TD>A16</TD><TD>A17</TD><TD>A18</TD><TD>A19</TD><TD>A20</TD><TD>Other_A</TD><TD>M1</TD><TD>M2</TD><TD>M3</TD><TD>M4</TD><TD>Other_M</TD><TD>O1</TD><TD>O2</TD><TD>O3</TD><TD>O4</TD><TD>O5</TD><TD>O6</TD><TD>O7</TD><TD>O8</TD><TD>O9</TD><TD>O10</TD><TD>Region</TD><TD>Age</TD><TD>Gender</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-0.95472</TD><TD>0.383248</TD><TD>1</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-1.11397</TD><TD>0.995225</TD><TD>1</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>7</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0.080419</TD><TD>-0.22873</TD><TD>2</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-0.71584</TD><TD>-0.22873</TD><TD>1</TD></TR><TR><TD>104</TD><TD>2.136383</TD><TD>1</TD><TD>8</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-0.63622</TD><TD>-0.22873</TD><TD>2</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>5</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0.637801</TD><TD>0.383248</TD><TD>2</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0.080419</TD><TD>-0.22873</TD><TD>1</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0.239671</TD><TD>0.995225</TD><TD>2</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0.558175</TD><TD>0.383248</TD><TD>1</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>2</TD><TD>8</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>1.274809</TD><TD>-0.22873</TD><TD>2</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>1</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>-0.63622</TD><TD>-0.84071</TD><TD>2</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>3</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1.513687</TD><TD>-0.84071</TD><TD>1</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>8</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>-0.63622</TD><TD>-0.84071</TD><TD>1</TD></TR><TR><TD>104</TD><TD>-0.2383</TD><TD>1</TD><TD>3</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0.319297</TD><TD>0.383248</TD><TD>2</TD></TR></TBODY></TABLE> Wed, 19 Oct 2016 06:48:24 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305594#M60929 deega 2016-10-19T06:48:24Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305620#M60930 <P>I saw your data is category data not continuous data.</P> <P>Firstly use PROC DISTANCE to get these category data's distance, then run PROC CLUSTER.</P> <P>Search the following keyword at support.sas.com</P> <P>categroy data cluster analysis</P> Wed, 19 Oct 2016 10:06:02 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305620#M60930 Ksharp 2016-10-19T10:06:02Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305667#M60931 Before Fastclus I tried distance and cluster but since I have large dataset (10000000 records) and I got error that it can not be used on such large data. Is there any other way ? Wed, 19 Oct 2016 13:47:04 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305667#M60931 deega 2016-10-19T13:47:04Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305713#M60933 <P>What code are you using for PROC FASTCLUS?</P> Wed, 19 Oct 2016 17:11:10 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305713#M60933 Rick_SAS 2016-10-19T17:11:10Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305859#M60943 <P>Here is my code</P><P>&nbsp;</P><P>proc fastclus data=std out=clus maxclusters=10;<BR />var x--y;<BR />run;</P><P>&nbsp;</P><P>My variables are mix of categorical and continuous.</P> Thu, 20 Oct 2016 04:13:45 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305859#M60943 deega 2016-10-20T04:13:45Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305917#M60947 <P>Cluster Analysis can't be apply to mixed data(<SPAN>categorical and continuous).</SPAN></P> Thu, 20 Oct 2016 10:52:30 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305917#M60947 Ksharp 2016-10-20T10:52:30Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305960#M60948 <P><SPAN>Can we do cluster analysis only with continous varaibles?</SPAN></P> Thu, 20 Oct 2016 14:46:37 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/305960#M60948 Babloo 2016-10-20T14:46:37Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306131#M60966 OK. If I convert my data to categorical as most of it is categorical then how can I cluster them, given that its large dataset. Fri, 21 Oct 2016 00:29:41 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306131#M60966 deega 2016-10-21T00:29:41Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306186#M60971 <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/18408">@Ksharp</a><BR />I might sound weird but is there a way to convert categorical data to continuous data ? Fri, 21 Oct 2016 05:50:18 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306186#M60971 deega 2016-10-21T05:50:18Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306193#M60973 <P>No way .</P> Fri, 21 Oct 2016 07:15:37 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306193#M60973 Ksharp 2016-10-21T07:15:37Z Re: segmentation using fastclus https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306198#M60974 <P>Or you could take a look this:</P> <P>&nbsp;</P> <P>Overview: PRINQUAL Procedure<BR />The PRINQUAL procedure performs principal component analysis (PCA) of qualitative, quantitative, or<BR />mixed data. PROC PRINQUAL is based on the work of Kruskal and Shepard (1974); Young, Takane, and</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>polt two primary component at X-Y asix . and see which one belong to a cluster.<BR />&nbsp;</P> Fri, 21 Oct 2016 07:34:35 GMT https://communities.sas.com/t5/SAS-Procedures/segmentation-using-fastclus/m-p/306198#M60974 Ksharp 2016-10-21T07:34:35Z