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