SAS Federation server - How to access view created in BAse SAS DSN from SAS Clients like SAS EG

rahutnimje — Tue, 26 Jun 2018 13:28:53 GMT

Hi Everyone,

I am new to SAS Federation server. And I am stuck with the following things.

I created the view using Oracle and Postgres data to the BASE DSN with certain path configured.

I wanted to use this view from SAS clients such as SAS EG or DI for the path (as a library), But when I am trying it with proc sql or data step it shows some metadata defintion as below :

SAS_ROW_ID SAS_CHECKSUM_ SAS_TEXTVIEW_

-1 -66527388211 MAVOACOGVGFSUKGGRGDETK2KVG.........

I even tried with Proc fedsql, But then it throws certain error. It might be reading the definition, but SAS is not understanding that and giving the below error:

ERROR: Table "ora.FEDDB.SALES_DATA_ORACLE" does not exist or cannot be accessed.

Even if I create the view using the data from BASE SAS DSN, while accessing it gives the same error.

Question 2:

I have another question on SAS Cache view :

When I create the chache and try to refresh, it creates the new cache table in the schema where we define to create,

with some default naming conventions.

Is it possible to delete the older cache and replace it with new with some customized naming conventions?

I tried running purge cache statement, but that got failed with some error :

[22001]String data, right-truncated Order Priority

Re: SAS Federation server - How to access view created in BAse SAS DSN from SAS Clients like SAS EG

ACBradley — Tue, 14 Aug 2018 15:00:07 GMT

Hi rahutnimje,

On your first question:

Are you attempting to create a Federation Server view on an Oracle DBMS view or a BASE SAS view?

Could you list the CREATE DSN statement used in Federation Server?

On your second question:

The ALTER CACHE...REFRESH will create a new cached object with default naming. You can issue a DROP CACHE statement to remove the view.

Clark

topic SAS Federation server - How to access view created in BAse SAS DSN from SAS Clients like SAS EG in SAS Data Management

SAS Federation server - How to access view created in BAse SAS DSN from SAS Clients like SAS EG

Re: SAS Federation server - How to access view created in BAse SAS DSN from SAS Clients like SAS EG