Use a list in a macro variable

[Steelers_In_DC]

I have two datasets, I would like to use a list of variables from one to pull more detailed information from the first.  An example of the code is attached, I would like to use the &list to pull any number of variables from the list.

[art297]

Not sure what you're looking to do with the list. Can you provide and example of how you would like to use such a list?

[Steelers_In_DC]

I have a large dataset A and a small dataset B.  I want to get a list of ID's from B to pull all the history from A.

I think I've found another step in the process but am still not sure how to use the list:

data test;

do i=1 by 1 while (scan("&list.",i) ne '');

     list=scan("&list.",i);

     output;

end;

drop i;

run;

[art297 · Accepted solution]

So you basically simply want to accomplish a join, but using a list? i.e., if an id is in b, you want the corresponding record(s) from A?

Approximately how many IDs do you have in B?

[Steelers_In_DC]

That's it and I feel silly now over thinking it.  It's just a join, the number of IDs will vary.  I think I know what I'll have to do now.

Thank you for your help.