The SAS Output Delivery System and reporting techniques

Can SAS Create Folders?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 215
Accepted Solution

Can SAS Create Folders?

Suppose I have a library of SAS datasets that are updated regularly, and I use those datasets to create new analysis datasets for each update.  I want to store those new analysis datasets in archived folders.  Is it possible to have SAS create a folder in my code, or do I have to manually create the folder and then tell SAS where to store the data?

For example, let's say that I have my base datasets stored in C:\Studies\DrugA\Protocol1\Data.  And suppose that I am outputting my analysis data into the following directory: C:\Studies\DrugA\Protocol1\AnalysisDatasets.  However, I want to archive them, so I will have a new subfolder for each date I run the data, so I might have the following folders:

C:\Studies\DrugA\Protocol1\AnalysisDatasets\2013-01-01

C:\Studies\DrugA\Protocol1\AnalysisDatasets\2013-02-10

C:\Studies\DrugA\Protocol1\AnalysisDatasets\2013-02-17

C:\Studies\DrugA\Protocol1\AnalysisDatasets\2013-04-11

etc.

Is there a way to set up SAS code to create a folder based on the date the program is run, or do I have to manually create the folder and then change the LIBNAME statement in my code?


Accepted Solutions
Solution
‎08-15-2013 03:02 PM
Grand Advisor
Posts: 16,411

Re: Can SAS Create Folders?

Yes, Use the dcreate() function with a macro variable for the date.

SAS(R) 9.3 Functions and CALL Routines: Reference

View solution in original post


All Replies
Super Contributor
Posts: 358

Re: Can SAS Create Folders?

Hi:

I think it can, but we just run a DOS command to do it:  Here is a sample doing a file move.....

  %let cmd = MOVE "&prefix.\From\File.txt" "&prefix.\Archive\File.txt";

  data _null_;

  option noxwait;

  X &movecmd;

  run;

Solution
‎08-15-2013 03:02 PM
Grand Advisor
Posts: 16,411

Re: Can SAS Create Folders?

Yes, Use the dcreate() function with a macro variable for the date.

SAS(R) 9.3 Functions and CALL Routines: Reference

Valued Guide
Posts: 3,206

Re: Can SAS Create Folders?

Live can be that easy when it is done automatic

SAS trick: get the LIBNAME statement to create folders for you - The SAS Dummy

---->-- ja karman --<-----
Post a Question
Discussion Stats
  • 3 replies
  • 305 views
  • 3 likes
  • 4 in conversation