Hi,
I have two questions:
1. I have a matrix which is created from a raw data. There are two variables in that data: One is candidates and the other is probabilities. Candidates are in rows and columns (columns and rows have the same candidates). The probabilities are in the intersection of candidates. For example, probability for candidate 87 and 627 is 0.000034. In the matrix I have only these probabilities. I changed the missing values to 0. But, in the matrix probability for candidate 627 and candidate 87 is also 0.000034. When I use
data matrix; set matrix; array change _numeric_; do over change; if change=. then change=0; end; run ;
that code it changes all of missing values. I want to have the probabilities for only one of the pairs, for the other same pair I want to it missing and for rest of the cells I want to have 0. How can I do that?
2. I'd like to define probabilities as a variable. I'm going to use that matrix for cluster analysis. When I use code for cluster analysis, it says 'ERROR: Variable RT_PROB not found.'. So I need to define that variable too. How can I do that?
3. The code and raw data are attached.
4.Thanks
... View more