topic Re: Merging Data Sets in SAS Programming

Merging Data Sets

harveysarah0 — Tue, 25 Feb 2020 20:08:46 GMT

I am trying to merge 2 data sets: ribs and shrimp. I am getting this error message.

Re: Merging Data Sets

PaigeMiller — Tue, 25 Feb 2020 20:10:08 GMT

Many of us will not download attachments. Please just include the code and the error in your message.

Re: Merging Data Sets

harveysarah0 — Tue, 25 Feb 2020 20:13:32 GMT

DATA New-Dataset-Name (OPTIONS);
    MERGE Dataset-Name-1 (OPTIONS) Dataset-Name-2 (OPTIONS);
    BY Variable(s);
RUN;

ERROR: Tables with 0 columns are not supported by this object. Work.BBQ cannot be opened. Do you want to select a different table to open?

Re: Merging Data Sets

PaigeMiller — Tue, 25 Feb 2020 20:27:15 GMT

@harveysarah0 wrote:

DATA New-Dataset-Name (OPTIONS);
    MERGE Dataset-Name-1 (OPTIONS) Dataset-Name-2 (OPTIONS);
    BY Variable(s);
RUN;

This is not your actual code. We need to see the actual code that you ran which produced the error message.

Re: Merging Data Sets

Reeza — Tue, 25 Feb 2020 20:53:22 GMT

It means one of your data sets is empty so it cannot be merged. My guess is you have an error in your process earlier at some point that was missed somehow.

Re: Merging Data Sets

harveysarah0 — Tue, 25 Feb 2020 21:08:10 GMT

data shrimp;
input City :$20. State :$3. Shrimp :$3.;
cards;
Baltimore MD Yes
Brooklyn NY No
Buffalo NY Yes
Harlem NY No
Newark NJ Yes
Rochester NY Yes
Stamford CT Yes
Syracuse NY Yes
Troy NY Yes
;
data ribs;
input City :$15. State :$2. Price;
cards;
Baltimore MD 10.95
Brooklyn NY 12.99
Buffalo NY 11.50
Harlem NY 12.50
Newark NJ 11.50
Rochester NY 10.95
Stamford CT 11.50
Syracuse NY 10.95
Troy NY 11.50
;
DATA BBQ Ribs (OPTIONS);
MERGE Ribs-1 (OPTIONS) Shrimp-2 (OPTIONS);
BY Variable(s);
RUN;

Re: Merging Data Sets

harveysarah0 — Tue, 25 Feb 2020 21:24:29 GMT

Re: Merging Data Sets

Astounding — Tue, 25 Feb 2020 21:42:01 GMT

You have program pieces that are entirely illegal.

(OPTIONS)

Cannot be part of a DATA step.

Ribs-1

Shrimp-2

These are not the names of your data sets, nor would they be legal as data set names if you attempted to create them.

Variable(s)

You have to actually name the variables, not imagine that SAS can figure out the right variable names.

This would be along the right lines:

DATA BBQ_Ribs;
MERGE Ribs Shrimp;
BY City State;
RUN;

Re: Merging Data Sets

Reeza — Tue, 25 Feb 2020 22:37:09 GMT

Here's a tutorial on merging data, it covers your use case.

https://stats.idre.ucla.edu/sas/modules/match-merging-data-files-in-sas/