Hi, Excuse me for what might seem like a simple question, but as a beginner, I am not sure how to proceed with a task I have. I have two Excel files, file X, which contains customer IDs, names, and birthdays, and file Y, which has customer IDs, addresses, and phone numbers. Would you kindly guide me on how to add the phone number column and its corresponding values from file Y to file X, and output the new X as an Excel file in SAS DIS environment? The files X and Y will be updated(replaced) every week. I need to run the job every week to get new Xs with IDs, names, birthdays, and phone numbers. I would greatly appreciate your help. Thank you.
... View more