If I have a dataset with several variables and then want to
link up that dataset to another set , for eg...
Dataset 1:
ID Pass/Fail Type
1 pass Type1
2 Fail Type2
3 fail Type1
4 pass Type2
5 fail Type1
DATSET 2:
ID GROUP
1 A
2 B
3 C
4 D
5 E
How can I use ID from dataset 2 and check if they are type 1
in dataset 1 and check whether it failed or passed ?
And how can I make it more dynamic, as I will have to do
this every month with a new data but same variables.
Thanks