CSV into SPSS 21

[Rajeshms]

Dear all,

I am importing a CSV format data into SPSS 21, the problem am facing is that I am getting more cases than the data contains.And the cases are special characters.

I doubt this data is not supporting due to some reason follows...........,Once the data is imported into SPSS I can see double quotes, some words, colon, comma and many other special characters.

for more details :

I had 1000 cases and after importing I am getting 8622 cases, which include lots special characters and words which infact its not there in the data. This is the major problem, as I can get this to be done by using excel but I am having data more 30GB and more than excel supports. so in this case I need pull using CSV format. Is there any way or any method to pull CSV data into spss of the above mentioned characters in the CSV data.

thanks all

--

Regards,

Rajesh M S

[Lemon, John S.]

Rajesh

 

Without seeing a sample of the data it is hard to give an answer – but – it may be due to the way you are reading in the data. I would try using the “Read Text Data” dialog and look carefully at what is being imported into all the variables. It may be that you need to specify further delimiters.

 

Best Wishes

 

John S. Lemon

IT Services - Student Liaison Officer

University of Aberdeen

Edward Wright Building

Tel:  [phone]

 

IT news for Students

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rajeshms
Sent: 24 January 2013 09:56
To: [hidden email]
Subject: CSV into SPSS 21

 

Dear all,

 

I am importing a CSV format data into SPSS 21, the problem am facing is that I am getting more cases than the data contains.And the cases are special characters.

 

I doubt this data is not supporting due to some reason follows...........,Once the data is imported into SPSS I can see double quotes, some words, colon, comma and many other special characters.

 

for more details :

 

I had 1000 cases and after importing I am getting 8622 cases, which include lots special characters and words which infact its not there in the data. This is the major problem, as I can get this to be done by using excel but I am having data more 30GB and more than excel supports. so in this case I need pull using CSV format. Is there any way or any method to pull CSV data into spss of the above mentioned characters in the CSV data.

 

thanks all

--

Regards,

 

Rajesh M S

 

 

The University of Aberdeen is a charity registered in Scotland, No SC013683.

[GauravSrivastava]

Hi Rajesh,

Try the below link using import wizards :

http://opl.apa.org/Help/ImportingCSVToSPSS.aspx

Regards,

Gaurav

On Thu, Jan 24, 2013 at 3:25 PM, Rajeshms <[hidden email]> wrote:

Dear all,

I am importing a CSV format data into SPSS 21, the problem am facing is that I am getting more cases than the data contains.And the cases are special characters.

I doubt this data is not supporting due to some reason follows...........,Once the data is imported into SPSS I can see double quotes, some words, colon, comma and many other special characters.

for more details :

I had 1000 cases and after importing I am getting 8622 cases, which include lots special characters and words which infact its not there in the data. This is the major problem, as I can get this to be done by using excel but I am having data more 30GB and more than excel supports. so in this case I need pull using CSV format. Is there any way or any method to pull CSV data into spss of the above mentioned characters in the CSV data.

thanks all

--

Regards,

Rajesh M S

[David Marso]

I doubt that anyone can help you diagnose this without seeing a subset of data.
Verify that the problem exists in the posted subset and identify where it goes awry!
(post as attachment here DO NOT email it to me)
And MOST IMPORTANTLY the syntax which you are using to read the data.
--

Rajeshms wrote

Dear all,

I am importing a CSV format data into SPSS 21, the problem am facing is
that I am getting more cases than the data contains.And the cases are
special characters.

I doubt this data is not supporting due to some reason follows...........,*Once
the data is imported into SPSS I can see double quotes, some words, colon,
comma and many other special characters.*

for more details :

I had 1000 cases and after importing I am getting 8622 cases, which
include lots special characters and words which infact its not there in the
data. This is the major problem, as I can get this to be done by using
excel but I am having data more 30GB and more than excel supports. so in
this case I need pull using CSV format. Is there any way or any method to
pull CSV data into spss of the above mentioned characters in the CSV data.

thanks all
--
Regards,

Rajesh M S

[Albert-Jan Roskam]

>I am importing a CSV format data into SPSS 21, the problem am facing is that I am getting more cases than the data contains.And the cases are special characters.
>
>
>I doubt this data is not supporting due to some reason follows...........,Once the data is imported into SPSS I can see double quotes, some words, colon, comma and many other special characters.
>
>
>for more details :
>
>
>I had 1000 cases and after importing I am getting 8622 cases, which include lots special characters and words which infact its not there in the data. This is the major problem, as I can get this to be done by using excel but I am having data more 30GB and more than excel supports. so in this case I need pull using CSV format. Is there any way or any method to pull CSV data into spss of the above mentioned characters in the CSV data.

You probably have embedded newline characters in your values. You need to select the kind of quotes used to escape these. GET DATA is very flexible wrt line and column separators, quote and escape chars (single or double quotes). This is from SAVE TRANSLATE but gives an idea about what things you configure:

save translate outfile = '%temp%\somefile.csv'
  /textoptions delimiter="," qualifier='"' decimal=dot format=plain /platform=windows
  /type=csv /replace /fieldnames /cells=values .

=====================
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