Your SAS programs, embedded in web apps and elsewhere

View defined but not seen in EG 4.2 or Management Console

Reply
Regular Contributor
Posts: 207

View defined but not seen in EG 4.2 or Management Console

Hello,
I have created a view and can select from it as well but somehow it does not show up as an object when I use EG4.2 or the Management Console.

create view Test_BASE.WORK_myway as select * from WORK.myway;

select * from Test_BASE.WORK_myway;

--result is displayed
Super Contributor
Posts: 356

Re: View defined but not seen in EG 4.2 or Management Console

Have you defined it in the Metadata?
Regular Contributor
Posts: 207

Re: View defined but not seen in EG 4.2 or Management Console

Posted in reply to twocanbazza
Hello twocanbazza,
A good question and that was/is indeed the problem. I am unable to register a VIEW based on a WORK table in the metadata.
1. If I use EG 4.2 via Tools -> Update Library Metadata I get the error
"No metadata objects found matching the specified URI".
Odly, one of the three Views is registered and ready to use. (strange)

2. If I use SAS OLAP Cube Studio -> Register tables and select the tables
that are part of the library, I get the error "WORK.MygreatView.DATA does not exists."
The table is then registered without any variables or data.

Note, this all works fine if I register VIEWS that do --not-- select from the WORK library but as soon as the view select from the WORK library the whole thing causes problems.

Why I use the WORK library? - I want to create prompt source tables that are filled depending on the user login (dynamic PROC SQL - identity driver properties) by a STP that executes as soon as the web report opens.
Regular Contributor
Posts: 207

Re: View defined but not seen in EG 4.2 or Management Console

I managed to register the tables in metadata with the following code:

proc metalib;
omr (library="Amylib");
select(View1);
report;
run;

(the code generated by EG 4.2 is missing the SELECT line).
Ask a Question
Discussion stats
  • 3 replies
  • 322 views
  • 0 likes
  • 2 in conversation