A little help with a macro variable needed

Flexymt — Tue, 23 Jun 2015 07:32:01 GMT

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.

Re: A little help with a macro variable needed

JonasE — Tue, 23 Jun 2015 13:49:42 GMT

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

Re: A little help with a macro variable needed

Flexymt — Tue, 23 Jun 2015 13:57:46 GMT

Thanks so much! You are the best!

topic Re: A little help with a macro variable needed in SAS Programming

A little help with a macro variable needed

Re: A little help with a macro variable needed

Re: A little help with a macro variable needed