SAS as a data source

  • Hi I am very new to SSRS. I am a SAS programmer.

    I have SSRS 2005 in my machine. I would like to create a report using SAS (9.1.3) dataset file.

    And then display that report on Sharepoint. Is there a way to do this. thanks

  • Not sure about using a SAS dataset directly , but you could use SAS ODBC to connect to SQL Server db and run the query from there.

  • thank you steveb. Would you happen to have an example or can you walk me through, with query connection string etc?

  • Sorry i don't have any examples on hand as I do not use SAS at all at the moment i am unable to run any tests.

    Try looking at the SAS website for SAS ODBC documentation

  • Thanks. I'll see if I can find something on the SAS website.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply