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?
... View more
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.
... View more
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.
... View more
Aaagh! I spoke too soon. The following date (cut and pasted from SAS) t1.TrnDt = 12JUN2007:00:00:00.000 The above date gives an "After" result to the following calculated field; CASE WHEN t1.TrnDt >= '01Jan2011'd THEN "After" ELSE "Before" END But surely 2007 is BEFORE 2011 ??? Why does my case statement fail??
... View more
This is easy but I am struggling with it. Field t1.TrnDt is a date but the following syntax gives an error. I am try to create a new computed column. What's wrong with this? CASE WHEN t1.TrnDt > "01/01/2011" THEN "Late" ELSE "Early" END
... View more