Macro's creating folder on Export.

[shenniko]

Hi all,

Need some help again,

I've a macro setup to export a series of CSV files for each region we have, and this report will be ran monthly. But what i would like it to do is export the CSV files to its own folder depenging on the Month/Year...

E.g Running this report now, it should create a dataset for each region we have, for last month.

So when exporting the CSV files, i'd like sas to create a folder called /November_2005/ and then export all the files to that directory.. Next month it will create a folder called /December_2005/ etc.. etc..

Any ideas on how i go about doing this?

thanks in advance

Robbie

 

[klaz2002]

If you are using a windows OS you could use he MD command. I would use the year first so that the folder sorts by default, but here is how you can do it.

%let rptroot =c:\path\to\root;

%let y= %sysfunc(putn(%sysfunc(date()),monname9.))_%sysfunc(putn(%sysfunc(date()),year4.));

filename outrpt pipe "md &rptroot\&y";

data _null_;
file outrpt;
run;

I hope that this helps you out.
Klaz