topic Re: Use a list in a macro variable in SAS Programming

Use a list in a macro variable

Steelers_In_DC — Sun, 07 Dec 2014 16:53:31 GMT

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.

Re: Use a list in a macro variable

art297 — Sun, 07 Dec 2014 17:29:35 GMT

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?

Re: Use a list in a macro variable

Steelers_In_DC — Sun, 07 Dec 2014 17:40:24 GMT

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;

Re: Use a list in a macro variable

art297 — Sun, 07 Dec 2014 18:22:30 GMT

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?

Re: Use a list in a macro variable

Steelers_In_DC — Sun, 07 Dec 2014 18:28:52 GMT

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.