topic Re: Check a dataset exist or not in SAS Programming

Check a dataset exist or not

R_Chung — Fri, 15 Sep 2017 03:50:06 GMT

Hi all,

I would like to check whether a dataset exist first then join the dataset with another dataset.

Below is my code:

if (exist(ot_reclus_kw_kc)) then do;
    data semi_ot_result; 
	 	set ot_reclus_kw_kc semi_ot_result; 
	 run;
end;

Is there any errors/mistakes?

Thanks.

Re: Check a dataset exist or not

Reeza — Fri, 15 Sep 2017 04:55:13 GMT

You can't execute conditional code like that in SAS.

You'll have to use macro programming and %if/%then

If you search on here or lexjansen.com you'll find a lot of examples on how to do this.

Re: Check a dataset exist or not

ballardw — Fri, 15 Sep 2017 05:20:26 GMT

Until you are very familiar with the possible errors in SAS, I suggest that you do NOT combine data sets or use the structure:

data someset;

set someset ;

as if there is an error you may corrupt or modify you dataset someset in such a way that you lose or destroy some existing data and have to recover the original version from somewhere else. I would recomend testing with

data combined;

set ot_reclus_kw_kt semi_ot_result;

run;

You may find that you want a merge or update instead of set and if you make the wrong choice ...

Re: Check a dataset exist or not

R_Chung — Fri, 15 Sep 2017 06:03:35 GMT

Is there a missing in hyperlink @Reeza

Re: Check a dataset exist or not

ShiroAmada — Fri, 15 Sep 2017 07:04:40 GMT

Try this......

Submit your code, check the sas log.

Check your DATA and SET statements. Changing the position of the tables in your SET statement will create the difference unless the tables have identical structure.

If the structure is identical then better use proc append or proc sql.

Creating a macro program like this:

%MACRO <MACRONAME>;
%if %sysfunc(exist(<DATASET_NAME>)) %then %do;
<PUT YOUR DATA STEP HERE>
%end; 
%MEND;
 
%<MACRONAME>;

Hope this helps.

Re: Check a dataset exist or not

Kurt_Bremser — Fri, 15 Sep 2017 08:17:42 GMT

@R_Chung wrote:

Hi all,

I would like to check whether a dataset exist first then join the dataset with another dataset.

Below is my code:
if (exist(ot_reclus_kw_kc)) then do;
    data semi_ot_result; 
	 	set ot_reclus_kw_kc semi_ot_result; 
	 run;
end;
Is there any errors/mistakes?

Thanks.

Yes, there are 😉

if - then - else is data step code (and some procedures also allow such syntax, eg proc report), and can't be used outside of a data step.

Also keep in mind that data or procedure steps cannot be nested.

Such problems are best solved by using the macro preprocessor.

Method 1: do the logic in a data step and save the result to a macro variable:

data _null_;
if (exist("ot_reclus_kw_kc"))
then call symput('add_file',"ot_reclus_kw_kc");
else call symput('add_file','');
run;

data semi_ot_result; 
set
  &add_file
  semi_ot_result
;
run;

Method 2: use a macro:

%macro add_file(testfile);
%if %sysfunc(exist(&testfile))
%then %do;
&testfile
%end;
%mend;

data semi_ot_result; 
set
  %add_file(ot_reclus_kw_kc)
  semi_ot_result
;
run;

As others have mentioned, rewriting a dataset in the same step can be dangerous and lead to data loss that necessitates a rerun of all previous code.

Re: Check a dataset exist or not

Reeza — Fri, 15 Sep 2017 14:43:09 GMT

@R_Chung wrote:
Is there a missing in hyperlink @Reeza

No, I assumed that google is sufficient.

Use terms "SAS macro check if data exists"

Returns:

http://support.sas.com/kb/24/670.html