SPSS or R file to Excel?
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:
I'm going crazy over here. Any help would be appreciated. Thanks!

File
Memory buffered fileI'm going crazy over here. Any help would be appreciated. Thanks!


Sort by:
1 - 9 of
91

Cash
New Altair Community Member
OPWhen 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?
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?
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?
Sort by:
1 - 1 of
11