02-24-2017 10:18 AM
Kindly help me, I want to pull required data from 2 dataset with a data step.
I want to exclude the observations which are not in datasetB and in datasetA as follow
Note: here In C observation: 104 should be missed , and 105 should be there
Thanks in Advance
02-24-2017 10:33 AM - edited 02-24-2017 10:34 AM
103 bike is one of two records not in B and in A, so why have you put it in your desired output dataset C?
02-24-2017 10:34 AM
02-24-2017 10:43 AM
Am working with Clinical data, for Subject Elements, I need to set them One by One, if they are not in datasetB, they are said to be Non-completers of the study, so I've to exclude those subjects from A
02-24-2017 10:46 AM - edited 02-24-2017 10:48 AM
This will give you everyone from A who is also in B (i.e. excludes those from A who are not in B)
create table C as select * from A where yourIDVar in (select yourIDVar from B);
02-24-2017 11:02 AM
Let's break this down Santosh. You do not want those obs from A which are not in B, This throws out:
You say you do want 105 car in dataset C:
In this case, are you simply not looking for the dataset B itself? What are we not getting?
02-24-2017 11:10 AM
Not like that, As I said have to exclude the records which are "not in B" and "in A", Have to keep the records which are "in B" and "not in A"
02-24-2017 11:12 AM
Obviouslly, those of us reading this trhead don't understand what you are trying to do.
For each of the 4 records in data set c, separately, please explain why they were selected.
02-24-2017 11:33 AM
thanks all for your support!
I apologise for not being clear, My situation is like that!
Working with clinical data.
Let us take an example of Acadamic class,
class6 and class8
Class8 may have promoted students who are succeded, and class6 are striving for success, and if students not in class8 of class6 are said to be failures, and if there are individual students of both the classes are said to be succeeded.
still am not clear
02-24-2017 03:53 PM