ERROR: WRITE ACCESS TO MEMBER INST.DATA.DATA IS DENIED. ??

Reply
Frequent Contributor
Posts: 128

ERROR: WRITE ACCESS TO MEMBER INST.DATA.DATA IS DENIED. ??

             PROC SQL;                                                 
               CONNECT TO DB2(SSID=DBR0);                              
                 EXECUTE(SET CURRENT DEGREE='ANY') BY DB2;             
                                                     THE SAS SYSTEM    
                                                                       
                                                                       
               CREATE TABLE INST.DATA AS                               
                 SELECT * FROM CONNECTION TO DB2                       
                  (SELECT                                              
                     HD.SR_PRIME_RCD_DATE AS CLMRECDT,                 
                     LN.CLM_BGN_SRVC_DT AS CLMSVCDT,                   
                     LN.CLM_END_SRVC_DT AS CLMENDDT,                   
                     LN.SPONSOR_SSN AS SPONSORSSN,                     
                     LN.PATNT_AMMS_ID_NO AS PATIENTID,                 
                     HD.PATNT_LAST_NAME AS PTLASTNAME,                 
                     HD.PATNT_FIRST_NAME AS PTFIRSTNAME,               
                     HD.PATNT_DOB AS PTDOB,                            
                     HD.PATNT_ADDR_LN_1 AS PTADD1,                     
                     HD.PATNT_ADDR_LN_2 AS PTADD2,                     
                     HD.PATNT_CITY AS PTCITY,                          
                     HD.PATNT_STATE AS PTSTATE,                        
                     HD.PATNT_ZIP_CODE AS PTZIP,                       
                     HD.ALLOWED_CHRG AS ALLCHRG,                       
                     LN.APRVD_AMT AS APRVDAMT,                         
                     LN.PAYMENT_AMT AS PYMTAMT,                        
                     HD.BLG_PRVDR_NAME AS BPROVNAME,                   
                     HD.BLG_PRVDR_NPI AS BPROVNPI,                     

                         HD.TAX_ID_NBR AS BPROVTIN,                          
                         HD.BLG_PRVDR_ST_CD AS BPROVST,                      
                         HD.BLG_PRVDR_ZIP_CD AS BPROVZIP,                    
                         HD.BLG_PRVDR_ADDR1 AS BPROVADD1,                    
                         HD.BLG_PRVDR_ADDR2 AS BPROVADD2,                    
                         LN.DRVD_RNDRG_PRV_NPI AS RPROVDVDNPI,               
                         LN.REND_PROVIDER AS RPROVNBR,                       
                         LN.RNDRG_PRVDR_NPI AS RPROVNPI,                     
                         LN.RNDRG_PRV_FST_NAME AS RPROVFNAME,                
                         LN.RNDRG_PRV_LST_NAME AS RPROVLNAME,                
                         HD.PAY_TO_IND AS PAYTOIND,                          
                         HD.OHI_SUSPCTD_IND AS OHIIND,                       
                         HD.OHI_ALLWD_AMT AS OHIALWDAMT,                     
                         HD.TPL_ALLOW_AMT AS TPLALWDAMT,                     
                         HD.CHK_NUMBER AS CHECKNUM,                          
                         HD.CHK_NUMBER_2 AS CHECKNUM2,                       
                         HD.CLM_ADJ_ID AS CLMADJID,                          
                         HD.CLM_BASE_ID AS CLMBASEID                         
                       FROM                                                  
                       PIWD.INST_CLM_LN   LN                                 
                             INNER JOIN                                      
                       PIWD.INST_CLM_HDR  HD                                 
                       ON                                                    
                      (LN.CLM_BASE_ID=HD.CLM_BASE_ID AND                     
                       LN.CLM_ADJ_ID=HD.CLM_ADJ_ID AND                       
                       LN.CLM_TRANS_TYP=HD.CLM_TRANS_TYP                     
                       AND LN.CHAP_CLM_SUB_NO=HD.CHAP_CLM_SUB_NO)            

62                      WHERE                                                   
63                   (PIWD.INST_CLM_LN.CLM_BGN_SRVC_DT BETWEEN '2011-04-01'     
64                  AND '2011-04-30'));                                         
ERROR: WRITE ACCESS TO MEMBER INST.DATA.DATA IS DENIED.                         
ERROR: WRITE ACCESS TO MEMBER INST.DATA.DATA IS DENIED.                         
ERROR: WRITE ACCESS TO MEMBER INST.DATA.DATA IS DENIED.                         
                                                                                
NOTE: PROC SQL SET OPTION NOEXEC AND WILL CONTINUE TO CHECK THE SYNTAX OF STATEM
3                                                          THE SAS SYSTEM       
                                                                                
65                                                                              
66                  %PUT &SQLXMSG &SQLXRC;                     

                

 

Super User
Posts: 13,583

Re: ERROR: WRITE ACCESS TO MEMBER INST.DATA.DATA IS DENIED. ??

Very likely you do not have write permission to either the library or that specific data set.

Ask a Question
Discussion stats
  • 1 reply
  • 32 views
  • 0 likes
  • 2 in conversation