topic Re: Create a folder and a subfolder in one string in New SAS User

Create a folder and a subfolder in one string

cleokatt — Thu, 12 Jan 2023 09:05:34 GMT

Hello,
I'm trying to make SAS to create a folder when running a code and that's just:

%let year = 2022;

options dlcreatedir;

libname out "mypath\&year";

and it works fine 🙂
but I also want SAS to create a subfolder in the

&year

-folder called 'data' and I thought I just could add:

%let year = 2022;

options dlcreatedir;

libname out "mypath\&year\DATA";

But it dosen't work that way. I was thinking maybe do the

options dlcreatedir;

libname out

twice. (like create the first folder, and then do the dlcreatedir once again, but I have a &year-macro variable so it dosen't make a good fit.

Anyone who can help me? 🙂

Re: Create a folder and a subfolder in one string

Patrick — Thu, 12 Jan 2023 10:37:16 GMT

Using DLCREATEDIR allows you to create a folder under an existing parent folder.

The code you've posted looks right and it's something that I've done already many times without ever having issues.

Below code will work if the absolute path d:\mypath already exists

%let year = 2022;
options dlcreatedir;
libname out "d:\mypath\&year";
libname out "d:\mypath\&year\data";

Re: Create a folder and a subfolder in one string

Ksharp — Thu, 12 Jan 2023 11:35:36 GMT

/*
Try function DCREATE()
--DCREATE(directory-name<,parent-directory>)
*/

%let year = 2022;

data _null_;
 new=dcreate("&year",'c:\temp\');
 new=dcreate("data",new);
 put new= ;
run;

Re: Create a folder and a subfolder in one string

cleokatt — Sun, 15 Jan 2023 17:33:40 GMT

@Ksharp how should the code look like if there was n subfolders in k?

Re: Create a folder and a subfolder in one string

Ksharp — Mon, 16 Jan 2023 11:58:28 GMT

/*
You should use N time for  DCREATE()
The following code would creata a path:
c:\temp\2022\data1\data2\data3\data4
*/

%let year = 2022;

data _null_;
 new=dcreate("&year",'c:\temp\');
 new=dcreate("data1",new);
 new=dcreate("data2",new);
 new=dcreate("data3",new);
 new=dcreate("data4",new);
 put new= ;
run;