Coniditional Execution of data step 1

[bkclaw113]

Is there a way to check for the existance of a required dataset and have two branches of code to handle:
a: Input Dataset exist
b: Input Dataset does not exist

A general outline of what I am trying to do is this:

%let fileIn = "c:\temp\filename.txt";

%if FILEEXISTS(fileIN) %then %do;
[COLOR=green]	/* Code segment 1	*/
	/* DATA STEP 1a		*/
	/* Data STEP 2a		*/ [/color]
%else %do;
[COLOR=green]	/* Code segment 2	*/
	/* DATA STEP 1b		*/
	/* DATA STEP 2b		*/ [/color]
%end;

 

[bkclaw113]

I guess that my instincts were closer than I thought. the only thing that I was missing was %sysfunc.

 %if %sysfunc(fileexist(&fileref)) %then %do;

 

[ChrisW75]

Nice one! Thanks for posting the answer! Here, have a purple star. That looks like a very useful setup, I'll have to make a note of it. Cheers.