Hello chaps,
Question for you: is it possible to upload to memory a table when all you have is a SQL query, not an actual table?
In other words, I am suposed to do a dashboard on a set of data for a client, but what the client has given me is not a table name bot a sql query. I was under the impression that it would not matter but I am finding otherwise.
So when I open the Data Preparation module the options I have is to add a table to the query,
I have fiddle a bit with the code in the CODE tab and I have managed to come up with a set of code that runs successfully and, in theory, creates a view off the sql query I have.
So this runs successfully. But I cannot find the TEMP_LASR_VIEW_0 in the Administration part of VA. Where is that TEMP_LASR_VIEW_0 view created??
Unfortunately I don't have access to E.Guide, SAS Studio or anuthing like that, only to SAS VA.
Thanks for your help.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.