Problem
When I try opening my Excel file into SPSS for Windows I get a ‘communications error in dac proxy’. Why won’t the file import?
Resolving The Problem
There may be a format setting in the Excel file that SPSS cannot translate. Try saving the file from Excel to Excel 4 format, and then opening the resulting file in SPSS
Related Information
[{«Product»:{«code»:»SSLVMB»,»label»:»IBM SPSS Statistics»},»Business Unit»:{«code»:»BU059″,»label»:»IBM Software w\/o TPS»},»Component»:»Not Applicable»,»Platform»:[{«code»:»PF025″,»label»:»Platform Independent»}],»Version»:»Not Applicable»,»Edition»:»»,»Line of Business»:{«code»:»LOB10″,»label»:»Data and AI»}}]
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.
Already on GitHub?
Sign in
to your account
Closed
deschen1 opened this issue
Jul 26, 2021
· 28 comments
Comments
I saved some R data as an xlsx file with openxlsx in R. However, when trying to open this file in SPSS I get an error:
When exporting the data with e.g. the writexl package, I don’t get such an error. This happens regularly, i.e. many files exported with openxlsx can’t be opened in SPSS anymore so my guess is that openxlsx somehow deviates from the standard meta structure of an xlsx file?
I’m also attaching the problematic Excel file (DELETED, see updated files here: #231 (comment))
BTW: opening the problematic file in Excel directly and save it under a new name fixes the issue, i.e. the file can be opened in SPSS then.
Hi @deschen1 , when you mentioned that they can’t be opened anymore I assume that previously they used to work? Could you please attach your fixed Excel too, it will be useful if someone wants to see where the issue is. Unless it’s something pretty obvious, I’m not sure how we should debug the SPSS xlsx importer (if you’re not depending on the xlsx files, you can use other packages to directly create spss binary files, I’ve written such a package myself).
Since there are multiple ways to create files with openxlsx, we’d need an minimal reproduce able example. Some R code that creates the file above.
If you have some time, it would be beneficial, if you could help narrowing down which commit has caused the issue. A good command line tool for this is git bisect, otherwise downloading a few commits, building the package, running the minimal example and opening the file in SPSS should make the deal. (It’s somewhat tedious, but such is software development and if you’re not doing it, someone else with access to SPSS has to, or fix it by mistake sometime in the future.)
@JanMarvin: I tested with some new code and the error is completely reproducible with whatever content I have in may data frame. So here’s a small reproducible example:
df <- data.frame(uuid = "asjdhbsadkbask",
var1_en = "This is just a test")
export_df <- openxlsx::createWorkbook()
openxlsx::addWorksheet(export_df, sheetName = "Sheet 1")
openxlsx::writeData(export_df, sheet = "Sheet 1", x = df)
openxlsx::saveWorkbook(export_df, file.choose())
As for your remaining message, I have to admit that I don’t understand much about it. I’m rather an enduser and not a software developer, so I post things here, but otherwise don’t know anything about github or commits.
However, at least I can tell that I’m using openxlsx 4.2.4, downloaded through the official CRAN, I’m using R 4.1.0.
The file doesn’t open in any of my SPSS versions (i.e. neither SPSS 21 nor 24).
Please find re-attached the non-working Excel file for the new reproducible example:
test openxlsx.xlsx
And here the file after opening in Excel, saving under new name, which now can be opened in Excel:
test openxlsx 2.xlsx
Hope this helps.
Okay, thanks that should be helpful.
- Did such code run with previous versions of openxlsx? E.g. is this a regression?
- If you save the dataframe with `write.xlsx(df, «some name.xlsx»), can this file be opened with SPSS? It uses a different internal logic, therefore I’m curious.
No, I remember the problem being present for quite some time. I can’t track down the specific version of openxlsx or remember if there was a version where the bug didn’t exist, though.
And yes, with saving the file through writexl, the bug doesn’t exist. So it has to do sth. with the internal logic of saving the files in openxlsx.
openxlsx provides two ways to save files. openxlsx::write.xlsx(df, "some name.xlsx") is different than creating and writing a workbook. Therefore I’d like to know if this works for you.
I assume that the XML code is broken somewhere and that the SPSS importer is stricter than the one Excel uses, still it’s searching a needle in a haystack 😄
Nope, the problem still exists with using openxlsx::write.xlsx(...). I’m getting the same error as before.
Okay, thanks. Your example file opens fine with android Excel (which I found to be the most picky one), therefore I’m not sure how to test this. I might take a brief look into the XMLs to see if I can spot anything, but aside from that, you might want to use JanMarvin/readspss or other packages to create the SPSS binary files or simply CSV to move data from R to SPSS.
All files open perfectly fine in Excel, that is true. They aren’t correctly opened in other tools, like SPSS, though. So my guess is that something in the xml when exporting from openxlsx is not entirely correct. So when opening in SPSS, it fails, because maybe SPSS has a strict parsing of Excel files — I don’t know. But maybe Excel itself is a bit less restricted and tries to «repair» incorrect files, so once I processed in Excel and save again, the bug is fixed.
Maybe one option would be to compare the file meta information of an openxlsx eported Excel file vs. one exported with e.g. writexl::write_xlsx?
If you want to help, that’s something you can do too. Just unzip the xlsx files into different folders and compare the content of the Excel export and the one from openxlsx one by one. That’s what I would do. They somehow differ. Maybe a tag is missing or written incorrectly. Sadly that’s not just a single file and not only a few tags to look at
I don’t think I can be of much help here. I tried to comapre the xmls in each file, but really not sure where to look at. so I took the original Excel (the one that can’t be opened in SPSS) and compared it to the one where I opened the original in Excel and just saved it under a new name (in which case it can be opened in SPSS).
Here are a few differences:
[Content_Types].xml
Original:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">
<Default Extension="bin" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.printerSettings"/>
<Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/>
<Default Extension="xml" ContentType="application/xml"/>
<Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/>
<Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/>
<Override PartName="/xl/sharedStrings.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"/>
<Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"/>
<Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/>
<Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/>
<Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/>
<Override PartName="/xl/drawings/drawing1.xml" ContentType="application/vnd.openxmlformats-officedocument.drawing+xml"/>
</Types>
Fixed one:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">
<Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/>
<Default Extension="xml" ContentType="application/xml"/>
<Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/>
<Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/>
<Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/>
<Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"/>
<Override PartName="/xl/sharedStrings.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"/>
<Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/>
<Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/>
</Types>
I notice that the original one has an additional default extension «bin» and also refers to some more meta files, e.g. styles and drawing 1.
sheet 1.xml
Original
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="x14ac xr xr2 xr3"
xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision"
xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3">
<dimension ref="A1"/>
<sheetViews>
<sheetView workbookViewId="0" zoomScale="100" showGridLines="1" tabSelected="true"/>
</sheetViews>
<sheetFormatPr defaultRowHeight="15.0" baseColWidth="10"/>
<sheetData>
<row r="1">
<c r="A1" t="s">
<v>0</v>
</c>
<c r="B1" t="s">
<v>1</v>
</c>
</row>
<row r="2">
<c r="A2" t="s">
<v>2</v>
</c>
<c r="B2" t="s">
<v>3</v>
</c>
</row>
</sheetData>
<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>
<pageSetup paperSize="9" orientation="portrait" horizontalDpi="300" verticalDpi="300" r:id="rId2"/>
</worksheet>
Fixed one
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="x14ac xr xr2 xr3"
xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision"
xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3"
xr:uid="{00000000-0001-0000-0000-000000000000}">
<dimension ref="A1:B2"/>
<sheetViews>
<sheetView tabSelected="1" workbookViewId="0"/></sheetViews>
<sheetFormatPr baseColWidth="10" defaultRowHeight="15" x14ac:dyDescent="0.25"/>
<sheetData>
<row r="1" spans="1:2" x14ac:dyDescent="0.25">
<c r="A1" t="s">
<v>0</v>
</c>
<c r="B1" t="s">
<v>1</v>
</c>
</row>
<row r="2" spans="1:2" x14ac:dyDescent="0.25">
<c r="A2" t="s">
<v>2</v>
</c><c r="B2" t="s">
<v>3</v>
</c>
</row>
</sheetData>
<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>
<pageSetup paperSize="9" orientation="portrait" horizontalDpi="300" verticalDpi="300"/>
</worksheet>
Not sure what I’m seeing here.
sharedStrings.xml
Original
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="4" uniqueCount="4">
<si>
<t xml:space="preserve">uuid</t>
</si>
<si>
<t xml:space="preserve">var1_en</t>
</si>
<si>
<t xml:space="preserve">asjdhbsadkbask</t>
</si>
<si>
<t xml:space="preserve">This is just a test</t>
</si>
</sst>
Fixed one
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="4" uniqueCount="4">
<si>
<t>uuid</t>
</si>
<si>
<t>var1_en</t>
</si>
<si>
<t>asjdhbsadkbask</t>
</si>
<si>
<t>This is just a test</t>
</si>
</sst>
This looks quite similar except that the original has these xml:space = «preserve» things.
Btw, I also compared the original Excel file to the one created with writexl. The write xl version doesn’t have the sharedStrings.xml part where the actual content seems to be stored. Instead, it directly puts it into the sheet1.xml:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
<dimension ref="A1:B2"/>
<sheetViews>
<sheetView tabSelected="1" workbookViewId="0"/>
</sheetViews>
<sheetFormatPr defaultRowHeight="15"/>
<sheetData>
<row r="1" s="1" customFormat="1">
<c r="A1" s="1" t="inlineStr">
<is>
<t>uuid</t>
</is>
</c>
<c r="B1" s="1" t="inlineStr">
<is>
<t>var1_en</t>
</is>
</c>
</row>
<row r="2">
<c r="A2" t="inlineStr">
<is>
<t>asjdhbsadkbask</t>
</is>
</c>
<c r="B2" t="inlineStr">
<is>
<t>This is just a test</t>
</is>
</c>
</row>
</sheetData>
<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>
</worksheet>
It might be that this is the problem for SPSS: <dimension ref="A1"/>. If they check the dimensions and we do not provide a valid range.
You could replace the sheets dimensions with the string from the fixed xlsx (that’s the one from Excel?)
wb$worksheets[[1]]$dimension <- "<dimension ref=\"A1:B2\"/>"
Afterwards save the workbook and try to open it in SPSS.
That would have been great, but this unfortunately doesn’t solve the problem. I added the dimension to the workbook and saved it, but the SPSS error persists. I also checked in the new file, and the sheet1.xml now has the <dimension ref="A1:B2"/>.
I know it’s a bit tedious to find the difference, one other thing I saw in the sheet1.xml is that the fixed version as well as the one from writexl use <sheetView tabSelected="1"..., whereas openxlsx uses <sheetView tabSelected="true".... I guess, Excel also has a routine to convert true/flase to 1/0, so maybe that’s not an issue, just wanted to point it out in case it’s a problem after all.
I tested this by manually changing it in the xml, but still can’t be opened in SPSS.
It’s possible that it’s in one of the other XML files. Or just a special case in the SPSS xlsx importer. I’ll have a look … soon™
Thanks. Could this maybe be the same issue as described here? #161
Because with this inlinestr stuff it seems to work for writexl and the file can be opened by SPSS. On the other hand…the „fixed“ file after opening in Excel doesn‘t have it. So not sure if that‘s the solution, but just wanted to mention it here.
I have the same issue with PowerBI. PowerBI says it is a corrupted file. However, when I open it with Excel and save it again it works.
Hi @sgratzl, this has already been reported in another 3rd party issue. If you have some time to help looking into it, that’d be great. As neither an SPSS nor power bi user things like this are harder to debug/fix. Since it’s not obvious which feature of openxml these tools have implemented and which of ours are problematic for them. Maybe run some tests, are only openxlsx created files problematic or are modified problematic too? Is there anything specific how do the files differ? Can the tool open Libreoffice xlsx files etc. Everything that might give a hint is welcome, otherwise chances are, that the issue might be solved only by a fluke.
I’ve found a possible solution that I hae tested with an older SPSS release. Maybe you could test this with SPSS and PowerBI @deschen1 and @sgratzl . This requires two fixes which should be included into the package, but it’s Sunday an I’ve already wasted enough hours in front of my PC.
library(openxlsx) df <- mtcars export_df <- createWorkbook() addWorksheet(export_df, sheetName = "Sheet 1") writeData(export_df, sheet = "Sheet 1", x = df) # Fix1: remove drawings from Content_Types # SPSS checks Content_Types and bails since drawings xml files are not found. # This will require a check if drawings should be included (most likely check # if we have loaded a drawing or have created one). sel <- which(!grepl("drawing",export_df$Content_Types)) export_df$Content_Types <- export_df$Content_Types[sel] # Fix2: adjust dimensions # SPSS checks dimensions and only accepts cell ranges specified here. This will # require us to adjust the creation of dimensions dimensions <- function(x) sprintf('<dimensions ref=\"%s\"/>', paste0(int2col(c(1,ncol(x))), c(1, nrow(x)+1), collapse = ":")) export_df$worksheets[[1]]$dimension <- dimensions(df) # this file can be loaded in SPSS saveWorkbook(export_df, file.choose(), overwrite = TRUE)
OK, so we checked and the fix above seems to work. To be more precise, applying BOTH fixes together works. Applying just one of them doesn’t work, i.e. fix1 just leads to an empty file. With fix2 the initial problem persists.
Ok, I need to retreat my last comment. It works until a certain data size, e.g. I created a random data set with 5000 rows and 100 columns and it works with the fix. It also works with 5000 rows and 200 columns, or 10000 rows and 100 columns. But it doesn’t work e.g. with 5000 rows and 500 columns (where it would just open an empty data set in SPSS), also doesn’t work with e.g. 10000 rows and 200 columns. So there seems to be a probelm with the fix once we approach sth. between 1m and 2m cells.
Example code:
library(openxlsx)
library(tidyverse)
set.seed(1)
df <- matrix(nrow = 10000, ncol = 100) %>%
as_tibble() %>%
mutate(across(everything(), ~sample(100, size = length(.x), replace = TRUE)))
export_df <- createWorkbook()
addWorksheet(export_df, sheetName = "Sheet 1")
writeData(export_df, sheet = "Sheet 1", x = df)
# Fix 1
sel <- which(!grepl("drawing",export_df$Content_Types))
export_df$Content_Types <- export_df$Content_Types[sel]
# Fix 2
dimensions <- function(x) sprintf('<dimensions ref=\"%s\"/>',
paste0(int2col(c(1,ncol(x))),
c(1, nrow(x)+1),
collapse = ":"))
export_df$worksheets[[1]]$dimension <- dimensions(df)
# Saving it here
saveWorkbook(export_df, "OpenXLSX Test.xlsx", overwrite = TRUE)
OK, but looking at the respective SPSS Error message, it might be a limit in the SPSS importing feature itself if I see that right?
>Error. Command name: GET DATA
>(2055) A memory error occurred while reading the Excel data. To correct the
>problem, try increasing the maximum Java heap size in jvmcfg.ini (located in
>the SPSS Statistics application folder). For example, change -Xmx225M to
>-Xmx350M.
>Execution of this command stops.
EXECUTE.
>Error # 105. Command name: EXECUTE
>This command is not valid before a working file has been defined.
>Execution of this command stops.
DATASET NAME DataSet1 WINDOW=FRONT.
Did it work with Excels of this size? Anything specific you observed? Could you please provide the dimensions? It might be something with the SPSS reader. Aside from the dimensions there is nothing specific going on.
Edit: Did you try what SPSS tells you, modifying the java file? Also I don’t remember, but aren’t there any limitations of maximum number of cols and rows?
The size itself shouldn’t be an issue, i.e. I can open teh Excle file perfectly fine — 10k rows is nothing Excel can’t handle. I also have different SPSS datat sets with e.g. 1.5k columns and 100k rows, so taht#s also not an issue. The error message really sounds like SPSS is limiting the size of Excel imports.
OK, so after some further digging, this might be related to this issue, i.e. with SPSS21 the problem from above occurs, but with SPSS 24 I get this exact error message: https://www.ibm.com/support/pages/apar/PI61788
Now, saving the Excel from R by changing the integer type to numeric type lets me read in everything just fine. So I guess the fix is doing the right things, but SPSS is just stupid in reading in files?
This one works (see changes in the first mutate where I add the conversion to numeric):
library(openxlsx)
library(tidyverse)
set.seed(1)
df <- matrix(nrow = 10000, ncol = 200) %>%
as_tibble() %>%
mutate(across(everything(), ~sample(100, size = length(.x), replace = TRUE)),
across(everything(), ~as.numeric(.x)))
export_df <- createWorkbook()
addWorksheet(export_df, sheetName = "Sheet 1")
writeData(export_df, sheet = "Sheet 1", x = df)
# Fix 1
sel <- which(!grepl("drawing",export_df$Content_Types))
export_df$Content_Types <- export_df$Content_Types[sel]
# Fix 2
dimensions <- function(x) sprintf('<dimensions ref=\"%s\"/>',
paste0(int2col(c(1,ncol(x))),
c(1, nrow(x)+1),
collapse = ":"))
export_df$worksheets[[1]]$dimension <- dimensions(df)
# Saving it here
saveWorkbook(export_df, "OpenXLSX Test.xlsx", overwrite = TRUE)
Weird. Unless R or our C++ code does something strange with large integer values (maybe a buffer overflow; storing large integers in smaller int16 etc), there is no difference between integers and numerics. Both are written as strings to the xlsx file (in contrast to e.g. the the binary format for SPSS).
Otherwise I’ll see if I can integrate the fix to the package, it’ll require some thinking about corner cases and additional testing as it’s unfortunately not entirely straight forward and most likely it won’t make it for the next CRAN release.
Just FYI, I installed an SPSS patch (see link above) and now the Excel files are correctly opened in SPSS 24 once the fix1 an fix2 are applied. So I’d say the fixes are the right ones. And the fact that I could open the respective files in SPSS only until a certain size limit, was purely related to the SPSS bug (which is fixed once you install the SPSS patch). So I guess no need to worry about that anymore.
Looking forward to see the fixes in the package at some point and thanks for fixing in the first place!
This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.
I’ve removed the stale label, but there is no active development regarding the issue. Should work with openxlsx2, if you want to give it a try.
Edit: on a second thought it might require fix1 with openxlsx2
This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.
This issue was closed because it has been stalled for 7 days with no activity.
Ответы с готовыми решениями:
Как обработать результаты опроса в SPSS? Или подскажите, пожалуйста, хороший самоучитель по программе
Добрый вечер.
В общем, опросила людей по анкете, теперь надо обработать данные в SPSS. Подскажите,…
Можно вопрос?
сколько можно иметь с сайта с посещаемостью чуть более 300?
приму любую критику и правду !
Mavr, можно тебе вопрос?
А как в Access’е какому-нибудь контролу назначить свой курсор???
С TreeView разобрался: большое…
форум, где можно задать вопрос по ТОЭ
Подскажите пожалуйста нормальный форум, где можно задать вопрос по ТОЭ. Есть полудетский вопрос на…
0
Get the Reddit app
Scan this QR code to download the app now
Or check it out in the app stores
Go to spss
r/spss
r/spss
SPSS Statistics is a software package used for statistical analysis.
Members
Online
•
by
pandachaz
SPSS importing data help! I’m trying to open an excel spreadsheet in SPSS, but when I go to open data and the documents folder where the file is saved nothing is there? I’ve typed in the file name and still nothing? Can anyone tell me where I’m going wrong? (Sorry for the terrible picture!!)
Я делаю агрегат по spss, и он показывает ошибку: Ошибка при открытии файла SPSS Statistic System: отказано в разрешении «имя файла» (DATA1201) Я открыл связанный файл с именем и смог открыть его, я также уверен, что я у вас есть разрешение на запись или редактирование данных в этой папке, знаете ли вы, почему она показывает, что у меня нет разрешения? Спасибо!
2014-09-08 15:04
1
ответ
Попробуйте изменить имя файла в команде AGGREGATE, чтобы увидеть, все ли выдает предупреждения. Я подозреваю, что SPSS все еще думает, что определенный файл данных открыт, и в этом случае вы не можете перезаписать уже открытый файл.
2014-09-09 11:27
Другие вопросы по тегам
spss