Use SAS to create sub dir on Windows inside an already existing parent dir (with name month number)

heleen_w — Thu, 13 Jun 2024 12:36:34 GMT

Hi Forum,

I would like SAS EG or SAS Studio to create a sub directory on Windows filesystem as the month previous to the one we are currently in, on the Windows file system however; so for example I would like that here

Q:\\BLAHBLAH\blahblah\5

Gets created on the previously existing

Q:\\BLAHBLAH\blahblah\

From with the UNIX-based SAS which resides I-don't know-where-but-probably-something-like-/opt/sas/... on some server-side which I cannot see. (I have no clue if I can write on that particular Q:\\ win-subdirectory but I tried having SAS output with ODS an excelfile in that path, this works.)

Since we are now in June the to be created sub dir should be '5' - so I created a variable which will return me the 5 like such

/*creates dir*/
%let P_month = %sysfunc(month(%sysfunc(intnx(month, %sysfunc(today()), -1))));
%put The Previous Month (based on one month back) is: &p_month;
run;

This works but;

How can I incorporate it into a statement to get the dir creation done?

DLCREATEDIR is not working/unallowed probably, DCREATE will not return an error but also do nothing (as in I see no win dir getting created and no log error), is it possible its logging is incomplete?

Thanks!

Kind regards,

heleen

Re: Use SAS to create sub dir on Windows inside an already existing parent dir (with name month num

yabwon — Thu, 13 Jun 2024 12:51:20 GMT

If I understood you correctly, you are running SASon server, you are connected to the server by SAS EG, and you want to create a new directory on your local drive?

If this is the setup, then the answer is: you won't be able to do this.

Such a try in real life could be compared to try of putting food into an oven using Zoom/Teams call.

If the SAS Server could create an Excel file and you can see the file on Q: drive, this probably means the drive is a network drive and it is your local windows connecting to it, and for the server, what you can see as "Q:\\BLAHBLAH\blahblah" is probalbly "/..<some/sub/path/here>../BLAHBLAH/blahblah/"

So if you want create sub-dir there you should use, the server path.

Bart

topic Use SAS to create sub dir on Windows inside an already existing parent dir (with name month number) in SAS Programming

Use SAS to create sub dir on Windows inside an already existing parent dir (with name month number)

Re: Use SAS to create sub dir on Windows inside an already existing parent dir (with name month num