topic Re: Create final dataset even if one of the source dataset don't exists in SAS Programming

Create final dataset even if one of the source dataset don't exists

David_Billa — Tue, 19 Nov 2019 11:46:25 GMT

I want to create WANT dataset as mentioned below although if one of source dataset don't exist. I tried the code below but it is not working. In real life HAVE1 dataset exist for sure with some data but HAVE2 dataset will not exist all the time. HAVE1 and HAVE2 dataset will be in same structure.

So I want to dynamically write one code similar to the one mentioned below to create WANT dataset.

data have1;
	id=1;
	output;
run;

/*create dataset want even if have2 dataset don't exist*/
data want;
	set have1 have2;
run;

log:

26         data have1;
27         id=1;
28         output;
29         run;

NOTE: Compression was disabled for data set WORK.HAVE1 because compression overhead would increase the size of the data set.
NOTE: The data set WORK.HAVE1 has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

30         
31         /*create dataset want even if have2 dataset don't exist*/
32         
33         data want;
34         set have1 have2;
ERROR: File WORK.HAVE2.DATA does not exist.
35         run;

Re: Create final dataset even if one of the source dataset don't exists

PeterClemmensen — Tue, 19 Nov 2019 12:01:57 GMT

See this thread

https://communities.sas.com/t5/SAS-Procedures/Include-dataset-in-SET-statement-only-if-it-exists/td-p/391725

Re: Create final dataset even if one of the source dataset don't exists

yabwon — Tue, 19 Nov 2019 12:02:07 GMT

Hi,

If you have common prefix you could try:

data want;
  set have: ;
run;

all the best

Bart

Re: Create final dataset even if one of the source dataset don't exists

yabwon — Tue, 19 Nov 2019 12:21:16 GMT

Or if the list is "twisted", then you can do it like that:

data _null_;
  call execute('data want; set ');

  length set $ 41; drop set;
  do until (set = " ");
    i+1;
  	set = scan("have1 have2 ABC something.else", i);
    if exist(set) then call execute(set);
  end;
  call execute('; run;');

  stop;
run;

All the best

Bart

Re: Create final dataset even if one of the source dataset don't exists

David_Billa — Tue, 19 Nov 2019 12:54:27 GMT

So can't we accomplish this task without querying the metadata?

Re: Create final dataset even if one of the source dataset don't exists

Kurt_Bremser — Tue, 19 Nov 2019 13:02:07 GMT

The simple method is this

data want;
set
  have1
%if %sysfunc(exist(have2)) %then %do;
  have2
%end;
;
run;

Re: Create final dataset even if one of the source dataset don't exists

yabwon — Tue, 19 Nov 2019 13:09:54 GMT

Hi,

I think both, my and @Kurt_Bremser's, solutions are quite "without querying the metadata"-ish

All the best

Bart

Re: Create final dataset even if one of the source dataset don't exists

yabwon — Tue, 19 Nov 2019 13:25:39 GMT

Hi,

one more would be:

data have1;
	id=1;
	output;
run;

options NODSNFERR;

data want;
    set have1 have2;
run;

options DSNFERR;

All the best

Bart