topic Merging and creating variables in SAS Procedures

Merging and creating variables

brophymj — Mon, 16 Feb 2015 19:17:16 GMT

IS it possible to merge and then do other procedures like creating variables etc.

data help;

merge data1(in=a) data 2;

by key;

if a;

newfield=field1+field2;

run;

not working for me

Re: Merging and creating variables

gergely_batho — Mon, 16 Feb 2015 20:28:06 GMT

data 2

^------------- You have a whites pace here!!

data data1(keep=key field1) data2(keep=key field2);

input key field1 field2;

datalines;

1 1 0

2 2 0

3 3 1

4 4 0

5 5 0

;

run;

data help;

merge data1(in=a) data2;

by key;

if a;

newfield=field1+field2;

run;