The vertical and horizontal combining of data set in sas

fig: merge

types of horizontal combining

Program 1.1data work.OneToOneMM; 
merge BookData.ipums2005basic(firstobs = 3 obs = 6) work.ipums2005Utility(obs = 5);
by Serial;
run;

proc print data = work.OneToOneMM;
var serial state metro hhincome electric gas water fuel;
run
Program 1.2 one to one readingdata work. OneToOneRead;  
set BookData.ipums2005basic(firstobs = 3 obs = 6);
set work.ipums2005Utility(obs = 5);
run;
Program 1.3 one to one merge (also makes use of obs record along with common variable) <no by statement unlike match-merge >data work.OneToOneMerge;  
merge BookData.ipums2005basic(firstobs = 3 obs = 6) work.ipums2005Utility(obs = 5);
run;

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store