topic data not refreshing or give 0 observation though table has data in SAS Programming

data not refreshing or give 0 observation though table has data

jainmo — Thu, 19 May 2022 02:55:57 GMT

I am working with oracle view. when I open view in toad or developer have to refresh it twice ot thrice to see data.

In my sas code, I have automate the code bu now for last 2 -3 week its not getting refresh. I did create do loop but still not get result. I included this dataset becuase earlier I was getting 0 observation but then when I did this it worked but now suddenly getting 0 observation.

data x;

set t;

do i=1to 5;

output;end;

run;

proc sql;

create table t as

select * from x;

quit;

Re: data not refreshing or give 0 observation though table has data

SASKiwi — Thu, 19 May 2022 03:30:25 GMT

Please post the complete SAS log of your program reading the Oracle data. The code you have posted doesn't read Oracle at all.

Re: data not refreshing or give 0 observation though table has data

Patrick — Thu, 19 May 2022 06:51:25 GMT

From what you describe and given you've also observed similar behavior when using toad or SQL Developer this feels very much not like a SAS issue but something to be solved on the DB side. If you can't investigate yourself then you need eventually to talk to a Oracle DBA.

I've worked with Oracle before but a view that needs multiple refreshes until it returns the expected data is nothing I've ever encountered.

Is this a "normal" view or by any chance a materialized view?