07-13-2016 04:02 AM
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.
08-11-2016 04:03 PM