Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Note:   Although your operating environment utilities may recognize partial physical filenames, you must always use fully qualified physical filenames with FILEEXIST.

This example verifies the existence of an external file. If the file exists, read in the file using INFILE and INPUT statements. If the file does not exist, display a message in the SAS log that states the file does not exist.

Note that in a macro statement you do not enclose character strings in quotation marks.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

/* If the file passed to the macro does exist, read in the file and create     */
/* a character variable called VAR with a default length of 8 bytes.  If       */
/* file named in the macro call does not exist, write "FILE DOES NOT EXIST..." */
/* to the log.                                                                 */

%macro in_file(file);
  %if %sysfunc(fileexist(&file))=1 %then %do;
    data a;
      infile "&file";
      input var $;
    run;
  %end;
  %else %do;
    data _null_;
      put "FILE DOES NOT EXIST:  &file";
    run;
  %end;
%mend;

/* Call the macro with file that does not exist */
%in_file(c:\bloom.txt);


/* Call the macro with file that does exist */
%in_file(c:\tracks\x1.txt);

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

LOG when file does not exist 

FILE DOES NOT EXIST:  c:\bloom.txt


LOG when the file does exist ...typical notes seen when a file is read 

NOTE: The infile "c:\tracks\x1.txt" is:
      File Name=c:\tracks\x1.txt,
      RECFM=V,LRECL=256

NOTE: 2 records were read from the infile "c:\tracks\x1.txt".
      The minimum record length was 14.
      The maximum record length was 20.
NOTE: The data set WORK.A has 2 observations and 1 variables.

Operating System and Release Information