Date:         Tue, 18 Jul 2006 21:38:43 -0700
Reply-To:     ouaganet@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         ouaganet@GMAIL.COM
Organization: http://groups.google.com
Subject:      Re: Sybase temporary tables with SQL pass-thru
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Thanks for explaining the pass-thru part of it!
Pagabas.

Mark Fisher wrote:
> proc SQL;
> connect to sybase (server=servername database=dbname user=USERID
> password=PASSWORD);
> execute (select column1, column2
>  into #temp_table1
>  from sales
>  where year=1985
>  select columna, columnb
>  into #temp_table2
>  from prices
>  where year=1985
> select column1 column2 columna columnb
> from #temp_table1,
> #temp_table2
> into #temp_table3
> where year=1985
> ) by sybase;
> create table DATASETNAME as
> select * from connection to sybase
> (select * from #temp_table3);
> disconnect from sybase;
> quit;
>
>
> "pagabas" <pagabas@yahoo.com> wrote in message
> news:1153095440.405606.190390@m79g2000cwm.googlegroups.com...
> >I am using transact-sql to store the result of a select into a sybase
> > temporary table.
> >
> > select column1, column2
> > into #temp_table1
> > from sales
> > where year=1985
> >
> > select columna, columnb
> > into #temp_table2
> > from prices
> > where year=1985
> >
> > With sybase transact sql there is no problem joining the tables and
> > selecting from the join.
> >
> > Can anyone demonstrate using the above codes  into a SAS SQL pass-thru
> > where we also make use of the temp tables names when joining?  The
> > codes I am using contains a lot of references to sybase temp table with
> > pound sign and I am not sure if it is worthwhile trying to wrap it with
> > SAS?
> > Thanks
> >