SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
Back to discussions
Expand all | Collapse all

FUZZY matching not work

  • 1.  FUZZY matching not work

    Posted Thu April 07, 2022 09:19 AM
    I have been using the FUZZY (Case control matching) command for several years now and it has worked fine until now

    I have a dataset of about 60,000 unique entries, 2000 cases and 58,000 possible controls. I want to select 4 matched controls per case 

    FUZZY BY=Sex Age_EndOfFollowup Part_NT2BLQ1
    SUPPLIERID=PID_106658
    NEWDEMANDERIDVARS=Ctrl1 Ctrl2 Ctrl3 Ctrl4
    GROUP=IncVTE
    FUZZ=0 5 0
    EXACTPRIORITY=TRUE
    MATCHGROUPVAR=Na
    /OPTIONS SAMPLEWITHREPLACEMENT=FALSE MINIMIZEMEMORY=TRUE SHUFFLE=TRUE.

    Nothing happens when I hit this command. It seams like SPSS (version 28.0.1.0) do not recognize the command and no Error message are displayed in either the syntax window or the output window.

    I have recently updated the version of SPSS and my first thought was that I might have lost the Python FUZZY Extension but I have FUZZY version 2.0.1 installed.

    Do anyone have any suggestions to what might be wrong?

    ------------------------------
    Elin Sørgjerd
    ------------------------------

    #SPSSStatistics


  • 2.  RE: FUZZY matching not work

    Posted Thu April 07, 2022 09:23 AM
    If you have not updated your FUZZY installation, go to Extensions > Extension Hub and install it.  You might have to check the Installed button and download it and do Extensions > Install Local extension bundle.  Then restart Statistics.



    --



    Original Message


  • 3.  RE: FUZZY matching not work

    Posted Thu April 07, 2022 10:10 AM

    Dear Jon,

    Thanks for the suggestion. I had the latest update. I tried to uninstall the extension and then reinstall it again, but this did not help.

     

    If someone has any other suggestion I would very much appreciate it. I have no clue how I can do this case control matching without this syntax.

     

    Thanks,

    Elin Sørgjerd

     




    Original Message


  • 4.  RE: FUZZY matching not work

    Posted Thu April 07, 2022 11:02 AM
    I use FUZZY with 28.0.x with no problem, so I know it works.  If you can send your syntax and a sample of the input datasets to my email address (below), I will see if I can figure this out.

    Also, please send me your FUZZY.spe file so that I can make sure that it matches mine.



    --



    Original Message


  • 5.  RE: FUZZY matching not work

    Posted Thu April 07, 2022 11:09 AM
    p.s. If the command was not recognized, you would have gotten an error message to that effect.

    --



    Original Message


  • 6.  RE: FUZZY matching not work

    Posted Fri April 08, 2022 03:18 AM
    Hi Jon,
    I asked a colleague to do the same FUZZY command on a constructed dataset on his computer and he had the same problem. However, my colleague got the error message 
    Warning #6894 Command name: BEGIN PROGRAM
    The external program exited unexpectedly and lost it content, a new external program will start up to execute the rest of the job.​

    After googling this error message I think there can be something wrong with the python essentials installations. I will have a word with our IT help desk.

    ------------------------------
    Elin Sørgjerd
    ------------------------------

    Original Message


  • 7.  RE: FUZZY matching not work

    Posted Fri April 08, 2022 08:28 AM
    run a simple program to test the Python connection.
    begin program python3.
    import spss
    print(spss)
    end program.


    --



    Original Message


  • 8.  RE: FUZZY matching not work

    Posted Sun April 10, 2022 05:13 AM

    Hi,

    What is supposed to happen when I run this command?




    Original Message


  • 9.  RE: FUZZY matching not work

    Posted Sun April 10, 2022 07:48 AM
    You should get a line of output showing the location of the spss module.  If you get no output or an error message, something is wrong with your Statistics installation, which includes Python.
    --



    Original Message


  • 10.  RE: FUZZY matching not work

    Posted Sun April 10, 2022 08:06 AM

    OK, I do not get any report or error in the output file so my suspicion was then correct. There are something wrong with the installation, probably when I updated the version. I have reported the problem to our the IT-help desk at our Research department.

    Thank you very much for the help and input.

     




    Original Message