I will be importing an excel file using proc import. The excel file is updated every month with a new tab for that month. (Ex: "06-16" as the tab name). Is there a way to only import the tab that has the current month as the tab name?
Thanks in advance!
Or go down the correct route, build a data transfer agreement which both the sender and you agree to which details what data should be sent, what the strcuture of the data should be, also wether is will be cumulative or incremental, and fix the data transfer type using a proper data transfer file format - CSV, XML dataset etc. That way you can write a simple datastep import to properly process the data into a useable format according to a documented process, and it is reproduceable. Using Excel and proc import is the bigget method to failure and the reason why we see so many questions on here about messy data - it hasn't been processed correctly in the first place.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.