topic Merge - Same variables in all data sets in SAS Programming

Merge - Same variables in all data sets

debabrata — Tue, 25 Apr 2017 20:26:09 GMT

how to concatenate 4 datasets into 1 data set.

given the fact that merge cant be used since all data sets have same no of and same variables

will SET option work?

thomp7050 — Tue, 25 Apr 2017 17:59:25 GMT

DATA BLARG;
SET BLARG1 BLARG2 BLARG3 BLARG4;
RUN;

Alternatively:

PROC SQL;
CREATE TABLE BLARG AS
SELECT * FROM BLARG1
UNION ALL
SELECT * FROM BLARG2;
QUIT;

Reeza — Tue, 25 Apr 2017 20:26:56 GMT

The SAS docs have a great section on the various ways of combining data: