I have a table “A” with details like subscriber_no, name, age, occupation Eg of one of the records : Adam, 35, Data Analyst And table “B” with similar info subscriber_no, name, age, occupation  and AN EXTRA COLUMN named CITY Eg: Adam, 30, Director, Toronto Ella, 40, Manager, Vancouver   I want the info in the final merged table as : if the subscriber_no exists in table A, take all the information for that subscriber from table A and just add the CITY : Toronto to it say, Name : Adam, 35, Data Analyst, Toronto   I do not want the info from B at all EXCEPT adding CITY if the subscriber no exists in A. However, if the subscriber no does not exist in A then I want all information about it from B   So the final tbale should look like: Adam, 35, Data Analyst, Toronto Ella, 40, Manager, Vancouver   How can I achieve this? Thanks in advance:) ... View more

Hi Everyone,   I need some help to automate my excel work: I will explain what I do currently..   SAS CODE(run as a trigger run) SAS code which generates a table which I export in Excel(lets call it Data Sheet). This has numbers for Prior month and current month to date(by date) for revenue.   EXCEL WORK: Excel workbook Report has sheets Sheet1 and Dsiplay1 I copy and paste data from Data Sheet and paste it in Sheet1. Excel sheet Display1 has formulas which take data from Sheet1. I convert Display1 excel sheet as pdf and send it via email. Once the data comes in for a day’s revenue, I have to freeze it which means I manually copy and paste the data for that day as a value in my excel(Display1 Sheet)…Numbers for Prior days will change when pulled on future date but we want to see the number as it first appeared on that day… Eg, when I do a pull on 8th july, I get the below numbers: 01Jul2018 90 02Jul2018 123 03Jul2018 256 04Jul2018 123 05Jul2018 256 06Jul2018 548 07Jul2018 567 08Jul2018 400 Now when I do a pull on 9th July I might get : 01Jul2018 100 02Jul2018 150 03Jul2018 200 04Jul2018 250 05Jul2018 300 06Jul2018 350 07Jul2018 400 08Jul2018 450  But in my report, I do want to see 7th July as it was pulled on 8th (567) not 400 and so forth for the coming days…   My current code runs through a trigger run everyday at 5am , so when I come to office I have the data ready and do the Excel work..What I want to do is to automate the excel work as well so I do not have to work on it everyday..the mail automatically gets out!   If this isn't the right spot for such a question, please direct me to the appropriate forum.   Thanks a lot!! 🙂 ... View more