The SAS Output Delivery System and reporting techniques

Can SAS Create Folders?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 228
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
Super User
Posts: 19,192

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
Super User
Posts: 19,192

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

Trusted Advisor
Posts: 3,208

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 --<-----
🔒 This topic is solved and locked.

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

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