I have written code in proc sql using the execute command to run sql code. This all works well and I can create perm/temp files in the SQL db.
For our production version we will only be able to create temp tables (#tablename/##tablename). What I will need to do is bring this temp file into actual sas to create a report and then output to client (Excel/PowerBI). I am conscious that the temp table will only exist for the execute(….) by sqlserver session. Do you know how I can do this?
we use Oracle but...
there is a "SAS Access Interface to Microsoft SQL Server" chapter in the SAS documentation:
libname mydblib sqlsvr noprompt="uid=testuser; pwd=testpass; dsn=sqlservr;" stringdates=yes; proc print data=mydblib.customers; where state='CA'; run;
- Cheers -
This might be specific to SQLServer, but does your method mean temporary tables can be pulled into SAS as well?
In SQLServer they are denoted by #tablename and only exist for the session of the user.
Need further help from the community? Please ask a new question.