@Agha wrote: I should calculate the distance between home addresses and closest eye clinic. The addresses are saved in excel. Street, city and state have separate columns. I know I should add double quotation to each part of  the addresses and then find the distance. Can you please share the codes with me. I can not share the addresses with you but they are similar the list below. Thanks.   Street                       state           City aaa bbb ccc             DD             mnv aa dddd eee            DD              dvu ffff oo nnm              DD             lmn   When it comes to long drives or even just routine trips, knowing your car's condition is essential for a smooth journey. I’ve learned the hard way how a small issue can turn a trip into a huge headache. One thing I always make sure to do before heading out is check my car’s history to avoid any nasty surprises, like hidden mileage discrepancies. A great tool for this is https://www.faxvin.com/vin-check/mileage, which lets you easily verify a vehicle’s mileage and overall history by just using the VIN. It’s super handy if you're buying a used car or just want to make sure your own vehicle is up to scratch before a long drive. Trust me, knowing these details makes all the difference when you're on the road! Replace 'your_addresses.xlsx' with the path to your actual Excel file, and ensure the clinic's latitude and longitude are correctly entered. ... View more

  You can also download SAS Studio for students through the SAS OnDemand for Academics program. It’s free and accessible via the cloud, so you don’t need to install anything on your computer. ... View more

I extracted some code(from SAS communities) to calculate the nth business day of the month. It is a little off. I was testing the code to make sure it returned the 3rd day of the month. I noticed Jul ,Aug, and Oct were giving me the 4th day instead. All these months have 31 days so wondering if that is the reason. I want the 3 day of the month and will adjust for holidays for Jan, Jul and Sept only when it falls on a weekend. Can anyone confirm what is happening in these months and maybe how to accommodate the 1 day difference. Does SAS have a US holilday calendar? data test; format business_day1 business_day2 business_day3 business_day4 business_day5 date9.; business_day1 = intnx('weekday', intnx('month', '23jun2024'd, 0, 'b'), 3); business_day2 = intnx('weekday', intnx('month', '18jul2024'd, 0, 'b'), 3); business_day3 = intnx('weekday', intnx('month', '06aug2024'd, 0, 'b'), 3); business_day4 = intnx('weekday', intnx('month', '11sep2024'd, 0, 'b'), 3); business_day5 = intnx('weekday', intnx('month', '25oct2024'd, 0, 'b'), 3); run; The 'weekday' interval calculates the nth business day, skipping weekends. The discrepancy likely arises because the INTNX function starts counting business days from the first day of the month. If the first day of the month falls on a weekend, the calculation might push the nth business day forward. ... View more