topic Re: how to chain datasets with same name and variables structure in New SAS User

how to chain datasets with same name and variables structure

PierreYvesILY — Fri, 07 Aug 2020 10:33:25 GMT

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,

Kurt_Bremser — Fri, 07 Aug 2020 10:38:31 GMT

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 — Fri, 07 Aug 2020 10:43:22 GMT

thank you Kurt, have a nice day!

Ksharp — Fri, 07 Aug 2020 11:54:20 GMT

data vzk_2020;
set vzk_2020_1 - vzk_2020_8 ;
run;

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