topic Correlation Analysis of Multiple Binary Variables in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47146#M12628 <HTML><HEAD></HEAD><BODY><P>PLEASE Help!</P><P>I have a dataset of customers who are flagged with whether they have viewed a film or not. Each row represents a customer. Each column represents a film, where a 0 or 1 states whether they have seen that film or not. I need to work out the correlation between these films i.e. if people watch X they are also most likely to have watched Y. A simple way would be to cross tab all variables so that I create a dataset with all films as a row and all films as a column, with the count of customers who had seen each film pairing. I don't know how to do this so I thought if my variables were continuous, a standard PROC CORR would give me all the information I need in matrix form i.e. the correlation coefficient and the frequency of customers. But how do I create this when my variables are binary? Or can anyone help me with creating the count matrix?</P></BODY></HTML> Wed, 28 Mar 2012 16:04:19 GMT AmandaEHS 2012-03-28T16:04:19Z Correlation Analysis of Multiple Binary Variables https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47146#M12628 <HTML><HEAD></HEAD><BODY><P>PLEASE Help!</P><P>I have a dataset of customers who are flagged with whether they have viewed a film or not. Each row represents a customer. Each column represents a film, where a 0 or 1 states whether they have seen that film or not. I need to work out the correlation between these films i.e. if people watch X they are also most likely to have watched Y. A simple way would be to cross tab all variables so that I create a dataset with all films as a row and all films as a column, with the count of customers who had seen each film pairing. I don't know how to do this so I thought if my variables were continuous, a standard PROC CORR would give me all the information I need in matrix form i.e. the correlation coefficient and the frequency of customers. But how do I create this when my variables are binary? Or can anyone help me with creating the count matrix?</P></BODY></HTML> Wed, 28 Mar 2012 16:04:19 GMT https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47146#M12628 AmandaEHS 2012-03-28T16:04:19Z Correlation Analysis of Multiple Binary Variables https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47147#M12629 <HTML><HEAD></HEAD><BODY><P> You want to calculate a phi coefficient as a measure of association for binary data.&nbsp; If you run the usual Pearson correlation in Proc Corr on binary data, the measure you get will be the phi coefficient, as they are equivalent.</P></BODY></HTML> Wed, 28 Mar 2012 17:11:10 GMT https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47147#M12629 mfisher 2012-03-28T17:11:10Z Correlation Analysis of Multiple Binary Variables https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47148#M12630 <HTML><HEAD></HEAD><BODY><P>I don't think you have a good idea here. and also don't need to make a new dataset.</P><P>proc corr only consider the correlation of&nbsp; two variables which has bivariate normal distribution ,it&nbsp; wouldn't consider the influence of other variable(i.e. other film ) to a variable ----- which are named partial correlation.</P><P></P><P>I think you should use Cluster Analysis to see which film belong to which cluster.</P><P></P><P>I highly recommend you to post it at SAS Statistical Procedure , where has some experts such as Steve, lvm, Rick, they are all seasoned statistician . Thay can give you a whole explanation about your question.</P><P></P><P></P><P>Ksharp</P></BODY></HTML> Thu, 29 Mar 2012 03:14:39 GMT https://communities.sas.com/t5/SAS-Procedures/Correlation-Analysis-of-Multiple-Binary-Variables/m-p/47148#M12630 Ksharp 2012-03-29T03:14:39Z