Linking OMS output to unique ID's in primary database

Posted by Patty Zorbas Ferssizidis on Mar 22, 2011; 2:59pm
URL: http://spssx-discussion.165.s1.nabble.com/Linking-OMS-output-to-unique-ID-s-in-primary-database-tp4257034.html

I have a data set that contains multiple rows (i.e, days) of data per participant (i.e., ID). I am trying to compute the intraclass correlation coefficient (based on 6 variables) for each unique ID across the multiple entries/days for this ID. Then I need to link the coefficient to each unique ID in the primary database so that it can be used for further analysis. Using a split file command (to separate output by ID) and the OMS feature (with dimensions in a single row), I have been able to save a new data file containing the coefficients. However, the coefficients are not linked to each unique ID and therefore, cannot be merged into the primary database and matched by ID. Because the ICC does not compute for every ID (e.g., some ID's have no data or for some reason cannot be calculated), I get fewer ICC's than I have ID's. Is there a way to match the ICC from the output to the ID from which it was computed? If that is not possible, I suppose an alternative would be to create syntax to compute the ICC's (any ideas on how to go about that would also be helpful if it's my only option). Many thanks in advance.

Patty