topic Re: creating new variable during merge in SAS Procedures

creating new variable during merge

robertrao — Tue, 17 Dec 2013 14:15:49 GMT

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 — Tue, 17 Dec 2013 15:06:35 GMT

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;