Help using Base SAS procedures

Proc Import Excel file tab with the current month

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 83
Accepted Solution

Proc Import Excel file tab with the current month

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!


Accepted Solutions
Solution
‎06-22-2016 05:10 PM
Respected Advisor
Posts: 4,651

Re: Proc Import Excel file tab with the current month

... Or go directly for

 


proc import datafile="&sasforum\datasets\testdatetab.xlsx" out=test replace;
sheet="%sysfunc(putn(%sysfunc(today()),mmyyd5.))";
run;

if you don't need the sheet name for other purposes.

PG

View solution in original post


All Replies
Super User
Posts: 10,500

Re: Proc Import Excel file tab with the current month

This code will return the current date in MM-YY format:

%let tab = %sysfunc(putn(%sysfunc(today()),mmyyd5.));

 

Use "&tab" where you would reference the sheet name.

Solution
‎06-22-2016 05:10 PM
Respected Advisor
Posts: 4,651

Re: Proc Import Excel file tab with the current month

... Or go directly for

 


proc import datafile="&sasforum\datasets\testdatetab.xlsx" out=test replace;
sheet="%sysfunc(putn(%sysfunc(today()),mmyyd5.))";
run;

if you don't need the sheet name for other purposes.

PG
Super User
Super User
Posts: 7,403

Re: Proc Import Excel file tab with the current month

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 260 views
  • 4 likes
  • 4 in conversation