topic Re: output for merge in SAS Programming

output for merge

alexdsa310 — Fri, 10 Mar 2017 12:52:18 GMT

I want to create seperate outputs for if statement after merge

data final;
merge i301_302(in=a) inc1(in=b);
if a and not b then output i3012;
if b and not a then output i303;
by UPTID;
run;

Unfortunately this is not working. Can anyone help me if my datastep is wrong

Re: output for merge

Astounding — Fri, 10 Mar 2017 12:58:37 GMT

This statement is wrong:

data final;

This tells SAS to create a data set named FINAL. Later, you try to output observations into data sets that don't exist: i3012 and i303. The OUTPUT statements must reference data set names that appear on the DATA statement. Most likely you need to change to:

data i3012 i303;

Also note, your logic will not observations that match. For any UPTID values that appear in both data sets, they do not get output at all.

Re: output for merge

Kurt_Bremser — Fri, 10 Mar 2017 12:58:58 GMT

Read the log, it says it all:

ERROR 455-185: Data set was not specified on the DATA statement.

You can only output to datasets that have been specified in the data statement.