DATA Step, Macro, Functions and more

Use a list in a macro variable

Accepted Solution Solved
Reply
Valued Guide
Posts: 858
Accepted Solution

Use a list in a macro variable

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.


Attachment

Accepted Solutions
Solution
‎12-07-2014 01:22 PM
PROC Star
Posts: 7,356

Re: Use a list in a macro variable

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?

View solution in original post


All Replies
PROC Star
Posts: 7,356

Re: Use a list in a macro variable

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?

Valued Guide
Posts: 858

Re: Use a list in a macro variable

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;


Solution
‎12-07-2014 01:22 PM
PROC Star
Posts: 7,356

Re: Use a list in a macro variable

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?

Valued Guide
Posts: 858

Re: Use a list in a macro variable

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 253 views
  • 0 likes
  • 2 in conversation