output for merge

[alexdsa310]

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

[Astounding · Accepted solution]

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.

[Kurt_Bremser]

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.