topic Re: Read excel files and add a column from one to the other in SAS Programming

Read excel files and add a column from one to the other

KyleOB — Wed, 05 Apr 2023 01:14:32 GMT

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.

Re: Read excel files and add a column from one to the other

AhmedAl_Attar — Wed, 05 Apr 2023 13:12:38 GMT

Hi @KyleOB ,

Have a look at this blog Using LIBNAME XLSX to read and write Excel files

It should give a starting point

Hope this helps

Re: Read excel files and add a column from one to the other

Tom — Wed, 05 Apr 2023 13:39:54 GMT

I have no idea how to do it in DIS, but the concept is simple.

1) Convert each Excel file into actual SAS datasets so they are useful as data.

2) Merge the two datasets using the common variable CUSTOMER_ID to create a new third dataset.

3) If want to share the data for someone to look at then you can make a report. It could be PDF file. Or you could write the data back into an Excel file.