Appending

Add the data from one dataset to another existed dataset
data dm1;
input sno $ gno $ id age sex $;
cards;
s1 g1 101 23 m
s1 g1 102 22 f
s1 g1 103 32 m
s1 g1 104 25 f
;

data dm2;
input sno $ gno $ id age sex $;
cards;
s2 g2 201 24 f
s2 g2 202 25 m
s2 g2 203 26 m
s2 g2 204 27 f
;

proc append base=dm1data=dm2;
run;

proc print data=dm2;
run;

/*data set exist with less variables when compared masterset*/
data dm3;
input sno $ gno $ id age ;
cards;
s3 g3 301 22
s3 g3 302 24
s3 g3 303 27
s3 g3 304 29
;
proc append base=dm1 data=dm3;
run;
proc print data=dm1;
run;

/*master dataset contain less variables*/
data dm4;
input sno $ gno $ id age sex $ race $;
cards;
s4 g4 401 23 m as
s4 g4 402 22 f af
s4 g4 403 25 m am
s4 g4 404 26 m as
;

/*error no appending takes place*/
proc append base=dm1 data=dm4;
run;

/*force*/
proc append base=dm1 data=dm4 force;
run;
proc print data=dm1;
run;

/*drop*/
proc append base=dm1 data=dm4 (drop=race);
run;
proc print data=dm1;
run;

/*reformat*/
data dm5;
input sno $ gno $ id age sex;
cards;
s5 g5 501 23 1
s5 g5 502 34 2
s5 g5 503 25 1
s5 g5 504 24 2
;

/*taransformation for reformat*/
data dm6;
set dm5;
length s $ 8 ;
if sex=1 then s='m';
else s='f';
drop sex;
rename s=sex;
run;
proc append base=dm1 data=dm6;
run;
proc print data=dm1;
run;

/*append procedure with out data option*/
data emp2;
input id des $;
cards;
201 analyst
202 tester
;
proc append base=emp1;
run;

/*append procedure without 'base'option*/
data employ1;
input bcode $ eid $ des $;
cards;
b1 e01 tester
b1 e02 programer
b1 e03 analyst
;
data employ2;
input bcode $ eid $ des $;
cards;
b2 e21 tester
b2 e22 programer
b2 e23 analyst
;
data employ3;
input bcode $ eid $ des $;
cards;
b3 e31 tester
b3 e32 programer
b3 e33 analyst
;
data employs;
set employ1 employ2 employ3;
run;
proc print data=employs;
run;
proc sort data=employs;
by des;
run;
proc print data=employs;
run;