DATA Step, Macro, Functions and more

A little help with a macro variable needed

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

A little help with a macro variable needed

Hey,

I just need a little bit help with some macro coding.

I have a random sample of 30 observations from the full dataset of 21000. The first code you see is where i create a macro variable for each of the 30 observations from the sample.

proc sql noprint;

select X

into :X1-X30

from DatasetSample;

quit;

The second code is posted below. The point of this loop macro variable is to create 30 unique datasets by using the values from the macro variables X1-X30.
The problem arises in the "where" statement. For the first loop i want the where statement to look like : X=X1, for the second loop i want it to look like X=X2 and so on.

%macro sql(n)


%do r=1 %to &n;

proc sql;

create table Company&r as

select *

from DatasetTotal

where X=&X&r;           /* This code right here doesnt work. By inserting n=30 i thought the loop would automically assume X=X1, X=X2, X=3 and so on*/

quit;

%end;

%mend;

% SQL(30)

Any tips or help would be greatly appreciated.



Accepted Solutions
Solution
‎06-23-2015 09:49 AM
New Contributor
Posts: 4

Re: A little help with a macro variable needed

Try changing &X&r to &&X&r. Should do the trick.

View solution in original post


All Replies
Solution
‎06-23-2015 09:49 AM
New Contributor
Posts: 4

Re: A little help with a macro variable needed

Try changing &X&r to &&X&r. Should do the trick.

New Contributor
Posts: 2

Re: A little help with a macro variable needed

Thanks so much! You are the best!

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 184 views
  • 1 like
  • 2 in conversation