Re: CSV into SPSS 21

Posted by David Marso on Jan 24, 2013; 12:32pm
URL: http://spssx-discussion.165.s1.nabble.com/CSV-into-SPSS-21-tp5717640p5717644.html

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