Hi,
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.
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.
Thanks,
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.
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.
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).
Question:
Option A : Do I I create ONE new table which hold all the data from the 5 tables (duplicated)
or
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?
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.