renaming an external file

[R_A_G_]

Hello SAS Experts,

I have a data file in my c directory named which I need to duplicate and rename.

The old data in "C" directory:

C:\CDM1\command.dat

I need to rplicate this to 100 files named :

C:\CDM1\CDM_1
C:\CDM1\CDM_2
C:\CDM1\CDM_3
C:\CDM1\CDM_4
and so on.

I appreciate any help.

Thank you
RG

[sbb]

Look at using the CALL SYSTEM function from a DATA step -- you generate your OS command syntax. Recommend reviewing the particulars in the OS-specific SAS "companion" guide available on the SAS support http://support.sas.com/ website, where you will find SAS-hosted DOC but also supplemental technical and conference reference material, available using the website SEARCH or an Internet search engine.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search arguments, this topic / post:

call system site:sas.com

execute os commands site:sas.com

[SPR]

Hello R.A.G

This is a solution:
[pre]
libname i "C:\CDM1";
%macro a;
%do i=1 %to 100;
data i.CDM_&i;
set i.command;
run;
%end;
%mend a;
.%a
[/pre]
The only question: is a command.dat a SAS dataset? If yes then this is the solution.
Sincerely,
SPR

[R_A_G_]

Thank you SPR

[R_A_G_]

The only problem is that command is a .dat file
Thank you
RG

[Ksharp]

Hi.If your OS is Windows.
How about:
[pre]
data _null_;
file 'c:\copy.bat';
do i=1 to 10;
str=cats("copy c:\class.txt c:\class",i,".txt");
put str;
end;
run;
x "c:\copy.bat";
x "del c:\copy.bat";
run;
[/pre]



Ksharp

[R_A_G_]

thanks KSharp,
but No it doesn't work. It takes my command.INP file and wipes everything in it and turns it into a text file with these writen in it.
copy c:\command.inp c:\class1.inp
copy c:\command.inp c:\class2.inp
copy c:\command.inp c:\class3.inp
copy c:\command.inp c:\class4.inp
copy c:\command.inp c:\class5.inp
copy c:\command.inp c:\class6.inp
copy c:\command.inp c:\class7.inp
copy c:\command.inp c:\class8.inp
copy c:\command.inp c:\class9.inp
copy c:\command.inp c:\class10.inp

copy c:\command.txt c:\class10.inp

[R_A_G_]

Hello all,

Just to let you know I did get help from outside the Forums and found the code I am writing it here for those who are curious to know.

options noxwait noxsync;
data _null_;
do i = 1 to 2;
dosCommand="copy c:\cdm1\command.inp c:\cdm1\CDM" || strip(i) || ".INP";
put dosCommand;
call system(dosCommand);

end;

run;

[Ksharp]

call system() is very boring because after executing call system every time you need to close the windows manually.

When you need 100 files ,then you need close the command windows manually for a hundreds times. Are you feeling tired with your finger?

And my code is only to close one command windows.



Ksharp

[Ksharp]

Sigh..........
I only give you an example.
The only thing you need change is to change pathe and filename.


[pre]
data _null_;
file 'c:\copy.bat';
do i=1 to 10;
str=cats("copy c:\cdm1\command.dat c:\cdm1\cdm_",i,".dat");
put str;
end;
run;
x "c:\copy.bat";
x "del c:\copy.bat";
run;
[/pre]