RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

SPSS or R file to Excel?

CashCash Member Posts: 11 Contributor II
edited February 12 in Help
I downloaded a file of data (locations, phone numbers, etc.) from a website in both R and in SPSS.  I need the data in Excel.  I started off with Read SPSS and indicated the downloaded SPSS file in the "filename" parameter.  Then connected the output to Write Excel.  The result just says:

       File

Memory buffered file
I'm going crazy over here.  Any help would be appreciated.  Thanks!
Tagged:
Jasmine_

Best Answer

Answers

  • CashCash Member Posts: 11 Contributor II
    When I run the Read SPSS Operator with the data set I downloaded, the results are all numerical...including the columns that should be text, like type of hospital, etc.  Is there a parameter I need to change for this?
    Jasmine_
  • varunm1varunm1 Moderator, Member Posts: 1,203   Unicorn
    edited February 12
    Hello @Cash

    Can you connect the "Thr" port of write excel to "Res" port of process and run it.

    You can also mention the location on your computer where you want to store this excel

    Please inform us if you still have issues.
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

    Jasmine_
  • CashCash Member Posts: 11 Contributor II
    Hello @varunm1

    I had the address of where to store the output entered as a destination on my desktop.  By "out port of process" do you mean the res on the far right side?  The only out node I see is coming from the Read SPSS operator.
    Jasmine_
  • varunm1varunm1 Moderator, Member Posts: 1,203   Unicorn
    Oh yeah sorry for that. Yep its the "Res"
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

    Jasmine_
  • CashCash Member Posts: 11 Contributor II
    Hi @varunm1,

    I connected the thr node to res and ran the process, but I'm still just getting numerical values instead of text.  Do you think the file is fouled?  Here's what I have:


    The link to the data is here:  https://www.datafiles.samhsa.gov/study-dataset/national-survey-substance-abuse-treatment-services-2018-n-ssats-2018-ds0001-nid18765

    It's the SPSS file under Data Downloads.  If you run this, are you seeing the same numerical representation as I am above?
    Jasmine_
  • varunm1varunm1 Moderator, Member Posts: 1,203   Unicorn
    Hello @Cash

    My answer is just to store excel. I saw your other comment now, will check it.
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

    CashJasmine_
  • CashCash Member Posts: 11 Contributor II
    OMG, how embarrassing.  Well if "delimited" downloads as a CSV, then I'm good for now.  lol . I was trying to get this data in csv or xlsx form, so it looks like this solves my problem.  Thanks so much for the help!  
    varunm1Jasmine_
  • varunm1varunm1 Moderator, Member Posts: 1,203   Unicorn
    Haha ya, sometimes we skip small things and it happens to all of us. I don't have spss installed to take a look at the raw file. But it is a good question to check if there is any discrepancy in importing.
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

    CashJasmine_
Sign In or Register to comment.