Does Sharepoint have the ability to output to SPSS ?

[Art Kendall]

I have a pro bono client who is doing a survey in Sharepoint.  It is supposed to have the ability to produce EXCEL files.

Has anybody used data from Sharepoint?  Can it produce output other than Excel output?

Did you have any problems in using the data specific to it being from Sharepoint?

Any caveats?

Any issues I should anticipate?

[Yang, Hongwei]

Hi Art,

 

I have never used Sharepoint myself. But, seems that SPSS can perfectly handle EXCEL files. Then, why do you want anything “other than Excel output”, if you use SPSS for data analysis?

 

Hongwei “Patrick” Yang, University of Kentucky

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art Kendall
Sent: Wednesday, August 21, 2013 2:42 PM
To: [hidden email]
Subject: Does Sharepoint have the ability to output to SPSS ?

 

I have a pro bono client who is doing a survey in Sharepoint.  It is supposed to have the ability to produce EXCEL files.

Has anybody used data from Sharepoint?  Can it produce output other than Excel output?

Did you have any problems in using the data specific to it being from Sharepoint?

Any caveats?

Any issues I should anticipate?

--

Art Kendall

Social Research Consultants

Art Kendall
Social Research Consultants

 

---

View this message in context: Does Sharepoint have the ability to output to SPSS ?
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

[Art Kendall]

SPSS distributes its I/O DLLs freely so it possible that a particular piece of software would produce files that are .SAV files.

SPSS can input EXCEL files.  However, it does not do so "perfectly". 
If you go through the archives for the list, you will see that there have often been problems reading Excel files.



On 8/21/2013 2:53 PM, Yang, Hongwei wrote:

Hi Art,

 

I have never used Sharepoint myself. But, seems that SPSS can perfectly handle EXCEL files. Then, why do you want anything “other than Excel output”, if you use SPSS for data analysis?

 

Hongwei “Patrick” Yang, University of Kentucky

 

From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Art Kendall
Sent: Wednesday, August 21, 2013 2:42 PM
To: [hidden email]
Subject: Does Sharepoint have the ability to output to SPSS ?

 

I have a pro bono client who is doing a survey in Sharepoint.  It is supposed to have the ability to produce EXCEL files.

Has anybody used data from Sharepoint?  Can it produce output other than Excel output?

Did you have any problems in using the data specific to it being from Sharepoint?

Any caveats?

Any issues I should anticipate?

--

Art Kendall

Social Research Consultants

Art Kendall
Social Research Consultants

 

---

View this message in context: Does Sharepoint have the ability to output to SPSS ?
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Art Kendall]

SPSS distributes its I/O DLLs freely so it possible that a particular piece of software would produce files that are .SAV files.

SPSS can input EXCEL files.  However, it does not do so "perfectly". 
If you go through the archives for the list, you will see that there have often been problems reading Excel files.

leading zeros might or might be be a problem -- values for identifiers for which district a court is in have leading zeros, as do FIPS codes, ZIP codes, etc. 

Dates might or might not be a problem.

Sometimes when people say an Excel file they mean a CSV file. 

I try to have as clear and readable and audit trail in all instances. I work extra hard at it when the analysis may become involved in litigation.
If people have already worked with Sharepoint data they may have learned some lessons.

At one highly UNlikely extreme, it is possible that the data will already be in SPSS format with the metadata complete. By complete, I mean that variable labels, values, formats, date, are dates, currency is currency, etc

At a middle possibility, maybe there is a way to specify that all fields be quoted strings, and I can work out things by SPSS transformations.

At a worse case scenario, I'll have to work with each variable separately in Excel,  and then build the metadata (variable view) by keying everything, and then transform data to a useable form..

I have not used Sharepoint.    When I Googled "Sharepoint survey", it appears that there is a questionnaire capability.

So, if people on the list have experiences that relate to
1) what to have the client specify in sharepoint before they gather the data
2) what to specify in sharepoint to get it ready to output to EXcel
3) what to do in Excel before reading the data into SPSS
4) what workarounds did they find useful in SPSS.

I would like to hear about those experiences.

On 8/21/2013 6:18 PM, Yang, Hongwei [via SPSSX Discussion] wrote:

Hi Art,

 

I have never used Sharepoint myself. But, seems that SPSS can perfectly handle EXCEL files. Then, why do you want anything “other than Excel output”, if you use SPSS for data analysis?

 

Hongwei “Patrick” Yang, University of Kentucky

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art Kendall
Sent: Wednesday, August 21, 2013 2:42 PM
To: [hidden email]
Subject: Does Sharepoint have the ability to output to SPSS ?

 

I have a pro bono client who is doing a survey in Sharepoint.  It is supposed to have the ability to produce EXCEL files.

Has anybody used data from Sharepoint?  Can it produce output other than Excel output?

Did you have any problems in using the data specific to it being from Sharepoint?

Any caveats?

Any issues I should anticipate?

--

Art Kendall

Social Research Consultants

Art Kendall
Social Research Consultants

 

---

View this message in context: Does Sharepoint have the ability to output to SPSS ?
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Does-Sharepoint-have-the-ability-to-output-to-SPSS-tp5721666p5721669.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML