Rel 21 merge failing
Locked
 
|
I'm doing a merge in release 21 and it appears that the first time it doesn't find a match it quits???
I have a file of 1,575 records and I am looking to add a variable from a file of 142,578 records. On record 132 there is no match so it quits??? Any solutions?????? Thank you Barbara Lombardo - Please consider the environment before printing this email. - ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 |
|
|
Please post syntax and (any) messages. Gene Maguin
-----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Lombardo, Barbara Sent: Tuesday, August 27, 2013 1:19 PM To: [hidden email] Subject: Rel 21 merge failing I'm doing a merge in release 21 and it appears that the first time it doesn't find a match it quits??? I have a file of 1,575 records and I am looking to add a variable from a file of 142,578 records. On record 132 there is no match so it quits??? Any solutions?????? Thank you Barbara Lombardo - Please consider the environment before printing this email. - ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 |
|
|
I'm sure this isn't what you want to hear but why not use a match files command with the table subcommand and the keep subcommand? As I read the syntax, you want to add the value for first_term from the 'ft' file given a match on student and then keep the indicated list of variables. Am I misunderstanding what you want to do?
Re: excel 10. I don't know. Why not edit the form name? Gene Maguin -----Original Message----- From: Lombardo, Barbara [mailto:[hidden email]] Sent: Tuesday, August 27, 2013 2:27 PM To: Maguin, Eugene Subject: RE: Rel 21 merge failing I have attached the output, it acts like it completed it! DATASET ACTIVATE DataSet1. STAR JOIN /SELECT t0.ReportingYear, t0.AcadProgram, t0.CIP, t0.Degree, t0.Date, t0.StartDate, t0.CCD, t0.ACAD.CCD.DATE, t0.RESIDENCE.STATE, t0.PrimaryEthnic, t0.Ethnics, t0.PrimaryRaces, t0.Races, t0.SSN, t0.CumGPA, t0.CumGPACredits, t0.Term, t0.CCDDate, t0.DegreeDate, t0.NoYears, t0.ACAD.CREDENTIALS.ADDDATE, t0.ACAD.CREDENTIALS.CHGDATE, t0.Zip, t0.foreign, t0.admit_st, t0.GOALS, t0.InstitutionAttend, t0.HOMELANGUAGE, t0.EDUCGOALS, t0.thesisST, t0.EthnicDesc, t0.StartTerm, t0.Birthdate, t0.Disabilities, t0.Gender, t0.ResidenceCounty, t0.CmplMonths, t0.D01, t0.D02, t0.stutxt, t0.D03, t0.D04, t0.D05, t0.D07, t0.D08, t0.D09, t0.B1, t0.STU, t0.VAR00004, t0.PROG_2, t0.PROG_3, t0.D10, t0.D11, t0.D12, t0.D13, t0.D14, t0.D15, t0.D16, t0.D17, t0.D18, t0.D19, t0.D20, t0.D21, t0.D22, t0.D23, t0.D24, t0.D25, t0.D26, t0.EOF, t0.PrimaryLast, t0.filter_$, t0.Months_to_complete, t1.first_term /FROM * AS t0 /JOIN 'ft' AS t1 ON t0.student=t1.student /OUTFILE FILE=*. This is major as I am in the middle of an important project and have no previous release of SPSS. Additional problem I found is that if you have an EXCEL 10 spreadsheet with a form name containing a space "first time", SPSS will not read it in. Barbara Lombardo Sr. Applications Specialist/SQL Programmer II Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 P Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Maguin, Eugene Sent: Tuesday, August 27, 2013 1:27 PM To: [hidden email] Subject: Re: Rel 21 merge failing Please post syntax and (any) messages. Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Lombardo, Barbara Sent: Tuesday, August 27, 2013 1:19 PM To: [hidden email] Subject: Rel 21 merge failing I'm doing a merge in release 21 and it appears that the first time it doesn't find a match it quits??? I have a file of 1,575 records and I am looking to add a variable from a file of 142,578 records. On record 132 there is no match so it quits??? Any solutions?????? Thank you Barbara Lombardo - Please consider the environment before printing this email. - ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 [hidden email] (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 |
|
|
Let's turn this problem around. You say it stops on record 132. How do you know that? Does that mean that records 1-131 have valid data for first_term and records 132-1500+ do not and that the corresponding record in the ft file does have valid data? I'd kind of bet that you have both data files open at the same time and when you put the files side by side can you identify other records in the second file that should have matched?
I'd bet you get the same result if you use match files file= /table= /by. (make sure the files are sorted. Thanks, Rick for pointing that out.) Test it. I bet the problem is in the data files somewhere. Gene Maguin -----Original Message----- From: Lombardo, Barbara [mailto:[hidden email]] Sent: Tuesday, August 27, 2013 3:29 PM To: Maguin, Eugene Subject: RE: Rel 21 merge failing You have it correct. This is how I have done it for 18 years using SPSS, never a problem. I think it is a bug in the software, it should not just drop out on the first non match??? I'm not familiar with your suggestion?? Thanks Barbara Lombardo Sr. Applications Specialist/SQL Programmer II Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 � Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Maguin, Eugene Sent: Tuesday, August 27, 2013 3:17 PM To: [hidden email] Subject: Re: Rel 21 merge failing I'm sure this isn't what you want to hear but why not use a match files command with the table subcommand and the keep subcommand? As I read the syntax, you want to add the value for first_term from the 'ft' file given a match on student and then keep the indicated list of variables. Am I misunderstanding what you want to do? Re: excel 10. I don't know. Why not edit the form name? Gene Maguin -----Original Message----- From: Lombardo, Barbara [mailto:[hidden email]] Sent: Tuesday, August 27, 2013 2:27 PM To: Maguin, Eugene Subject: RE: Rel 21 merge failing I have attached the output, it acts like it completed it! DATASET ACTIVATE DataSet1. STAR JOIN /SELECT t0.ReportingYear, t0.AcadProgram, t0.CIP, t0.Degree, t0.Date, t0.StartDate, t0.CCD, t0.ACAD.CCD.DATE, t0.RESIDENCE.STATE, t0.PrimaryEthnic, t0.Ethnics, t0.PrimaryRaces, t0.Races, t0.SSN, t0.CumGPA, t0.CumGPACredits, t0.Term, t0.CCDDate, t0.DegreeDate, t0.NoYears, t0.ACAD.CREDENTIALS.ADDDATE, t0.ACAD.CREDENTIALS.CHGDATE, t0.Zip, t0.foreign, t0.admit_st, t0.GOALS, t0.InstitutionAttend, t0.HOMELANGUAGE, t0.EDUCGOALS, t0.thesisST, t0.EthnicDesc, t0.StartTerm, t0.Birthdate, t0.Disabilities, t0.Gender, t0.ResidenceCounty, t0.CmplMonths, t0.D01, t0.D02, t0.stutxt, t0.D03, t0.D04, t0.D05, t0.D07, t0.D08, t0.D09, t0.B1, t0.STU, t0.VAR00004, t0.PROG_2, t0.PROG_3, t0.D10, t0.D11, t0.D12, t0.D13, t0.D14, t0.D15, t0.D16, t0.D17, t0.D18, t0.D19, t0.D20, t0.D21, t0.D22, t0.D23, t0.D24, t0.D25, t0.D26, t0.EOF, t0.PrimaryLast, t0.filter_$, t0.Months_to_complete, t1.first_term /FROM * AS t0 /JOIN 'ft' AS t1 ON t0.student=t1.student /OUTFILE FILE=*. This is major as I am in the middle of an important project and have no previous release of SPSS. Additional problem I found is that if you have an EXCEL 10 spreadsheet with a form name containing a space "first time", SPSS will not read it in. Barbara Lombardo Sr. Applications Specialist/SQL Programmer II Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 P Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Maguin, Eugene Sent: Tuesday, August 27, 2013 1:27 PM To: [hidden email] Subject: Re: Rel 21 merge failing Please post syntax and (any) messages. Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Lombardo, Barbara Sent: Tuesday, August 27, 2013 1:19 PM To: [hidden email] Subject: Rel 21 merge failing I'm doing a merge in release 21 and it appears that the first time it doesn't find a match it quits??? I have a file of 1,575 records and I am looking to add a variable from a file of 142,578 records. On record 132 there is no match so it quits??? Any solutions?????? Thank you Barbara Lombardo - Please consider the environment before printing this email. - ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 [hidden email] (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 [hidden email] (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 |
Administrator
|
In reply to this post by Maguin, Eugene
I'm with Gene here--i.e., I wonder if the problem is arising from using STAR JOIN rather than MATCH FILES. (I don't seem to have STAR JOIN in my version, but found via Google some discussion of users having problems with it--e.g., https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014903590; and search for "star join" on this page: http://www-01.ibm.com/support/docview.wss?uid=swg27038029. Have you applied that patch?)
It sounds like you want to do something like the following (substituting file and variable names etc as necessary): NEW FILE. DATASET CLOSE all. GET FILE = "C:\MyPath\File1.sav". SORT CASES by ID. DATASET NAME file1. GET FILE = "C:\MyPath\File2.sav". SORT CASES by ID. DELETE VARIABLES { all variables apart from ID and any variables you want in the merged file } DATASET NAME file2. MATCH FILES file = file1 / IN = file1 / file = file2 / IN = file2 / by ID . EXECUTE. DATASET NAME merged. DATASET activate merged. DATASET close file1. DATASET close file2. On the DELETE VARIABLES line above, you can use the keyword TO when deleting a range of variables. HTH.
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
|
|
Bruce, Barbara needs to do a table match and not a file match since she is adding a variable to an existing set of cases. Gene
-----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bruce Weaver Sent: Tuesday, August 27, 2013 4:23 PM To: [hidden email] Subject: Re: Rel 21 merge failing I'm with Gene here--i.e., I wonder if the problem is arising from using STAR JOIN rather than MATCH FILES. (I don't seem to have STAR JOIN in my version, but found via Google some discussion of users having problems with it--e.g., https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014903590; and search for "star join" on this page: http://www-01.ibm.com/support/docview.wss?uid=swg27038029. Have you applied that patch?) It /sounds/ like you want to do something like the following (substituting file and variable names etc as necessary): NEW FILE. DATASET CLOSE all. GET FILE = "C:\MyPath\File1.sav". SORT CASES by ID. DATASET NAME file1. GET FILE = "C:\MyPath\File2.sav". SORT CASES by ID. DELETE VARIABLES { all variables apart from ID and any variables you want in the merged file } DATASET NAME file2. MATCH FILES file = file1 / IN = file1 / file = file2 / IN = file2 / by ID . EXECUTE. DATASET NAME merged. DATASET activate merged. DATASET close file1. DATASET close file2. On the DELETE VARIABLES line above, you can use the keyword TO when deleting a range of variables. HTH. Maguin, Eugene wrote > I'm sure this isn't what you want to hear but why not use a match > files command with the table subcommand and the keep subcommand? As I > read the syntax, you want to add the value for first_term from the > 'ft' file given a match on student and then keep the indicated list of > variables. Am I misunderstanding what you want to do? > > Re: excel 10. I don't know. Why not edit the form name? > Gene Maguin > > > -----Original Message----- > From: Lombardo, Barbara [mailto: > BLombardo@ > ] > Sent: Tuesday, August 27, 2013 2:27 PM > To: Maguin, Eugene > Subject: RE: Rel 21 merge failing > > I have attached the output, it acts like it completed it! > > DATASET ACTIVATE DataSet1. > STAR JOIN > /SELECT t0.ReportingYear, t0.AcadProgram, t0.CIP, t0.Degree, > t0.Date, t0.StartDate, t0.CCD, t0.ACAD.CCD.DATE, t0.RESIDENCE.STATE, > t0.PrimaryEthnic, t0.Ethnics, t0.PrimaryRaces, t0.Races, t0.SSN, > t0.CumGPA, t0.CumGPACredits, t0.Term, t0.CCDDate, t0.DegreeDate, > t0.NoYears, t0.ACAD.CREDENTIALS.ADDDATE, t0.ACAD.CREDENTIALS.CHGDATE, > t0.Zip, t0.foreign, t0.admit_st, t0.GOALS, t0.InstitutionAttend, > t0.HOMELANGUAGE, t0.EDUCGOALS, t0.thesisST, t0.EthnicDesc, > t0.StartTerm, t0.Birthdate, t0.Disabilities, t0.Gender, > t0.ResidenceCounty, t0.CmplMonths, t0.D01, t0.D02, t0.stutxt, t0.D03, > t0.D04, t0.D05, t0.D07, t0.D08, t0.D09, t0.B1, t0.STU, t0.VAR00004, > t0.PROG_2, t0.PROG_3, t0.D10, t0.D11, t0.D12, t0.D13, t0.D14, t0.D15, > t0.D16, t0.D17, t0.D18, t0.D19, t0.D20, t0.D21, t0.D22, t0.D23, > t0.D24, t0.D25, t0.D26, t0.EOF, t0.PrimaryLast, t0.filter_$, > t0.Months_to_complete, t1.first_term > /FROM * AS t0 > /JOIN 'ft' AS t1 > ON t0.student=t1.student > /OUTFILE FILE=*. > > This is major as I am in the middle of an important project and have > no previous release of SPSS. > > Additional problem I found is that if you have an EXCEL 10 spreadsheet > with a form name containing a space "first time", SPSS will not read > it in. > > > > > Barbara Lombardo > Sr. Applications Specialist/SQL Programmer II Institutional Research > Camden County College Blackwood NJ 08012 > Office: 856-374-4961 > Fax: 856-374-5016 > > P Think before you print. > CONFIDENTIALITY: This e-mail (including any attachments) may contain > confidential, proprietary and privileged information, and unauthorized > disclosure or use is prohibited. If you received this e-mail in error, > please notify the sender and delete this e-mail from your system. > > > -----Original Message----- > From: SPSSX(r) Discussion [mailto: > SPSSX-L@.UGA > ] On Behalf Of Maguin, Eugene > Sent: Tuesday, August 27, 2013 1:27 PM > To: > SPSSX-L@.UGA > Subject: Re: Rel 21 merge failing > > Please post syntax and (any) messages. Gene Maguin > > -----Original Message----- > From: SPSSX(r) Discussion [mailto: > SPSSX-L@.UGA > ] On Behalf Of Lombardo, Barbara > Sent: Tuesday, August 27, 2013 1:19 PM > To: > SPSSX-L@.UGA > Subject: Rel 21 merge failing > > I'm doing a merge in release 21 and it appears that the first time it > doesn't find a match it quits??? > > I have a file of 1,575 records and I am looking to add a variable from > a file of 142,578 records. On record 132 there is no match so it quits??? > > Any solutions?????? > > > Thank you > > > Barbara Lombardo > > - Please consider the environment before printing this email. - > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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@.UGA > (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@.UGA > (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 ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Rel-21-merge-failing-tp5721754p5721761.html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 |
|
|
In reply to this post by Maguin, Eugene
Barbara: I suspect you've been using the
dialog interface for 18 years, since STAR JOIN didn't exist until a few
years ago. The dialog interface used to always generate MATCH FILES syntax,
which requires files sorted by the ID variables.
As noted in a previous response, STAR JOIN does not include cases from the second file that don't have matching IDs in the first file, whereas MATCH FILES does. The basic MATCH FILES syntax is simple: For a one-to-one match: MATCH FILES FILE=file1 /file=file2 /BY idvar. For a one-to-many match: MATCH FILES FILE=case data file /TABLE=lookup table file /BY idvar. Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: "Maguin, Eugene" <[hidden email]> To: [hidden email], Date: 08/27/2013 03:00 PM Subject: Re: Rel 21 merge failing Sent by: "SPSSX(r) Discussion" <[hidden email]> Let's turn this problem around. You say it stops on record 132. How do you know that? Does that mean that records 1-131 have valid data for first_term and records 132-1500+ do not and that the corresponding record in the ft file does have valid data? I'd kind of bet that you have both data files open at the same time and when you put the files side by side can you identify other records in the second file that should have matched? I'd bet you get the same result if you use match files file= /table= /by. (make sure the files are sorted. Thanks, Rick for pointing that out.) Test it. I bet the problem is in the data files somewhere. Gene Maguin -----Original Message----- From: Lombardo, Barbara [mailto:BLombardo@...] Sent: Tuesday, August 27, 2013 3:29 PM To: Maguin, Eugene Subject: RE: Rel 21 merge failing You have it correct. This is how I have done it for 18 years using SPSS, never a problem. I think it is a bug in the software, it should not just drop out on the first non match??? I'm not familiar with your suggestion?? Thanks Barbara Lombardo Sr. Applications Specialist/SQL Programmer II Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 �� Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. -----Original Message----- From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Maguin, Eugene Sent: Tuesday, August 27, 2013 3:17 PM To: [hidden email] Subject: Re: Rel 21 merge failing I'm sure this isn't what you want to hear but why not use a match files command with the table subcommand and the keep subcommand? As I read the syntax, you want to add the value for first_term from the 'ft' file given a match on student and then keep the indicated list of variables. Am I misunderstanding what you want to do? Re: excel 10. I don't know. Why not edit the form name? Gene Maguin -----Original Message----- From: Lombardo, Barbara [mailto:BLombardo@...] Sent: Tuesday, August 27, 2013 2:27 PM To: Maguin, Eugene Subject: RE: Rel 21 merge failing I have attached the output, it acts like it completed it! DATASET ACTIVATE DataSet1. STAR JOIN /SELECT t0.ReportingYear, t0.AcadProgram, t0.CIP, t0.Degree, t0.Date, t0.StartDate, t0.CCD, t0.ACAD.CCD.DATE, t0.RESIDENCE.STATE, t0.PrimaryEthnic, t0.Ethnics, t0.PrimaryRaces, t0.Races, t0.SSN, t0.CumGPA, t0.CumGPACredits, t0.Term, t0.CCDDate, t0.DegreeDate, t0.NoYears, t0.ACAD.CREDENTIALS.ADDDATE, t0.ACAD.CREDENTIALS.CHGDATE, t0.Zip, t0.foreign, t0.admit_st, t0.GOALS, t0.InstitutionAttend, t0.HOMELANGUAGE, t0.EDUCGOALS, t0.thesisST, t0.EthnicDesc, t0.StartTerm, t0.Birthdate, t0.Disabilities, t0.Gender, t0.ResidenceCounty, t0.CmplMonths, t0.D01, t0.D02, t0.stutxt, t0.D03, t0.D04, t0.D05, t0.D07, t0.D08, t0.D09, t0.B1, t0.STU, t0.VAR00004, t0.PROG_2, t0.PROG_3, t0.D10, t0.D11, t0.D12, t0.D13, t0.D14, t0.D15, t0.D16, t0.D17, t0.D18, t0.D19, t0.D20, t0.D21, t0.D22, t0.D23, t0.D24, t0.D25, t0.D26, t0.EOF, t0.PrimaryLast, t0.filter_$, t0.Months_to_complete, t1.first_term /FROM * AS t0 /JOIN 'ft' AS t1 ON t0.student=t1.student /OUTFILE FILE=*. This is major as I am in the middle of an important project and have no previous release of SPSS. Additional problem I found is that if you have an EXCEL 10 spreadsheet with a form name containing a space "first time", SPSS will not read it in. Barbara Lombardo Sr. Applications Specialist/SQL Programmer II Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 P Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. -----Original Message----- From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Maguin, Eugene Sent: Tuesday, August 27, 2013 1:27 PM To: [hidden email] Subject: Re: Rel 21 merge failing Please post syntax and (any) messages. Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Lombardo, Barbara Sent: Tuesday, August 27, 2013 1:19 PM To: [hidden email] Subject: Rel 21 merge failing I'm doing a merge in release 21 and it appears that the first time it doesn't find a match it quits??? I have a file of 1,575 records and I am looking to add a variable from a file of 142,578 records. On record 132 there is no match so it quits??? Any solutions?????? Thank you Barbara Lombardo - Please consider the environment before printing this email. - ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 [hidden email] (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 [hidden email] (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 [hidden email] (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 |
|
Administrator
|
In reply to this post by Maguin, Eugene
Ah, okay. And Rick showed how to do that in his post.
For a one-to-many match: MATCH FILES FILE=case data file /TABLE=lookup table file /BY idvar.
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |