A little help with a macro variable needed

[Flexymt]

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.

[JonasE · Accepted solution]

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

[Flexymt]

Thanks so much! You are the best!