topic Re: Renaming a folder in SAS Programming

Renaming a folder

jacksonan123 — Mon, 23 Dec 2019 19:40:14 GMT

I have a file Nflag which looks like this.

Flag

I also have a group of folders named:

Test1.nm7

Test2.nm7

Test3.nm7

Test4.nm7

Test5.nm7

What I would like to do is to have the folder names reflect the flag values so that those with a 0 (e.g.,0Test1.nm7) designation can be later deleted. What I would have initially would be:

0Test1.nm7
1Test2.nm7
0Test3.nm7
1Test4.nm7
1Test5.nm7

The final folders would be:

1Test2.nm7
1Test4.nm7
1Test5.nm7

Can someone tell me how best to do this?

Re: Renaming a folder

SuryaKiran — Mon, 23 Dec 2019 20:39:44 GMT

Hello,

Not sure exactly what your trying to achieve here. Do you want to modify the values in your dataset or you really want to rename the folders?

Re: Renaming a folder

Ksharp — Tue, 24 Dec 2019 11:35:55 GMT

Create a BAT file(Windows OS) by sas. like:

data _null_;

set have;

file 'c:\temp\rename.bat';

x=' rename Test1.nm7 0Test1.nm7 '; /*<-- Change it based on HAVE dataset*/

put x;

run;

And execute c:\temp\rename.bat under Command Line (Start--> Run --> cmd )

Re: Renaming a folder

jacksonan123 — Wed, 25 Dec 2019 15:24:49 GMT

I understand the concept of the batch file but I am unsure how it is
supposed to work.

Let me explain again. I have two folders one Nflag which has the variable
flag.

Flag

0

1

0

A second folder bootstrap contains folders named :

Test1.nm7

Test2.nm7

Test3.nm7

In your batch file let's assume that my bootstrap is named have. We
activate the bat file.

My question is when do we bring in Nflag which contains the values to be
concatenated 1 to 1 with Test1.nm7 .. Can you tell me how that file enters
into your solution?

Re: Renaming a folder

ChrisNZ — Thu, 26 Dec 2019 09:05:14 GMT

Like this?

data _null_;
set HAVE;
CMD=catt('rename "', FNAME, '" "', FLAG, NAME, '"');
putlog CMD;
* call system(CMD);
run;

Uncomment the last line when the code shown in the log is satisfactory.

Re: Renaming a folder

Ksharp — Thu, 26 Dec 2019 12:08:32 GMT

OK. assuming you have a folder named c:\bootstrap ,

under it there are three sub-folders named :

Test1.nm7
Test2.nm7
Test3.nm7

Firstly , make a table contains 0 and 1.

data have;
input Flag;
cards;
0
1
0
;

Secondly, get the sub-folders name :


data folders;
 rc=filename('x','c:\bootstrap');
 did=dopen('x');
 do i=1 to dnum(did);
  folder=dread(did,i);
  output;
 end;
 run;

Lastly ,make a BAT file if you could and execute BAT file.

Here is c:\temp\rename.bat .

Enter command line and type " c:\temp\rename.bat" to execute it .


 filename x 'c:\temp\rename.bat';
 data _null_;
 merge have folders;
 rename=catx(' ','rename',folder,cats(flag,folder));
 file x;
 if _n_=1 then put 'cd c:\bootstrap';
 put rename;
 run;

Re: Renaming a folder

jacksonan123 — Thu, 26 Dec 2019 13:07:49 GMT

I ran the code you supplied but I got an error. This is the log.

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73

74 data have;

75 input Flag;

76 cards;

NOTE: The data set WORK.HAVE has 3 observations and 1 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

80 ;

81

82 data folders;

83 rc=filename('x','c:\bootout');

84 did=dopen('x');

85 do i=1 to dnum(did);

86 folder=dread(did,i);

87 output;

88 end;

89 run;

NOTE: Argument 1 to function DNUM(0) at line 85 column 12 is invalid.

ERROR: Invalid DO loop control information, either the INITIAL or TO
expression is missing or the BY expression is missing, zero,

or invalid.

rc=0 did=0 i=1 folder= _ERROR_=1 _N_=1

NOTE: Mathematical operations could not be performed at the following
places. The results of the operations have been set to

missing values.

Each place is given by: (Number of times) at (Line):(Column).

1 at 85:12

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.FOLDERS may be incomplete. When this step was
stopped there were 0 observations and 4 variables.

WARNING: Data set WORK.FOLDERS was not replaced because this step was
stopped.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.00 seconds

Re: Renaming a folder

jacksonan123 — Thu, 26 Dec 2019 13:23:49 GMT

I ran your code and it ran okay. Not stated but I guess this should be run
from a DOS window under a *.bat file. My question is where is the Flag data
concatenated with the

Test1.nm7, Test2.nm7, Test3.nm7 which are represented by FNAME and NAME, how
is that input into the code?

I ask because I will actually have 1000 of the Testi.nm7 files to rename.

Re: Renaming a folder

Ksharp — Fri, 27 Dec 2019 12:11:55 GMT

Did you create a folder named "bootout" under C:\ ?

c:\bootout is refer to a directory.

and under it ,create many sub-directory like Test1.nm7.

c:\bootout\Test1.nm7

c:\bootout\Test2.nm7

.........

Re: Renaming a folder

jacksonan123 — Sat, 28 Dec 2019 20:10:29 GMT

This solution worked.

Re: Renaming a folder

jacksonan123 — Mon, 30 Dec 2019 13:29:49 GMT

I ran the batch file from a folder temp with a command prompt with the
command c:\temp\rename.bat, I get several messages.

They are( filename is not recognized as an internal or external command,
operable program or batch file). I get the same for data null , and merge.

For rename=catx(' ','rename',folder.cats(flag,folder)); I get the syntax of
the command is incorrect.

It worked but this time, I must have done something wrong. I have folder
bootstrap with the test*.nm7 folders and a folder bootout. Where should it
be located?

Rename.bat

Filename x 'c:\temp\rename.bat';

Data _null_;

Merge have folders;

rename=catx(' ','rename',folder.cats(flag,folder));

File x;

If _n_ then put 'cd:\bootstrap';put rename;run;

Re: Renaming a folder

Ksharp — Tue, 31 Dec 2019 11:14:59 GMT

Can you post your ERROR information?

Did your directory name contains some special character like blank ? if it was ,you need quote around it to rename.

rename "1Test2 nm7" 1Test2.nm7

Re: Renaming a folder

jacksonan123 — Tue, 31 Dec 2019 11:59:49 GMT

Thanks for responding, that was the issue and all is well.

Happy New Year.