[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

Looping in SPSS

I have a very large data set, it contains 5 files of more than 1,000,000 cases each.  I have a common field name in each file.  I need to go through one file and file all the cases in the other file which match the common field value.
0
heathroe2
Asked:
heathroe2
  • 2
  • 2
1 Solution
 
richdiesalCommented:
Can you explain this with a little more detail?  I'm not sure what you mean by "file all the cases."  Are you trying to create a combined dataset?  If so, you should use the Merge Files command in the Data menu.
0
 
heathroe2Author Commented:
These are medical records.  I have a file for home health, nursing facility, inpatient hospital, ect.  I have a unique patient id.  I need to find all the patients who have home health and all of thier other claims in other settings.  Thank you
0
 
richdiesalCommented:
I think Merge Files will give you what you are looking for - you can use the patient ID as a merge code so that it can link the files together, which will ultimately give you a dataset containing the patient ID and data from every other file in a single dataset.  Each file needs to be sorted in ascending order by patient ID before you begin though.

I would, however, recommend testing it with a few hundred cases from each dataset first, until you are sure it is working correctly.  SPSS does not handle datasets that large very efficiently.

This video looks like it might help: http://www.youtube.com/watch?v=ilyy6aZEy_A
0
 
heathroe2Author Commented:
Thank you!
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now