topic Close a file in data set in SAS Programming

Close a file in data set

Arjumand — Tue, 09 Feb 2016 09:33:12 GMT

Hi, I have the following code in which a file is open in write mode.

filename write "&batchfiledir\&batchname.sas";                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
data _null_;                                                                                                                                                                                                                                                    
file write;                                                                                                                                                                                                                                                     
set _BatchfileData_ end=eof;                                                                                                                                                                                                                                    
length incstmnt $ 1000;                                                                                                                                                                                                                                         
                                                                                                                                                                                                                                                                
if _n_=1 and lengthn(trim("&desc"))>0                                                                                                                                                                                                                           
  then put '/* Batch description: ' "&desc" ' */' /;                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
incstmnt=cats("&tmpprotpath\", files);                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                
info=symget("mapunixdir_info");                                                                                                                                                                                                                                 
getunixdir=strip(scan(info,1,":"));                                                                                                                                                                                                                             
getwindir=strip(scan(info,2,":"));                                                                                                                                                                                                                              
incstmnt=tranwrd(incstmnt ,trim(getwindir),trim(getunixdir));                                                                                                                                                                                                   
incstmnt=translate(incstmnt,'/','\');                                                                                                                                                                                                                           
                                                                                                                                                                                                                                                                
  incstmnt=catt('%include "', incstmnt , '";' );                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
  put incstmnt ;                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
run;

I am getting I/O error since this file is open in write mode and is not closed. Please suggest on ways to close this file.

Betreff: Close a file in data set

andreas_lds — Tue, 09 Feb 2016 13:02:52 GMT

Adding

filename write clear;

after run-statement should solve the issue.

You may want to add another period in your first filename-statement to create a properly named file:

filename write "&batchfiledir\&batchname..sas";

The first period is the separator between macro variable an following text and automatically ommitted.

Re: Close a file in data set

ballardw — Tue, 09 Feb 2016 15:18:04 GMT

When you receive an error it is very helpfule to post the log and the entire text of the error message.

By any chance do you have any calls to the FOPEN function in your program elsewhere from the code you posted?