topic Re: batch process data files with monthly contionout file names (like xxxx-Jan2014.csv, xxxx-Feb2014 in SAS Programming

batch process data files with monthly contionout file names (like xxxx-Jan2014.csv, xxxx-Feb2014.csv

fengyuwuzu — Thu, 21 Jan 2016 16:56:50 GMT

I was able to use the code belwo to batch process files with names like 201501.csv, 201502.csv,.. etc

Now I have 12 files, whose names are named by months, like xxxx-Jan2014.csv, xxxx-Feb2014.csv, ... xxxx-Dec2014.csv.

Is there a way to use the similar code below?

%macro run_me;
%let n=1;

%do %while (&n <= 9);
%let filein = xxxx20150&n..csv;

data output&n;
infile &filein;
<data step-->
run;

%let n=%eval(&n+1);
%end;
%mend;

Re: batch process data files with monthly contionout file names (like xxxx-Jan2014.csv, xxxx-Feb2014

Astounding — Thu, 21 Jan 2016 17:11:55 GMT

Yes, but you have to process over a list of values, rather than a range of numbers. You might call the macro like this:

%run_me (month_list=Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec)

Here's an article that tells you how to do it:

http://blogs.sas.com/content/publishing/2015/01/30/sas-authors-tip-getting-the-macro-language-to-perform-a-do-loop-over-a-list-of-values/

Re: batch process data files with monthly contionout file names (like xxxx-Jan2014.csv, xxxx-Feb2014

ballardw — Thu, 21 Jan 2016 17:20:12 GMT

Or you could step over months numerically and generate the part of the file name:

%let monnum=1;
%let year=2014;
%let name = %sysfunc(putn(%sysfunc(mdy(&monnum,1,&year)),MONYY7.));
%put &name;

If you have a do loop on MONNUM (or use &i where I used &monnum) you create the name part for a series.

Re: batch process data files with monthly contionout file names (like xxxx-Jan2014.csv, xxxx-Feb2014

fengyuwuzu — Thu, 21 Jan 2016 18:38:18 GMT

This works! Thank you, Astounding!

Re: batch process data files with monthly contionout file names (like xxxx-Jan2014.csv, xxxx-Feb2014

fengyuwuzu — Thu, 21 Jan 2016 18:38:50 GMT

Thank you, ballardw. I will give it a try later.