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