Hi, Does anyone know how to create #temptables in SQL Server using SQL Pass through?
The following code runs successfully but there is no #temporaryTable in SQL Server.
Proc sql;
connect to sqlserver(...);
execute(select prod_id
into #temporaryTable
from PRODUCTS)
by sqlserver;
quit;
Thanks
Andrew
I think I have solved this by talking to a colleague.
The #temporaryTable only exists for the duration of the connection!
Hope this helps some one else.
Andrew
I think I have solved this by talking to a colleague.
The #temporaryTable only exists for the duration of the connection!
Hope this helps some one else.
Andrew
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.