Can there some functions or some keywords be converted into Macro only? Please advise me. Regards, Clouds in Sky! ... View more

Thanks for the response. Then we can convert anything, any word, any statement or any function in SAS by placing percentage sign before it. Please advise me. CloudsIntheSky ... View more

Thanks for the response. Are %lowcase, %if or %then or %put SAS automated macros? CloudsIntheSky ... View more

Your response helped me a lot. Thanks for it. Respectfully, Guity ... View more

Hello ballardw, Thanks for the response. 1- Can we say that merge is like a inner join? 2- I want all the variables from the left data set and all the variables from right data set together in one table? one dataset has 5 observation and the other dataset has 9 observation (I tried to explain it to the best that I can). 3- Instead of merge, I placed set, the code ran successfully. Why doesn't merge work? 4- On my previous post, I sent what each dataset has and I want to merge these two data sets regardless which dataset comes first. The key to merge is Acc_Number only.   Please advise me.   Regards, Blue Sky     ... View more

Your answer is the best so far. Someone else also pointed out at this. My code was fixed. Now I want to merge the data sets, I can't get the result I am supposed to have:   PROC IMPORT OUT=Balance_Bank1 DataFile = "/home/nguityn0/Balance_Bank.xlsx" dbms=xlsx REPLACE; Sheet="Sheet1"; getnames=YES; RUN; /*Getnames is not about getting or not getting headers. It is about deciding if you want the variable names from the dataset or just random one*/ /*INPUT should be placed before Merge/ set statement.*/ Proc Sort Data=Balance_Bank1 OUT=Balance_Bank1Sorted; BY Acc_number; RUN; PROC IMPORT OUT=Balance_Bank2 DataFile = "/home/nguityn0/Balance_Bank.xlsx" dbms=xlsx REPLACE; Sheet="Sheet2"; getnames=YES; Run; Proc Sort Data=Balance_Bank2 OUT=Balance_Bank2Sorted; BY Acc_number; RUN; Data NewCollection; MERGE Balance_Bank1Sorted Balance_Bank2Sorted; BY Acc_Number; RUN; It is Excel sheet and It is not a text file. These are the variables for each sheet: Sheet1: Alphabetic List of Variables and Attributes # Variable Type Len Format Label 4 Acc_Number Num 8 BEST. Acc_Number 3 Credit Num 8 BEST. Credit 1 Date Num 8 MMDDYY10. Date 2 Debit Num 8 BEST. Debit Sheet2: Variable Type Len Format Label 1 Acc_Number Num 8 BEST. Acc_Number 4 Credit Num 8 BEST. Credit 2 Date Num 8 MMDDYY10. Date 3 Debit Num 8 BEST. Debit I want to merge these two data sets and I don't get the result that it is supposed to be: Data NewCollection; MERGE Balance_Bank1Sorted Balance_Bank2Sorted; BY Acc_Number; RUN; Regards, Blue Sky ... View more

Hello,   Are you saying observation orders are not important? Can I merge two data sets although the order of variables are different?   Respectfully, Blue sky ... View more

I ran your codes and this is what I got: Variable Type Len Format Label 1 Date Num 8 MMDDYY10. Date 2 Debit Num 8 BEST. Debit 3 Credit Num 8 BEST. Credit 4 Acc_Number Num 8 BEST. Acc_Number   Respectfully, Blue Sky ... View more

I have not learned the code you put here. I am a new learner and I need to stick to the codes that the instructor is teaching us. Regards, Blue Sky ... View more

I changed the GETName = Yes. It doesn't give me the order that I want. Yes, I have four varialbes: Acc_Number Date Debit Credit and 5 observations. Regards, Blue Skey ... View more

I posted the code and the log. Thanks for the response. Blue Sky ... View more

Hello ballardw, Thanks for the response. It is interesting to know these codes. The first one gave me an error and I am not able to fix it. The second one created a data set which is different than mine. I use merge to append the data sets and I think the order of variable are important. The data type is not important because I heard that SAS accepts mixed data types in one variable. I posted my code and my log any way. The code doesn't arrange the variables on the order that I need for merging. I might get a job to write SAS programming. It has been for two days that I am trying to merge to data sets and even my proc sort doesn't sort properly. I told them that I don't have any experience and I am working on it. If if is going to be this hard and challenging, I am going to let this job go. Regards, Blue Sky ... View more

Hello PaigeMiller,   Variables are columns or fields and observations are rows. I need to change the order of variables.   Respectfully, Blue Sky ... View more