how to chain datasets with same name and variables structure

[PierreYvesILY]

Hello SAS experts,

I have a list of datasets with the same name and variables structure, and I want to add them all in a single one.

this doesn't work:

data vzk_2020;

do i=1 to 8;

set vzk_2020_i;

end;

run;

what's the correct way?

regards,

PY

[Kurt_Bremser · Accepted solution]

This is where you need a macro. You need one SET statement, but multiple datasets in it.

%macro dsnames;
%do i = 1 %to 8;
  vzk_2020_&i.
%end;
%mend;

data vzk_2020;
set
  %dsnames
;
run;

Take note where I placed semicolons, and where I omitted them.

[PierreYvesILY]

thank you Kurt, have a nice day!

[Ksharp]

data vzk_2020;
set vzk_2020_1 - vzk_2020_8 ;
run;

OR Just:
data vzk_2020;
set vzk_2020_: ;
run;