topic Re: How to determine the output file location via file statement? in SAS Programming

How to determine the output file location via file statement?

Babloo — Mon, 15 Oct 2018 06:15:59 GMT

Could someone of you help me to know how can I find the output file (outfr14a,outfr14b,outfr14) location from the following code?

if agi ne agi_v           
    then do;                
      knkbty = '1';         
      knkatv = '' ;         
      knkath = '' ;         
      agiteg = agi;         
      link schrijfv;        
                            
      knkbty = '2';         
      knkatv = '' ;         
      knkath = '' ;         
      agiteg = agi_v;       
      link schrijfh;        
                        end;                                 
    end;                                     
                                             
return;                                      
schrijfh:                                    
  *schrijf weg met huidige gegevens;         
     p2kbrn='7';                             
  if substr(khiref,1,1)  = '1' then do;      
  file outfr14a noprint notitles;            
  link fr14outh;                             
  end;                                       
  if substr(khiref,1,1)  = '2' then do;      
  file outfr14b noprint notitles;            
  link fr14outh;                             
  end;                                       
  else if substr(khiref,1,1)  = '0' then do; 
  file outfr14 noprint notitles;             
  link fr14outh;                             
  end;                                       
          return;                                      
                                             
return;                                      
schrijfv:                                    
  p2kbrn='7';                                
  if substr(khiref,1,1)  = '1' then do;      
  file outfr14a noprint notitles;            
  link fr14outv;                             
  end;                                       
  else if substr(khiref,1,1)  = '2' then do; 
  file outfr14b noprint notitles;            
  link fr14outv;                             
  end;                                       
  else if substr(khiref,1,1)  = '0' then do; 
  file outfr14 noprint notitles;             
  link fr14outv;                             
  end;                                       
  * schrijf weg met huidige gegevens ;       
return;                                      

return;

Re: How to determine the output file location via file statement?

SASKiwi — Mon, 15 Oct 2018 06:26:38 GMT

That is impossible from just the code you have provided. outfr14a,outfr14b,outfr14 are file references that have been defined somewhere else, perhaps in a FILENAME statement. Start by looking through the rest of your program for other statements that use those references.

Re: How to determine the output file location via file statement?

Oligolas — Mon, 15 Oct 2018 06:35:34 GMT

Hi, if filename have been defined you can use pathname()

%let outfr14aLoc = %sysfunc(pathname(outfr14a));

%let outfr14bLoc = %sysfunc(pathname(outfr14b));

%let outfr14Loc = %sysfunc(pathname(outfr14));

Re: How to determine the output file location via file statement?

SASKiwi — Mon, 15 Oct 2018 06:37:01 GMT

@Oligolas - I stand corrected...

Re: How to determine the output file location via file statement?

Oligolas — Mon, 15 Oct 2018 06:56:54 GMT

and if not.. I presume it will Output a dat file into the Default Output Location defined in SAS. But I haven't found a way to identify it during a SAS session:

Re: How to determine the output file location via file statement?

Amir — Mon, 15 Oct 2018 09:32:52 GMT

Hi,

Am I missing something, or could this information be found in the log?

Regards,

Amir.

Re: How to determine the output file location via file statement?

FreelanceReinh — Mon, 15 Oct 2018 10:03:46 GMT

@Oligolas wrote:

I presume it will Output a dat file into the Default Output Location defined in SAS. But I haven't found a way to identify it during a SAS session:

The path of this so called "current working directory" (not to be confused with the WORK library) can be found as follows (at least on Windows systems):

filename dummy '.'; 
%put %sysfunc(pathname(dummy));

Re: How to determine the output file location via file statement?

Oligolas — Tue, 16 Oct 2018 06:43:11 GMT

@FreelanceReinhard Excellent thank you very much 🙂

Re: How to determine the output file location via file statement?

andreas_lds — Tue, 16 Oct 2018 07:15:17 GMT

@Amir wrote:

Hi,

Am I missing something, or could this information be found in the log?

Regards,

Amir.

To simple 😉