BookmarkSubscribeRSS Feed
sahkul
Fluorite | Level 6
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
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
sahkul
Fluorite | Level 6
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;
luke1973
Calcite | Level 5

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.

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 19616 views
  • 4 likes
  • 3 in conversation