Date:         Sat, 20 Jun 2009 10:45:16 -0700
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: PROC SQL+ FOR LOOP
Comments: To: "SUBSCRIBE SAS-L Joe H. Smith" <peesari.mahesh@GMAIL.COM>
In-Reply-To:  <200906201153.n5KAknib008346@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes

See <www2.sas.com/proceedings/sugi31/046-31.pdf>.

--
Jack Hamilton
jfh@alumni.stanford.org
Tots units fem força!




On Jun 20, 2009, at 4:53 am, SUBSCRIBE SAS-L Joe H. Smith wrote:

> Hi all,
> Is it possble to write a for loop in proc sql stmt,if so how can i
> do the
> following sql procedure in PROC SQL.
>
>
> BEGIN
> FOR CITY IN 1..100
> LOOP
> INSERT INTO asd VALUES('JOE','LONDON');
> END LOOP;
> END;
>
> how can i write the above code in proc sql...
> any inputs plz...
> Thanks IN Advance