02-14-2017 10:36 AM
I have created a "View" in SAS Enterprise. (My first!)
If I open a brand new project then I expect to be able to create a query based on that "view" created earlier.
QUESTION: Where will I find the view, what library, what server? etc?
And yes, I do have an understanding that a "view" is not real data - merely a view.
02-14-2017 11:02 AM
You should have assigned the view to a library just like a dataset. The instructions for building the view results reside in that library. If you did not specify then it was very likely placed in the WORK library. Which means that it was likely cleaned up when you ended your SAS session and that you likely need ot re-do the work and place the view in a permanent library to avoid recreating it every time you need it.
02-14-2017 11:24 AM
I understand - almost!
I right-clicked on the query that creates the view and then click "properties" then click "results".
In the "results" I changed the output folder and filename to an existing library.
However, now when I run the query I get the following error;
"ERROR: The CREATE VIEW statement cannot be processed directly by the database.
ERROR: Create View failed."
mmmm...I am not sure what to do now??
All help appreciated.
02-14-2017 01:09 PM
Are creating that in a library that represents an EXTERNAL database? I'm not sure how that would work. I only use SAS views associated with SAS data sets.
02-14-2017 06:15 PM
02-17-2017 05:21 AM
Thanks for feedback on my "view" question.
I have been out of office for a couple of days.
Allow me clarify the question.
My data is static historic data with zero updates/additions.
The structure is not friendly as sometimes data is split over 5 tables when it should all be in the same table. This makes simple queries more complex (appending 5 tables).
Option A : Do I I create ONE new table which hold all the data from the 5 tables (duplicated)
Option B: Do I create a view of the 5 tables
The number of records is fairly large ... which would make the option "B" "view" slower than if I created a new table?
Or is it breaking every rule in the book to create a new table?
02-18-2017 02:00 AM