Re: Need Help: How To Combine Data From 3 Different Files?

[Alan Mead]

They are probably blank records in the pst.sav file.  If all of the good 
records have some non-missing variable, like X, then you could use 
syntax like:

* for numeric variables.
select if( not sysmis(X)).
execute.

or

* for string variables.
select if(not x='').
execute.

to remove such cases (they are removed from the working file in memory 
as soon as you execute them, and they are permanently removed when you 
save the working data file.

There's probably an easy interface way to do this, like highlighting 
those rows and pressing "Delete".

-Alan


On 6/26/2012 11:00 PM, zamdlr wrote:
> I have 3 files before combined, which is pst.sav - 109 cases, pdt.sav - 17
> cases & akaun.sav - 23 cases, when i combine this 3 files using this syntax:
>
> ADD FILES
> /FILE="C:\Documents and
> Settings\KMS\Desktop\Research\ResearchICTMPPB\soalselidikict\pst.sav"
>
> /FILE='C:\Documents and
> Settings\KMS\Desktop\Research\ResearchICTMPPB\soalselidikict\pdt.sav'
> /FILE='C:\Documents and
> Settings\KMS\Desktop\Research\ResearchICTMPPB\soalselidikict\akaun.sav'
> .
> EXECUTE.
>
> I get a new file will all the combine data, but the problem is, there were
> empty cases from 110 onward until 142, from 143 onward i started to get all
> the data from other files. What should i do to rectify this problem or how
> can i delete those empty cases? Thank you.

--
Alan D. Mead, Ph.D.
Assistant Professor of Industrial and Organizational Psychology
College of Psychology
Illinois Institute of Technology
3101 South Dearborn, 2nd floor
Chicago IL 60616

+312.567.5933 (Campus)
+815.588.3846 (Home Office)
+312.567.3493 (Fax)

http://www.iit.edu/~mead
http://www.alanmead.org

Announcing the Journal of Computerized Adaptive Testing (JCAT), a
peer-reviewed electronic journal designed to advance the science and
practice of computerized adaptive testing: http://www.iacat.org/jcat