topic Re: Concatenate multiple databases in SAS Programming

Concatenate multiple databases

Roxanne1 — Fri, 04 Feb 2022 13:59:11 GMT

Hello,

I'm wondering if there is a way to concatenate multiple databases together without having to write them all. I have a lot of databases that are the same but with information on the last ten years.

INFO_2021

INFO_2020

INFO_2019

...

INFO_2012

And I want to put them all together in one database, one year after the other. Here is what I did:

DATA INFO_TOT;

SET INFO_2012 INFO_2013 INFO_2014 INFO_2015 INFO_2016 INFO_2017 INFO_2018 INFO_2019 INFO_2020 INFO_2021;

RUN;

I was wondering if there is a more efficient way maybe with a loop? Something that I could do

DATA INFO_TOT;

SET INFO_2012 TO INFO_2021;

RUN;

Re: Concatenate multiple databases

CarmineVerrell — Fri, 04 Feb 2022 14:05:33 GMT

Here is an sample data an coding example.

Data info_2012;
a=1;
output;
a=2;
output;
run;
Data info_2013;
a=3;
output;
a=4;
output;
run;
Data info_2014;
a=5;
output;
a=6;
output;
run;
DATA INFO_TOT;

SET INFO_2012-INFO_2014 ;

RUN;

Re: Concatenate multiple databases

Roxanne1 — Fri, 04 Feb 2022 15:11:08 GMT

Thanks!