Shmuel, 1) In most of your input records height=17, age=45 - are the same.     By using MERGE - those rows will output in one MALE record and one FEMALE record.     Is this your intention? Yes 2) Data THREE has same variables names like data ONE: alias, city, zipcode     that means that by MERGE data will overide and you will get last observation data.     Is that what you want? No   Does each observation represent one person?  yes Sir. Do height, age and gender make it unique equivalent to an ID ? No, but that's all I have to mess with.                    Thank you for your response. Yes, you are right, I am getting the repeated observations from last observation.I used this code below. How can I have just same number of observations and missing values for other repeating values of the last observation (which I don't want). Is there any other like proc sql gets me what I want. Please advise. Thanks for responding.    data one; input height age weight2 gender2$ alias2$ city2$ zipcode2$ store$; cards; 17 45 25 ganges fakenote wilming 584157 walmart ; run; data two; input height age weight1 gender$ date mmddyy10. alias1$ city1$ zipcode1$; cards; 17 45 247.96 male 07/21/2017 john1 richmond 12546 17 45 283.13 female 06/15/2017 cindy1 siouxcit 45104 ; run; data three; input height age weight gender$ alias$ city$ zipcode$; cards; 17 45 45.5 male john richmond 12546 17 45 56.48 male shawn Newyork 40534 17 45 57.78 female cindy siouxcit 45104 17 45 45.21 female crawford chicago 15483 17 45 47.14 male jason brooking 57006 17 45 94.18 female gita villa 58461 17 45 98.84 male johnson volga 15581 17 45 85.96 female smita raymond 48634 ; run; data four; input name$ title$ earning dollar7. date mmddyy10.; cards; Kum&go Manager $65,000 07/29/2017 ; run; proc sort data=three out=three1(rename=(gender=gender1)) ; by height age gender; run; proc sort data=two out=two2; by height age gender; run; data two_concat; merge two2 three1; by height age ; run; proc sort data=two_concat out=two_concat1; by height age; run; data concat; merge one two_concat1; by height age; run;   ... View more

sorry I messed up with dataset names ... View more

my sincerely apologies to all of you who responded. I was out and just checked the messages.  proc sort data=one out=one1; by height age gender; run; proc sort data=two out=two2; by height age gender; run; data two_concat; merge two2 one1; by height age gender; run; proc sort data=two_concat out=two_concat1; by height age; run; data concat; merge three two_concat1; by height age; run;     the last dataset is just a dataset I have to add as information sake. But when i tried to merge with other three datasets, I was not able to do it. Then the question came, how to merge it. I heard we can make indexes and them together. But never worked on it.                The criteria is to make a single dataset that contains all the observations concatenated. When I run my code I am getting repeated values (the values that are less than the most observations dataset). How can I avoid that to begin with and as i progress along with this I would ask more questions.  Thanks all for your help          ... View more

Reeza, How can I merge two datasets when there is no common variables? I have merged 3 datasets that have common variables, but stuck with the last part?  ... View more

Reeza,           I need help with the dataset creation in sas then writing code to export the dataset using data _null_ statement (using file statement).  thanks for asking ... View more

Thanks for prompt reply. I want to import the exported file to match the old one with little code difference, but I wouldn't be able to do it. both data want and have work alright.    Thanks again ... View more

I am adding _sequence number to station field (based on date ) like 1/26/2009 date will have B-123_1 & 3/23/2009 will have B-123_2.  once I have it like this transformation of data, I need to export data. I have very large data but submitting small set.  Thanks ... View more