ERROR: WRITE TO WORK.NINST11ADATA.DATA FAILED. FILE IS FULL AND MAY BE DAMAGED. (shorten months?)

Reply
Frequent Contributor
Posts: 135

ERROR: WRITE TO WORK.NINST11ADATA.DATA FAILED. FILE IS FULL AND MAY BE DAMAGED. (shorten months?)

6           %MACRO EXTRACT(DSO,HDR,LN,STARTDT,ENDDT);                      
9                                                                               
10             /**EXTRACT FROM CLAIMS WAREHOUSE - NINST**/                      
2                                                          THE SAS SYSTEM       
                                                                                
11                                                                              
12                 PROC SQL;                                                    
13                   CONNECT TO DB2(SSID=DBR0);                                 
14                     EXECUTE(SET CURRENT DEGREE='ANY') BY DB2;                
15                                                                              
16                   CREATE TABLE &DSO.DATA AS                                  
17                     SELECT * FROM CONNECTION TO DB2                          
18                      (SELECT                                                 
19                         HD.SR_PRIME_RCD_DATE AS CLMRECDT,                    
20                         LN.CLM_BGN_SRVC_DT AS CLMSVCDT,                      
21                         LN.CLM_END_SRVC_DT AS CLMENDDT,                      
22                         LN.SPONSOR_SSN AS SPONSORSSN,                        
23                         LN.PATNT_AMMS_ID_NO AS PATIENTID,                    
24                         HD.PATNT_LAST_NAME AS PTLASTNAME,                    
25                         HD.PATNT_FIRST_NAME AS PTFIRSTNAME,                  
26                         HD.PATNT_DOB AS PTDOB,                               
27                         HD.PATNT_ADDR_LN_1 AS PTADD1,                        
28                         HD.PATNT_ADDR_LN_2 AS PTADD2,                        
29                         HD.PATNT_CITY AS PTCITY,                             
30                         HD.PATNT_STATE AS PTSTATE,                           
31                         HD.PATNT_ZIP_CODE AS PTZIP,                          
32                         HD.ALLOWED_CHRG AS ALLCHRG,                          
33                         LN.APRVD_AMT AS APRVDAMT,                            
34                         LN.PAYMENT_AMT AS PYMTAMT,                           
35                         HD.BLG_PRVDR_NAME AS BPROVNAME,                      
36                         HD.BLG_PRVDR_NPI AS BPROVNPI,                        
37                         HD.TAX_ID_NBR AS BPROVTIN,                           
38                         HD.BLG_PRVDR_ST_CD AS BPROVST,                       
39                         HD.BLG_PRVDR_ZIP_CD AS BPROVZIP,                     
40                         HD.BLG_PRVDR_ADDR1 AS BPROVADD1,                     
41                         HD.BLG_PRVDR_ADDR2 AS BPROVADD2,                     
42                         LN.DRVD_RNDRG_PRV_NPI AS RPROVDVDNPI,                
43                         LN.REND_PROVIDER AS RPROVNBR,                        
44                         LN.RNDRG_PRVDR_NPI AS RPROVNPI,                      
45                         LN.RNDRG_PRV_FST_NAME AS RPROVFNAME,                 
46                         LN.RNDRG_PRV_LST_NAME AS RPROVLNAME,                 
47                         HD.PAY_TO_IND AS PAYTOIND,                           
48                         HD.OHI_SUSPCTD_IND AS OHIIND,                        
49                         HD.OHI_ALLWD_AMT AS OHIALWDAMT,                      
50                         HD.TPL_ALLOW_AMT AS TPLALWDAMT,                      
51                         HD.CHK_NUMBER AS CHECKNUM,                           
52                         HD.CHK_NUMBER_2 AS CHECKNUM2,                        
53                         HD.CLM_ADJ_ID AS CLMADJID,                           
54                         HD.CLM_BASE_ID AS CLMBASEID                          
55                       FROM                                                   
56                        PIWD.&LN LN                                           
57                             INNER JOIN                                       
58                        PIWD.&HDR  HD                                         
59                       ON                                                     
60                      (LN.CLM_BASE_ID=HD.CLM_BASE_ID AND                      
61                       LN.CLM_ADJ_ID=HD.CLM_ADJ_ID AND                        
62                       LN.CLM_TRANS_TYP=HD.CLM_TRANS_TYP                      
63                       AND LN.CHAP_CLM_SUB_NO=HD.CHAP_CLM_SUB_NO)             
64                      WHERE                                                   
65                   (LN.CLM_BGN_SRVC_DT BETWEEN &STARTDT AND &ENDDT));         
66                                                                              
67                  %PUT &SQLXMSG &SQLXRC;                                      
3                                                          THE SAS SYSTEM       
                                                                                
68                  %MEND EXTRACT;                                              
69                                                                              
70           %EXTRACT(NINST11A, NINST_CLM_HDR,                                  
71             NINST_CLM_LN,'2011-04-01','2011-06-30');                         
NOTE: EOV MACRO WAS NOT ABLE TO OBTAIN AN ADDITIONAL EXTENT FOR LIBRARY DATA SET
      NUMBER 1. SYSTEM RC = 00000B37; REASON CODE = 00000004.                   
ERROR: WRITE TO WORK.NINST11ADATA.DATA FAILED. FILE IS FULL AND MAY BE DAMAGED. 
ERROR: WRITE TO WORK.NINST11ADATA.DATA FAILED. FILE IS FULL AND MAY BE DAMAGED. 
ERROR: WRITE TO WORK.NINST11ADATA.DATA FAILED. FILE IS FULL AND MAY BE DAMAGED. 
                                                                                
NOTE: PROC SQL SET OPTION NOEXEC AND WILL CONTINUE TO CHECK THE SYNTAX OF STATEM
0                                                                               
72           %EXTRACT(NINST11B, NINST_CLM_HDR,                                  
73             NINST_CLM_LN, '2011-07-01', '2011-12-31');                       
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.            
NOTE: SAS SET OPTION OBS=0 AND WILL CONTINUE TO CHECK STATEMENTS. THIS MAY CAUSE
NOTE: THE PROCEDURE SQL USED 405.28 CPU SECONDS AND 16130K.                     
                                                                                
Super User
Posts: 10,623

Re: ERROR: WRITE TO WORK.NINST11ADATA.DATA FAILED. FILE IS FULL AND MAY BE DAMAGED. (shorten months?

You ran out of disk space in WORK. Either have more allocated, or do some housekeeping before that step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 61 views
  • 0 likes
  • 2 in conversation