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-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

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
  • 339 views
  • 0 likes
  • 2 in conversation