Hi,
I have a frame "treat" and want to find matched pairs in the data frame
"control". In the matched (combined) data frame there should be two
variables (0/1),indicating the "source" of the data (treat or control),
so that it is possibe to set a "filter" (extraxt/select data).
#Here are the dataframes (my real data frames have many variables)
treat <- data.frame(age=c(1,1,2,2,2,4),
school=c(10,10,20,20,20,11),
out1=c(9.5,2.3,3.3,4.1,5.9,4.6))
control <- data.frame(age=c(1,1,1,1,3,2),
school=c(10,10,10,10,33,20),
out2=c(1.1,2,3.5,4.9,5.2,6.5))
print(treat)
print(control)
matched.data.frame <- ?????? #Match "treat" "control" by age school
#My SPSS syntax would be similar to this:
MATCH FILES FILE="treat" /IN=fromtreat
/FILE="control" /IN=fromcontrol
/BY age school.
SELECT IF fromdad AND fromfam. #select data, set filter
The /IN= option creates a 0/1 variable that indicates the
"source" of the data
The resultand matched data frame should have
the following structure:
age school out1 out2 fromtreat fromcontrol
1 10 9.5 1.1 1 1
1 10 2.3 2.0 1 1
....
4 11 4.6 NA 1 0
3 33 NA 5.2 0 1
....
I tried "which" and "match", but I failed and was unlucky looking
at the help/archive. Merge doesn´t do the job, because it makes
all possible matches.
Thank´s for any help!
Udo
--------------------------------------------
Udo K N G
Ö I
Clinic for Child an Adolescent Psychiatry
Philipps University of Marburg / Germany
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
