| 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 |
|---|
|
| 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
| 
