I'm wondering if there is an easy way to load data from analysis services (SSAS) into SPSS. SPSS offers a product to put SPSS functionality on the analysis server, but to me this is backwards. I don't want to learn about SPSS or have the SPSS users in the office learn something else. I just want to give the analysis services data to...
I'm looking for a solution for producing SPSS format data files for loading into SPSS. The few offerings I can find are all commercial. Has anyone experience with generating SPSS-format data files using open-source, freeware or home-grown solutions? I'm not even sure that the file format is "open". Any hints appreciated (any language i...
I am writing out statistical results in SPSS with code like OMS / SELECT Tables Headings / DESTINATION FORMAT = OXML OUTFILE='C:\Temp\outfile.xml'. The syntax file is saved as UTF-8 (with bookmark). It has some words with umlauts (german funny characters like ä, ö, ü). When I open the syntax file, it displays these umlauts as Ã...
I have some data in SPSS that I would like to format in a particular way, but I can't seem to find a way to do it in the documentation. I have data that consists of 10 question responses, Q1 to Q10, with a Q1 to Q10 for each value of a variable SPEAKER within a variable SESSION. For example, each session can have up to five speakers, f...
I am doing regression and I am using SPSS/PASW. But it doesn't seem to support Ordinary Least Squares, it only has Partial least Squares and 2-stages Least Squares. Any suggestions about what to do? ...
I want to do a linear regression but I want to use Ordinary Least Squares which I think it is a type of Linear regression.. The software I use is SPSS and it only has linear regression, partial least squares and 2-stages least squares. I have no idea which one is Ordinary Least Squares (OLS) ...
I am trying to do a regression problem but I have 3 independent variables and not 1 so it is hard to detect outliers from a scatter graph. Any suggestions? ...
I apologize up front for the broadness of this question, but I'm wondering if anyone has any suggestions/pointers. A friend's company uses SPSS for statistical data, surveys, etc. They'd like to be able to slice and dice the the info via a web interface. I have no knowledge of SPSS, so there may be a simple web front end, but being a PH...
I have given some data in an excel sheet to a 3rd party for SPSS data processing. After completion of the processing, what are the files that I should get back from them. I have received one file with a ".sav" extension. I presume this file contains the imported data (from my excel file). I have received documents (.rtf - rich text f...
As usual, I got some SPSS file that I've imported into R with spss.get function from Hmisc package. I'm bothered with labelled class that Hmisc::spss.get adds to all variables in data.frame, hence want to remove it. labelled class gives me headaches when I try to run ggplot or even when I want to do some menial analysis! One solution wo...
I have noticed that the sum of squares in my models can change fairly radically with even the slightest adjustment to my models???? Is this normal???? I'm using SPSS 16, and both models presented below used the same data and variables with only one small change - categorizing one of the variables as either a 2 level or 3 level variable. ...
How can I put this into spss??? http://www.cbi.dongnocchi.it/glossary/Cosinor.html I am trying to calculate the MESOR for a cyclic pattern of circadian rhythm. ...
Hey i am trying to calculate a cosinor analysis in statistica but am at a loss as to how to do so. I need to calculate the MESOR, AMPLITUDE, and ACROPHASE of ciracadian rhythm data. http://www.wepapers.com/Papers/73565/Cosinor_analysis_of_accident_risk_using__SPSS%27s_regression_procedures.ppt there is a link that shows how to do it, t...
I have a Rails application to do web surveys. It stores answers to multiple-choices (fixnum) questions into sqlite3. Is there any ruby gem that I can use to export my data into spss format ? I'd like to be able to export for SPSS version prior of 16/16 or up. My SPSS export needs to include two files: a syntax file (survey_name_SPSS_s...
Is there a "native" SPSS way to loop through some variable names? All I want to do is take a list of variables (that I define) and run the same procedure for them: pseudo-code - not really a good example, but gets the point across... for i in varlist['a','b','c'] do FREQUENCIES VARIABLES=varlist[i] / ORDER=ANALYSIS. end I've notic...
In SPSS 11 it was possible to specify relative paths. Example: FILE HANDLE myfile='..\..\data\current.txt' /LRECL=533. DATA LIST FILE=myfile / ... This worked because apparently, SPSS 11 set the working folder to the path where the source .SPS file is saved. It seems that SPSS 18 always sets it's working folder to the installation fol...
I am preparing for analyses of the determinants of partner choice in SPSS, but basically I can't get off the ground because I don't know how to create new variables based on the information of each respondent's spouse (i.e. education, wages, social background, ethnicity etc.). Each respondent is currently identified by an ID#, and exis...
I have a case file "table" and file that I am trying to join. the case and file each have unique variable that I am trying to join. The case file contains the value but the matched file does not always have a matching value in the variable. When I join the two files together the records in the case gets dropped. Is there a way to do som...
I have 400,000 rows, each with an id, number of trials, and number of successes. I have (one) value for p, a hypothesized probability of success. I'd like to calculate an exact, binomial, one-sided p-value for each row, using its trials successes, and the global p. E.g., 1001 10 2 should give me 1001 10 2 2.639011e-01 for the pro...
Hi All, Probably a basic answer. I am trying to learn R and want to bring in an SPSS file, which I can open in SPSS. I have tried using read.spss from foreign and spss.get from Hmisc. Both error messages are the same. Here is my code: ## install.packages("Hmisc") library(foreign) ## change the working directory getwd() setwd('...