Recoding String to String
Locked
 
|
I am recoding numbers that are coded as string to a string that has the
description. I receive an error code when it is run: 191 RECODE The preceding RECODE specifies a value to be recoded that is longer than some variable(s) in the recode. The shorter values will be padded with blanks for the comparison. Text: ) The data is processed and the new variable name is created but I want to be rid of the error code. Any help is appreciated. Thank you, Shannon STRING FacilityName (A75). RECODE FacilityCode ('2'='Seaview Community Services') ('3'='Railbelt Mental Health & Addictions') ('5'='Providence Valdez Counseling Center') ('7'='Gastineau Human Services, Corp.') ('8'='Youth Advocates of Sitka') ('9'='Sitka Counseling and Prevention Services') ('11'='Tok Area Counseling Center') ('12'='Tanana Chiefs Conference, Inc.') ('13'='Interior Aids Association') ('14'='Fairbanks Native Association') ('15'='Aleutian/Pribilof Island Assoc.') ('17'='City of Galena (Yukon Koyukuk MH & Alcohol Program)') ('19'='Salvation Army - Clitheroe Center') ('20'='Volunteers of America of Alaska') ('21'='Assets') ('22'='Hoonah Indian Association') ===================== 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 |
|
|
Is there a (relatively) easy way to compare SPSS files?
I am trying to correct a problem that has crept in where at least one variable has got messed up. I need to figure out how far back in the versions I need to go, and whether I can simply replace that variable with the original from the Excel file that was downloaded from the survey tool. If I can't just replace the variable in a later version of the SPSS file there is probably quite a bit more work to recode again, and - more important - checking / redoing coding from open-ends. I'm doing spot checks right now, but it would be great to find a way to test the integrity of multiple variables. Thanks Mike ===================== 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 Shannon Deike
>I am recoding numbers that are coded as string to a string that has the
>description. > >I receive an error code when it is run: > >191 RECODE The preceding RECODE specifies a value to be recoded that >is longer than some variable(s) in the recode. It looks like you left "INTO FacilityName" off the end of your RECODE statement. ===================== 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 Mike Pritchard
it can be easily done if one has SPSS data entry (builder) module. It allows for very easy transformation of two regular spss data files into "builder" files and then has a very nice and easy way to compare the two files and to produce a user-friendly report.
bozena ________________________________________ From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Mike Pritchard [[hidden email]] Sent: Friday, October 30, 2009 6:29 PM To: [hidden email] Subject: Compare databases Is there a (relatively) easy way to compare SPSS files? I am trying to correct a problem that has crept in where at least one variable has got messed up. I need to figure out how far back in the versions I need to go, and whether I can simply replace that variable with the original from the Excel file that was downloaded from the survey tool. If I can't just replace the variable in a later version of the SPSS file there is probably quite a bit more work to recode again, and - more important - checking / redoing coding from open-ends. I'm doing spot checks right now, but it would be great to find a way to test the integrity of multiple variables. Thanks Mike ===================== 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 Shannon Deike
Richard Bristow replied to let me know that I left off the
INTO "FacilityName"; however, I did not post the whole syntax for this recode. It is: STRING FacilityName (A75). RECODE FacilityCode ('2'='Seaview Community Services') ('3'='Railbelt Mental Health & Addictions') ('5'='Providence Valdez Counseling Center') ('7'='Gastineau Human Services, Corp.') ('8'='Youth Advocates of Sitka') ('9'='Sitka Counseling and Prevention Services') ('11'='Tok Area Counseling Center') ('12'='Tanana Chiefs Conference, Inc.') ('13'='Interior Aids Association') ('14'='Fairbanks Native Association') ('15'='Aleutian/Pribilof Island Assoc.') ('17'='City of Galena (Yukon Koyukuk MH & Alcohol Program)') ('19'='Salvation Army - Clitheroe Center') ('20'='Volunteers of America of Alaska') ('21'='Assets') ('22'='Hoonah Indian Association') ('23'='Alaska Family Services') ('24'='Daybreak, Inc') ('25'='Narcotic Drug Treatment Center') ('27'='Providence Kodiak Island Counseling Center') ('30'='Kenai Peninsula Community Care Center') ('31'='Cook Inlet Council on Alcohol & Drug Abuse') ('32'='Juneau Alliance for Mental Health, Inc.') ('34'='Communities Organized for Health Options') ('35'='Lynn Canal Counseling Center')('36'='SouthEast Alaska Regional Health Consortium') ('37'='Polaris House') ('38'='Cordova Community Medical Clinic - dba - Sound Alternatives') ('39'='Alaska Islands Community Services') ('40'='Petersburg Mental Health Services') ('42'='Salvation Army - Booth Memorial') ('43'='North Slope Borough') ('44'='Ketchikan Indian Corp.') ('45'='Akeela Treatment Services, Inc.') ('46'='ARC of Anchorage') ('47'='Southcentral Foundation') ('48'='Copper River Native Association') ('50'='Community Connections') ('51'='Family Centered Services of Alaska') ('52'='Hope Community Resources, Inc.') ('53'='Norton Sound Health Corp.') ('54'='Kenaitze Indian Tribe') ('55'='Maniilaq Association') ('56'='Gateway Center for Human Services') ('65'='Yukon-Kuskokwim Health Corporation') ('66'='Central Peninsula General Hospital') ('67'='Cook Inlet Tribal Council, Inc.') ('68'='Access Alaska') ('69'='Eastern Aleutian Tribes Inc') ('70'='Frontier Community Services') ('71'='South Peninsula Behavioral Health Services, Inc.') ('72'='Juneau Youth Services, Inc.') ('73'='Mat-Su Health Services, Inc.') ('74'='Bristol Bay Area Health Corporation') ('74'='Bristol Bay Area Health Corporation') ('75'='Denali Family Services (Alternatives CMHC)') ('76'='Fairbanks Community Behavioral Health Center') ('77'='Anchorage Community Mental Health Svs') ('78'='Rainforest Recovery Center') ('79'='Presbyterian Hospitality House') ('80'='Central Peninsula Counseling Services') ('81'='Providence Health System (Providence Crisis Respite Center)') ('82'='CHOICES') ('86'='Metlakatla Indian Community') ('12-14'='Tanana Chiefs Conference, Inc.') ('16'='Alaska Addiction Rehab Service - Nugen''s Ranch') ('59'='Alaska Children''s Services') INTO FacilityName . VARIABLE LABELS FacilityName 'Facility Names' . ===================== 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 |
|
|
At 07:06 PM 10/30/2009, Shannon Deike wrote:
Richard Ristow replied to let me know that I left off the INTO FacilityName; however, I did not post the whole syntax for this recode.... Running in all the text as a continuous stream, like that, makes it very hard to read; you'll see in a moment, why that matters. I reformatted it, and here's from a run: STRING FacilityName (A75). RECODE FacilityCode ('2'='Seaview Community Services') ('3'='Railbelt Mental Health & Addictions') ('5'='Providence Valdez Counseling Center') ('7'='Gastineau Human Services, Corp.') ('8'='Youth Advocates of Sitka') ('9'='Sitka Counseling and Prevention Services') ('11'='Tok Area Counseling Center') ('12'='Tanana Chiefs Conference, Inc.') ('13'='Interior Aids Association') ('14'='Fairbanks Native Association') ('15'='Aleutian/Pribilof Island Assoc.') ('17'='City of Galena (Yukon Koyukuk MH & Alcohol Program)') ('19'='Salvation Army - Clitheroe Center') ('20'='Volunteers of America of Alaska') ('21'='Assets') ('22'='Hoonah Indian Association') ('23'='Alaska Family Services') ('24'='Daybreak, Inc') ('25'='Narcotic Drug Treatment Center') ('27'='Providence Kodiak Island Counseling Center') ('30'='Kenai Peninsula Community Care Center') ('31'='Cook Inlet Council on Alcohol & Drug Abuse') ('32'='Juneau Alliance for Mental Health, Inc.') ('34'='Communities Organized for Health Options') ('35'='Lynn Canal ounseling Center')('36'='SouthEast Alaska Regional Health Consortium') ('37'='Polaris House') ('38'='Cordova Community Medical Clinic - dba - Sound Alternatives') ('39'='Alaska Islands Community Services') ('40'='Petersburg Mental Health Services') ('42'='Salvation Army - Booth Memorial') ('43'='North Slope Borough') ('44'='Ketchikan Indian Corp.') ('45'='Akeela Treatment Services, Inc.') ('46'='ARC of Anchorage') ('47'='Southcentral Foundation') ('48'='Copper River Native Association') ('50'='Community Connections') ('51'='Family Centered Services of Alaska') ('52'='Hope Community Resources, Inc.') ('53'='Norton Sound Health Corp.') ('54'='Kenaitze Indian Tribe') ('55'='Maniilaq Association') ('56'='Gateway Center for Human Services') ('65'='Yukon-Kuskokwim Health orporation') ('66'='Central Peninsula General Hospital') ('67'='Cook Inlet Tribal Council, Inc.') ('68'='Access Alaska') ('69'='Eastern Aleutian Tribes Inc') ('70'='Frontier Community Services') ('71'='South Peninsula Behavioral Health Services, Inc.') ('72'='Juneau Youth Services, Inc.') ('73'='Mat-Su Health Services, Inc.') ('74'='Bristol Bay Area Health Corporation') ('74'='Bristol Bay Area Health Corporation') ('75'='Denali Family Services (Alternatives CMHC)') ('76'='Fairbanks Community Behavioral Health Center') ('77'='Anchorage Community Mental Health Svs') ('78'='Rainforest Recovery Center') ('79'='Presbyterian Hospitality House') ('80'='Central Peninsula Counseling Services') ('81'='Providence Health System (Providence Crisis Respite Center)') ('82'='CHOICES') ('86'='Metlakatla Indian Community') ('12-14'='Tanana Chiefs Conference, Inc.') ('16'='Alaska Addiction Rehab Service - Nugen''s Ranch') ('59'='Alaska Children''s Services') INTO FacilityName . >Warning # 4624 in column 45. Text: ) >The preceding RECODE specifies a value to be recoded that is longer than >some variable(s) in the recode. The shorter values will be padded with >blanks for the comparison. Now, with the code unwrapped, it's clear: the string '12-14' is longer than the A2 variable that's being recoded. No FacilityCode value can match it. Perhaps you meant ('12' THRU '14'='Tanana Chiefs Conference, Inc.') -Good luck to you, Richard ============================= APPENDIX: Test data, and code ============================= NEW FILE. INPUT PROGRAM. . STRING FacilityCode (A2). . LOOP #Code = 2 TO 86. . COMPUTE FacilityCode = LTRIM(STRING(#Code,F2)). . END CASE. . END LOOP. END FILE. END INPUT PROGRAM. STRING FacilityName (A75). RECODE FacilityCode ('2'='Seaview Community Services') ('3'='Railbelt Mental Health & Addictions') ('5'='Providence Valdez Counseling Center') ('7'='Gastineau Human Services, Corp.') ('8'='Youth Advocates of Sitka') ('9'='Sitka Counseling and Prevention Services') ('11'='Tok Area Counseling Center') ('12'='Tanana Chiefs Conference, Inc.') ('13'='Interior Aids Association') ('14'='Fairbanks Native Association') ('15'='Aleutian/Pribilof Island Assoc.') ('17'='City of Galena (Yukon Koyukuk MH & Alcohol Program)') ('19'='Salvation Army - Clitheroe Center') ('20'='Volunteers of America of Alaska') ('21'='Assets') ('22'='Hoonah Indian Association') ('23'='Alaska Family Services') ('24'='Daybreak, Inc') ('25'='Narcotic Drug Treatment Center') ('27'='Providence Kodiak Island Counseling Center') ('30'='Kenai Peninsula Community Care Center') ('31'='Cook Inlet Council on Alcohol & Drug Abuse') ('32'='Juneau Alliance for Mental Health, Inc.') ('34'='Communities Organized for Health Options') ('35'='Lynn Canal Counseling Center') ('36'='SouthEast Alaska Regional Health Consortium') ('37'='Polaris House') ('38'='Cordova Community Medical Clinic - dba - Sound Alternatives') ('39'='Alaska Islands Community Services') ('40'='Petersburg Mental Health Services') ('42'='Salvation Army - Booth Memorial') ('43'='North Slope Borough') ('44'='Ketchikan Indian Corp.') ('45'='Akeela Treatment Services, Inc.') ('46'='ARC of Anchorage') ('47'='Southcentral Foundation') ('48'='Copper River Native Association') ('50'='Community Connections') ('51'='Family Centered Services of Alaska') ('52'='Hope Community Resources, Inc.') ('53'='Norton Sound Health Corp.') ('54'='Kenaitze Indian Tribe') ('55'='Maniilaq Association') ('56'='Gateway Center for Human Services') ('65'='Yukon-Kuskokwim Health orporation') ('66'='Central Peninsula General Hospital') ('67'='Cook Inlet Tribal Council, Inc.') ('68'='Access Alaska') ('69'='Eastern Aleutian Tribes Inc') ('70'='Frontier Community Services') ('71'='South Peninsula Behavioral Health Services, Inc.') ('72'='Juneau Youth Services, Inc.') ('73'='Mat-Su Health Services, Inc.') ('74'='Bristol Bay Area Health Corporation') ('74'='Bristol Bay Area Health Corporation') ('75'='Denali Family Services (Alternatives CMHC)') ('76'='Fairbanks ommunity Behavioral Health Center') ('77'='Anchorage Community Mental Health Svs') ('78'='Rainforest Recovery Center') ('79'='Presbyterian Hospitality House') ('80'='Central Peninsula Counseling Services') ('81'='Providence Health System (Providence Crisis Respite Center)') ('82'='CHOICES') ('86'='Metlakatla Indian Community') ('12-14'='Tanana Chiefs Conference, Inc.') ('16'='Alaska Addiction Rehab Service - Nugen''s Ranch') ('59'='Alaska Children''s Services') INTO FacilityName . LIST. ===================== 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 Zdaniuk, Bozena-2
hi,
I haven't tried it myself, but you could use the following Extension Command: SPSSINC COMPARE DATASETS: compare dictionary and/or data in two open SPSS datasets Cheers!! Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Before you criticize someone, walk a mile in their shoes, that way when you do criticize them, you're a mile away and you have their shoes! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --- On Fri, 10/30/09, Zdaniuk, Bozena <[hidden email]> wrote: > From: Zdaniuk, Bozena <[hidden email]> > Subject: Re: [SPSSX-L] Compare databases > To: [hidden email] > Date: Friday, October 30, 2009, 11:45 PM > it can be easily done if one has SPSS > data entry (builder) module. It allows for very easy > transformation of two regular spss data files into > "builder" files and then has a very nice and easy way to > compare the two files and to produce a user-friendly > report. > bozena > > ________________________________________ > From: SPSSX(r) Discussion [[hidden email]] > On Behalf Of Mike Pritchard [[hidden email]] > Sent: Friday, October 30, 2009 6:29 PM > To: [hidden email] > Subject: Compare databases > > Is there a (relatively) easy way to compare SPSS files? > > I am trying to correct a problem that has crept in where at > least one > variable has got messed up. I need to figure out how > far back in the > versions I need to go, and whether I can simply replace > that variable with > the original from the Excel file that was downloaded from > the survey tool. > If I can't just replace the variable in a later version of > the SPSS file > there is probably quite a bit more work to recode again, > and - more > important - checking / redoing coding from open-ends. > > I'm doing spot checks right now, but it would be great to > find a way to test > the integrity of multiple variables. > > Thanks > Mike > > ===================== > 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 |
Re: Compare databases - Can't run Python module
|
|
This sounds like a good tool, and gave me a reason to try the Python
modules from SPSSINC. But I can't get the COMPDS module to run. I tried with another
downloaded module and had the same results. (Restarted SPSS after each module
installed). Extension command COMPDS could not be
loaded. The module or a module that it requires may be missing, or there may be
syntax errors in it. I'm running SPSS V16 on Thanks Mike _________________________________________________________________________ The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential, proprietary, and/or
privileged material. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you received this
in error, please contact the sender and delete the material from all computers. -----Original Message----- hi, I haven't tried it myself, but you could use the following Extension
Command: SPSSINC COMPARE DATASETS: compare dictionary and/or data in two open SPSS datasets Cheers!! Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Before you criticize someone, walk a mile in their shoes, that way when you do criticize them, you're a mile away and you have their
shoes! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --- On Fri, 10/30/09, Zdaniuk, Bozena <[hidden email]> wrote: > From: Zdaniuk, Bozena <[hidden email]> > Subject: Re: [SPSSX-L] Compare databases > To: [hidden email] > Date: Friday, October 30, 2009, 11:45 PM > it can be easily done if one has SPSS > data entry (builder) module. It allows for very easy > transformation of two regular spss data files into > "builder" files and then has a very nice and easy way to > compare the two files and to produce a user-friendly > report. > bozena > > ________________________________________ > From: SPSSX(r) Discussion [[hidden email]] > On Behalf Of Mike Pritchard [[hidden email]] > Sent: Friday, October 30, 2009 6:29 PM > To: [hidden email] > Subject: Compare databases > > Is there a (relatively) easy way to compare SPSS files? > > I am trying to correct a problem that has crept in where at > least one > variable has got messed up. I need to figure out how > far back in the > versions I need to go, and whether I can simply replace > that variable with > the original from the Excel file that was downloaded from > the survey tool. > If I can't just replace the variable in a later version of > the SPSS file > there is probably quite a bit more work to recode again, > and - more > important - checking / redoing coding from open-ends. > > I'm doing spot checks right now, but it would be great to > find a way to test > the integrity of multiple variables. > > Thanks > Mike > > ===================== > To manage your subscription to SPSSX-L, send a message to > (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 > (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 |
Re: Compare databases - Can't run Python module
|
|
Hi,
Does Spss know where to find the downloaded .py files? The default place is: C:\Python24\Lib\site-packages (or maybe Python25...) Cheers!! Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Before you criticize someone, walk a mile in their shoes, that way when you do criticize them, you're a mile away and you have their shoes! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --- On Sun, 11/1/09, Mike Pritchard <[hidden email]> wrote: > From: Mike Pritchard <[hidden email]> > Subject: RE: Compare databases - Can't run Python module > To: "'Albert-Jan Roskam'" <[hidden email]>, [hidden email] > Date: Sunday, November 1, 2009, 2:16 AM > > > > > > > > > > > > > > > > > > > This sounds like a good tool, and gave > me a reason to try the Python > modules from SPSSINC. > > > > But I can't get the COMPDS module to > run. I tried with another > downloaded module and had the same results. > (Restarted SPSS after each module > installed). > > > > Extension > command COMPDS could not be > loaded. The module or a module that it requires may be > missing, or there may be > syntax errors in it. > > > > I'm running SPSS V16 on Vista > . > > > > Thanks > > Mike > > > > _________________________________________________________________________ > > > > > > > The information transmitted is intended > only for the person or entity > to which it is addressed and may contain confidential, > proprietary, and/or > privileged material. Any review, retransmission, > dissemination or other use of, > or taking of any action in reliance upon this information > by persons or > entities other than the intended recipient is prohibited. > If you received this > in error, please contact the sender and delete the material > from all computers. > > > > > > -----Original Message----- > > From: SPSSX(r) Discussion [mailto:[hidden email]] > On Behalf Of Albert-Jan > Roskam > > Sent: Saturday, October 31, 2009 7:10 AM > > To: [hidden email] > > Subject: Re: Compare databases > > > > hi, > > > > I haven't tried it myself, but you > could use the following Extension > Command: > > SPSSINC COMPARE DATASETS: compare > dictionary and/or data in > > two open SPSS datasets > > > > > Cheers!! > > Albert-Jan > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > Before you criticize someone, walk a > mile in their shoes, that way > > when you do criticize them, you're a > mile away and you have their > shoes! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > > > --- On Fri, 10/30/09, Zdaniuk, Bozena > <[hidden email]> wrote: > > > > > From: Zdaniuk, Bozena > <[hidden email]> > > > Subject: Re: [SPSSX-L] Compare > databases > > > To: > [hidden email] > > > Date: Friday, October 30, 2009, > 11:45 PM > > > it can be easily done if one has > SPSS > > > data entry (builder) module. It > allows for very easy > > > transformation of two regular > spss data files into > > > "builder" files and then > has a very nice and easy way to > > > compare the two files and to > produce a user-friendly > > > report. > > > bozena > > > > > > > ________________________________________ > > > From: SPSSX(r) Discussion > [[hidden email]] > > > On Behalf Of Mike Pritchard > [[hidden email]] > > > Sent: Friday, October 30, 2009 6:29 > PM > > > To: > [hidden email] > > > Subject: Compare > databases > > > > > > Is there a (relatively) easy way to > compare SPSS files? > > > > > > I am trying to correct a problem > that has crept in where at > > > least one > > > variable has got messed up. I > need to figure out how > > > far back in the > > > versions I need to go, and whether > I can simply replace > > > that variable > with > > > the original from the Excel file > that was downloaded from > > > the survey tool. > > > If I can't just replace the > variable in a later version of > > > the SPSS file > > > there is probably quite a bit more > work to recode again, > > > and - more > > > important - checking / redoing > coding from open-ends. > > > > > > I'm doing spot checks right > now, but it would be great to > > > find a way to > test > > > the integrity of multiple > variables. > > > > > > Thanks > > > Mike > > > > > > > ===================== > > > 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 |
Re: Compare databases
|
In reply to this post by Albert-Jan Roskam
Dear all,
I was curious about this Python module, but I cannot download it. I get the error: 500 Error Executing Database Query.Error Executing Database Query.Isn't it available anymore? Is there a problem with the site? TIA! Ruben van den Berg > Date: Sat, 31 Oct 2009 07:09:33 -0700 > From: [hidden email] > Subject: Re: Compare databases > To: [hidden email] > > hi, > > I haven't tried it myself, but you could use the following Extension Command: > SPSSINC COMPARE DATASETS: compare dictionary and/or data in > two open SPSS datasets > > Cheers!! > Albert-Jan > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Before you criticize someone, walk a mile in their shoes, that way > when you do criticize them, you're a mile away and you have their shoes! > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > --- On Fri, 10/30/09, Zdaniuk, Bozena <[hidden email]> wrote: > > > From: Zdaniuk, Bozena <[hidden email]> > > Subject: Re: [SPSSX-L] Compare databases > > To: [hidden email] > > Date: Friday, October 30, 2009, 11:45 PM > > it can be easily done if one has SPSS > > data entry (builder) module. It allows for very easy > > transformation of two regular spss data files into > > "builder" files and then has a very nice and easy way to > > compare the two files and to produce a user-friendly > > report. > > bozena > > > > ________________________________________ > > From: SPSSX(r) Discussion [[hidden email]] > > On Behalf Of Mike Pritchard [[hidden email]] > > Sent: Friday, October 30, 2009 6:29 PM > > To: [hidden email] > > Subject: Compare databases > > > > Is there a (relatively) easy way to compare SPSS files? > > > > I am trying to correct a problem that has crept in where at > > least one > > variable has got messed up. I need to figure out how > > far back in the > > versions I need to go, and whether I can simply replace > > that variable with > > the original from the Excel file that was downloaded from > > the survey tool. > > If I can't just replace the variable in a later version of > > the SPSS file > > there is probably quite a bit more work to recode again, > > and - more > > important - checking / redoing coding from open-ends. > > > > I'm doing spot checks right now, but it would be great to > > find a way to test > > the integrity of multiple variables. > > > > Thanks > > Mike > > > > ===================== > > 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 Express yourself instantly with MSN Messenger! MSN Messenger |
|
|
There appears to be a temporary problem with the Developer Central website. I have filed a trouble report with our IT folks. We'll get it back asap. Sorry for the problem. Jon Peck SPSS, an IBM Company [hidden email] 312-651-3435
Dear all, I was curious about this Python module, but I cannot download it. I get the error: 500 Error Executing Database Query. Error Executing Database Query. Isn't it available anymore? Is there a problem with the site? TIA! Ruben van den Berg > Date: Sat, 31 Oct 2009 07:09:33 -0700 > From: [hidden email] > Subject: Re: Compare databases > To: [hidden email] > > hi, > > I haven't tried it myself, but you could use the following Extension Command: > SPSSINC COMPARE DATASETS: compare dictionary and/or data in > two open SPSS datasets > > Cheers!! > Albert-Jan > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Before you criticize someone, walk a mile in their shoes, that way > when you do criticize them, you're a mile away and you have their shoes! > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > --- On Fri, 10/30/09, Zdaniuk, Bozena <[hidden email]> wrote: > > > From: Zdaniuk, Bozena <[hidden email]> > > Subject: Re: [SPSSX-L] Compare databases > > To: [hidden email] > > Date: Friday, October 30, 2009, 11:45 PM > > it can be easily done if one has SPSS > > data entry (builder) module. It allows for very easy > > transformation of two regular spss data files into > > "builder" files and then has a very nice and easy way to > > compare the two files and to produce a user-friendly > > report. > > bozena > > > > ________________________________________ > > From: SPSSX(r) Discussion [[hidden email]] > > On Behalf Of Mike Pritchard [[hidden email]] > > Sent: Friday, October 30, 2009 6:29 PM > > To: [hidden email] > > Subject: Compare databases > > > > Is there a (relatively) easy way to compare SPSS files? > > > > I am trying to correct a problem that has crept in where at > > least one > > variable has got messed up. I need to figure out how > > far back in the > > versions I need to go, and whether I can simply replace > > that variable with > > the original from the Excel file that was downloaded from > > the survey tool. > > If I can't just replace the variable in a later version of > > the SPSS file > > there is probably quite a bit more work to recode again, > > and - more > > important - checking / redoing coding from open-ends. > > > > I'm doing spot checks right now, but it would be great to > > find a way to test > > the integrity of multiple variables. > > > > Thanks > > Mike > > > > ===================== > > 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 Express yourself instantly with MSN Messenger! MSN Messenger |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |