How to repeat Proc SQL statements on Many datasets.

anitha — Thu, 06 Jun 2013 23:13:41 GMT

I have created a proc SQL statements to merge datasets in a given year. I would like to repeat this merge step for many years.

Here is my sample program for the year 1985.

proc sql;

create table folder1.OPT_price1985 as

select a.*, b.*

from folder1.OPT1985 as a , folder1.price1985 (keep = secid date close volume) as b

where a.secid = b.secid and a.date = b.date;

quit;

I would like to repeat this like a do loop for 20 years. I tried the do loop macro but it did not work.

Re: How to repeat Proc SQL statements on Many datasets.

TomKari — Fri, 07 Jun 2013 02:11:38 GMT

Hi, anitha

This should get you started. Just change the 1984 %to 1986 to your range.

Tom

%macro MultiYearSQL;
%do yr=1984 %to 1986;

proc sql;
   create table folder1.OPT_price&yr as
    select a.*, b.*
     from folder1.OPT&yr as a , folder1.price&yr (keep = secid date close volume) as b
      where a.secid = b.secid and a.date = b.date;
quit;

%end;
%mend MultiYearSQL;

%MultiYearSQL

topic Re: How to repeat Proc SQL statements on Many datasets. in SAS Programming

How to repeat Proc SQL statements on Many datasets.

Re: How to repeat Proc SQL statements on Many datasets.