I don't think you have a good idea here. and also don't need to make a new dataset. proc corr only consider the correlation of two variables which has bivariate normal distribution ,it wouldn't consider the influence of other variable(i.e. other film ) to a variable ----- which are named partial correlation. I think you should use Cluster Analysis to see which film belong to which cluster. 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. Ksharp
... View more