creating new variable during merge

[robertrao]

Hi,

How can i create new variable flag=1 in the WANT dataset?????

data want;

mergehave1(in=a) have2(in=b);

byID;

if a;

run;

Thanks

[art297 · Accepted solution]

If no conditions are involved the simplest way would be to include a retain statement:

data want;

  merge have1(in=a) have2;

  by ID;

  retain flag 1;

  if a;

run;