Solved

help in SPSS reading the import delimited text file

Posted on 2013-01-19
5
577 Views
Last Modified: 2013-01-20
Hello everyone, i have question please.
I have imported text file which contains numeric and string. the problem is the string names doesn't show in its full name, there are missing characters in it. i clicked in Variable view and i changed the string characters to 4, because the maximum word such as ICMP is 4 characters. i saved the work, restart the SPSS, the  string characters is 4 but I see ICMP as ICM, which means there is a missing character the 4th one!!  if i open the file in notepad or excel i can see the full name. any help

Thanks
*sorry i could not find the SPSS in the search to match my topic
3.JPG
0
Comment
Question by:reoroman
  • 3
5 Comments
 
LVL 9

Accepted Solution

by:
richdiesal earned 500 total points
ID: 38798378
Are you using the SPSS text importer?  If so, you need to specify there what your delimiters, lengths, etc. are _while importing_.  But the specific options you'll need depend on what your original text file looks like.  You can't modify this in SPSS later.
0
 

Author Closing Comment

by:reoroman
ID: 38799475
super ... you are great man... Thanks a lot
0
 

Author Comment

by:reoroman
ID: 38799893
To: richdiesalPosted, can i invite you to participate in the next question please.. i do not know how to invite you there, but i will come back here and past the link for it.
0
 

Author Comment

by:reoroman
ID: 38799915
here is my question i hope you can find it.


SPSS selection some records and save it on another file
Asked by: reoroman
Hello everyone. I want to ask question regarding SPSS or if we can do the same work in EXCEL.

suppose i have file which contains 500000 records and in spss it looks like this
v1    v2      v3
2      3        1
23    34      2
43    5        1
34    6        3

okay... so in V3 there are only 1, 2 and 3 numbers which means something to me.
i want to take 1000 records from v1, v2 which only belong to number 1 in v3. and save it on my desktop..
how can i do that?
thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question