loop in SAS

goliPSU — Wed, 10 Oct 2012 17:35:29 GMT

This question is Not Answered.(Mark as assumed answered)

Goli Magoli Oct 10, 2012 12:59 PM

I have a SAS program that uses the micro and at the end is generating the following tables that I want to export it to SQL:

NCxC1993

NCxC1994

NCxC1995

NCxC1996

NCxC1997

I can use the following commands to create a table in SQL but I would like to use a loop:

/*proc sql;

create table sqldb.cxcuse_dense_1993 as

select * from NCxC1993;

create table sqldb.cxcuse_dense_1994 as

select * from NCxC1994;

create table sqldb.cxcuse_dense_1995 as

select * from NCxC1995;

create table sqldb.cxcuse_dense_1996 as

select * from NCxC1996;

create table sqldb.cxcuse_dense_1997 as

select * from NCxC1997;

quit;

run;*/

I am using the following loop but for some reason without any error does not create the tables in SQL (but the above command does)

%macro sqlloop(start=,end=);

%do year = &start %to &end;

create table sqldb.cxcuse_dense_&year as

select * from NCxC&year;

%end

%mend;

proc sql;

%sqlloop(start=1994,end=1995)

quit;

run;

/*-----------------------------------------------------------------------*/

quit;

run;

is there any thoughts on why the sqlloop does not work.

Thank you

Re: loop in SAS

Linlin — Wed, 10 Oct 2012 17:43:02 GMT

try adding ";" after %end

Re: loop in SAS

goliPSU — Wed, 10 Oct 2012 19:41:37 GMT

wow, Thank you so much

topic loop in SAS in SAS Programming

loop in SAS

Re: loop in SAS

Re: loop in SAS