How do I Create and Use Temporary Table in SAS SQL with SSRS?

Reply
Learner
Posts: 1

How do I Create and Use Temporary Table in SAS SQL with SSRS?

I am running SAS SQL in SSRS and cannot use all of the SAS Proc features. I would like to be able to create a temporary table and then be able to select data from that table, join to other tables, etc.   The code below works in Enterprise Guide, but not in SSRS.  We are using SAS version 9.4 and an OLEDB connection string to access SAS datasets from SSRS.

 

PROC SQL;

CREATE TABLE work.TempTable AS

SELECT Distinct Column1

FROM dev.PermTable

;

Select *

FROM work.TempTable

WHERE Column1= 'ABC'

;

 

Super User
Posts: 19,052

Re: How do I Create and Use Temporary Table in SAS SQL with SSRS?

How are you using SAS SQL in SSRS? Are you using SQL Pass Through or using code from SAS in SSRS? If so, you need to make sure your code is T-SQL valid which is formatted in a different order. A quick google search should show you some basic examples.
Ask a Question
Discussion stats
  • 1 reply
  • 308 views
  • 0 likes
  • 2 in conversation