DATA Step, Macro, Functions and more

End of File Warning messages

Reply
Occasional Contributor
Posts: 8

End of File Warning messages

Hi,

I'm getting the end of file warning messages after the execution of code.
The code is running fine, this code was running fine earlier as well.

This has happened few times over the last 2/3 days.

Any idea why this happens??

Example below.

15
16 proc sql;
17 create table XCDW_PF.Renewals_Fact_Table2 as
18 select a.*, b.policy_number
19 from XCDW_PF.Renewals_Fact_Table a left join
20 XCDW_PF.Policies b
21 on a.policy_key = b.policy_key
22
23 ;
WARNING: End of file.
WARNING: End of file.
NOTE: Table XCDW_PF.RENEWALS_FACT_TABLE2 created, with 3635740 rows and 35 columns.

24 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 1:05.00
cpu time 1:02.73
Super Contributor
Super Contributor
Posts: 3,174

Re: End of File Warning messages

Please reveal more about the LIBNAME allocation for XCDW_P, specifically explain what it is and where it resides. As well, showing your SAS code that allocates the source-reference would also be useful.

Info about SAS version, OS platform, where SAS is installed (either local or remote server) will be quite helpful, as with most all forum posts.

Scott Barry
SBBWorks, Inc.
Occasional Contributor
Posts: 8

Re: End of File Warning messages

libname XCDW_PF '/home/data/Prod/cvm/rac/rescue/retention/xcdw_pf' ;

This is in Unix.

SAS is on Unix and being accessed through SAS EG.

It seems to me the problem because of Oracle.

Another example where the probelm occurs is:

proc sql;

connect to oracle(user=sas_user password=a67774 path='@pday' PRESERVE_COMMENTS);
create table XCDW_PF.Policies as
select * from connection to oracle
(
select /*+ full(pd)*/
pd.policy_key,
pd.policy_number,
pd.resignation_date,
pd.agreement_status,
pd.first_start_date,
pd.cover_start_date,
pd.cover_expiry_date,
pd.renewal_date,
pd.current_row,
pd.row_added_date,
pd.row_expiry_date,
pd.payment_frequency,
pd.years_of_renewal,
prd.product_code,
prd.package_code,
prd.service_level_code
from ccm_owner.ad_hoc_fact_table ah
,ccm_owner.policy_dimension pd
,ccm_owner.product_dimension prd
,ccm_owner.account_dimension ac
where
ah.policy_key = pd.policy_key
and ah.product_key = prd.product_key
and ah.account_key = ac.account_key
and ac.account_sub_type = 'Affinity'
and prd.breakdown = 'B'
and pd.renewal_date >=TO_DATE('01JAN2009','DDMONYYYY')
);
disconnect from oracle;
quit;
New User
Posts: 1

Re: End of File Warning messages

This was happening to me (In random places where I was not working with any files except for datasets) and I think it was only occurring when I was trying to view/move around the log file within in Enterprise Guide. The output etc was fine - so at the moment I assume it was because I was moving around the log file or maybe even lst/result file e.g. if I reran but just left it running it would finish w/o the warning.

Ask a Question
Discussion stats
  • 3 replies
  • 5290 views
  • 0 likes
  • 3 in conversation