Hi Community, I am trying to solve a unique requirement and need your help if an efficient way exists to get this done. I have >10 datasets in my library and each have an ID. I need to create a dataset to as a summary of if an ID is present in each dataset. data CLASS(label='Student Data');
infile datalines dsd truncover;
input ID:$2. Sex:$1. Age:2. Height:3.2 Weight:2.2;
datalines;
1, M, 14, 69, 112.5
2, F, 13, 56.5, 84
3, F, 13, 65.3, 98
4, F, 14, 62.8, 102.5
5, M, 14, 63.5, 102.5
;
run;
data SUBCLASS1(label='Student Data');
infile datalines dsd truncover;
input ID:$2. Sex:$1. Age:2. Height:3.2 Weight:2.2;
datalines;
1, M ,14, 69 ,112.5
3, F ,13 ,65.3, 98
5, M ,14 ,63.5, 102.5
;
run;
data SUBCLASS2(label='Student Data');
infile datalines dsd truncover;
input ID:$2. Sex:$1. Age:2. Height:3.2 Weight:2.2;
datalines;
2, F, 13, 56.5, 84
3, F, 13, 65.3, 98
5, M, 14, 63.5, 102.5
;
run; Based on the datasets created above. I need my output to look like this: ID CLASS SUBCLASS1 SUBCLASS2 1 Class Subclass1 2 Class . Subclass2 3 Class Subclass1 Subclass2 4 Class . . 5 Class Subclass1 Subclass2 Thank you for your time and effort. Best, SC.
... View more
