Can qlikview access SAS SPDS materialized views or would we have to create a SAS SPDS table for the same? What would be faster a materialized view or creating a table?
I assume that when you access data from an SPDS server, this is done not by reading the physical file, but by connecting with the server and have it deliver the data. So I guess that you can access both materialized views and normal views from the server.
Yes, that is the way things normally work with material views - unless you make changes to the underlying tables, then the view will run more slowly.
Is your problem that creating the view takes a lot of time, or is it that the access to it takes a lot of time? In the latter case, the problem may be that some of the underlying tables were updated after the materialized view had been created. Depends on the setting on the server (and what kind of server you are using, e.g. Oracle and MS SQL also have materialized views), but often the materialized view is not updated until you access it, unless you update the view explicitly. You will have to look that up in the SPDS documentation.
My first thought is to access SPDS via ODBC, not via "SAS" if I understand what you have tried correctly.
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.