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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.