sethladd

people = LOAD 'people' USING PigStorage(',') AS (ssn,date,uic);
medical_cases = LOAD 'medical_cases' USING PigStorage(',') AS (ssn,data,icd9);
joined = JOIN people BY ssn , medical_cases BY ssn;
STORE joined INTO 'out' USING PigStorage(',');

sethladd

require 'rubygems'
require 'libxml'
doc = LibXML::XML::Document.file('test.xml')
rs = doc.find('//R')
rs.each do |r|
 u = r.find_first('U')
 s = r.find_first('S')
 puts "S: #{s} and U: #{u}"
end
rs = nil