BookmarkSubscribeRSS Feed
caroline_rg
Fluorite | Level 6

Hi, 

 

I have CSV files for all my data. For one of them, I am missing some data from one experimental unit (the sample was damaged, not all the work was able to be completed on it). 

 

What should I put so SAS will know to not include that sample in the analysis? It's not 0, it just doesn't exist. 

 

Thank you!

Caroline 

1 REPLY 1
Patrick
Opal | Level 21

SAS function FILEEXIST() allows to verify for the existence of an external file by its physical name.

Here some sample code:

%let myfile=C:\temp\test folder\testfile1.txt;
%if %sysfunc(fileexist(&myfile)) %then 
  %do;
    data _null_;
      put "file exists: &myfile";
    run;
  %end;
%else
  %do;
    data _null_;
      put "file does not exist: &myfile";
    run;
  %end;

We would need to see your actual code to give you more targeted advice for you specific code.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 296 views
  • 0 likes
  • 2 in conversation