Ricardo,

I don't understand what you are trying to do. I understand that you have data on the same scale, assumed to be a set of items, from two different groups, file1 and file2. So you do frequencies on file1-var1. Depending on how similar the two groups are, scores for the second group, which you are calling 'var2', will be more or less similar in distribution but maybe not exact values. So suppose the file1-var1 and file2-var2 distributions are

Var1 Value Count Percent Cum Percent 1.262 8 8.0 8.0 1.579 6 6.0 14.0 1.903 10 10.0 24.0 2.345 4 4.0 28.0 2.674 12 12.0 40.0 2.888 13 13.0 53.0 3.002 19 19.0 72.0 3.451 19 19.0 91.0 3.897 9 9.0 100.0 ---- ---- 100 100

Var2 Value Count Percent Cum Percent 1.362 4 4.0 4.0 1.779 1 1.0 5.0 2.003 15 15.0 20.0 2.345 13 13.0 33.0 2.574 9 9.0 42.0 2.898 27 27.0 69.0 3.106 11 11.0 80.0 3.651 13 13.0 93.0 3.800 7 7.0 100.0 ---- ---- 100 100

Tell us how you are going to convert var2 to var1.

Gene Maguin

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Ricardo Primi Sent: Sunday, September 11, 2011 7:17 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Apply frequency table to recode a value

Dear list members

I have a table of cumulative frequencies for values calculated in one file (see below Var1 that range from from -4.73 to 4.83). Now, in a new file, I want to recode var2, that is in the same scale of Var1, applying the cumulative percent based on this table. For instance if a value of Var2 is -2.11 it would be recoded to 1.4 ; if -1.80 to 3.2 and so forth . Any idea of a easy way to do that ?

Thanks Ricardo Primi

Var1 Cum Freq. -4.736 .0 -3.519 .1 -2.744 .4 -2.259 1.4 -1.892 3.2 -1.588 6.2 -1.322 10.5 -1.081 16.2 -.857 23.0 -.644 31.1 -.438 39.8 -.235 49.1 -.034 58.6 .169 67.5 .376 76.0 .590 83.4 .814 89.4 1.052 94.0 1.309 97.0 1.594 98.8 1.919 99.6 2.308 99.9 2.816 100.0 3.613 100.0 4.853 100.0

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD