I'm trying to take a dataset and take the first n observations and take their name and use that to do something else. For example OBS Name 1 jkg 2 ddg 3 sdfs 4 asdf 5 sadf 6 rjkr Because the names are different I want to call them by observation number (i.e. Obs[1] for jkg) and then loop through the names to created subsetted data in another dataset. So Obs[1] should get me jkg and I should then be able to search another dataset for jkg and subset all values with the name to another dataset. Then it should go to Obs[2] to ddg and do the same, and then continue. I know this can be done by just searching the whole dataset for anything with the name of interest but even if I created a macro, I think there should exist a more succinct way of doing it but nothing I'm trying is really working.
... View more