After reading archive or save file

[danimian]

Hello,

with 'proc import datafile' after reading .xls file i want to save or archiv it to another folder.

How it is possible in Enterprsie guide?

Thanks in advance

Dani

[Doc_Duke]

one way is with file --> export.

you can create a SAS (or excel) dataset in another directory as a one-off or as a repeatable task.

[danimian]

I did it with %sysExec copy command and working fine.

Now the problem is i want to move Only subfolder / subdirectorires to another target folder. I tried it with move command (%SysExec move) but it is working for complete folder and not for only subfolder.

Here is file structure.

Source Path: c:\folder/subfolder

Target Path: c:tgtfolder

%sysExec move "c:\folder" "c:\tgtfolder"

This command moving complete folder in tgtfolder and looks like c:\tgtfolder\folder\subfolder. What i want to achieve is c:\tgtfolder\subfolder

I tried different possiblities but still not found any solution, any idea?

[Doc_Duke]

I've never used %sysexec; sorry.

Maybe the MOVE command has some switches to move subfolders?

[pradeepalankar]

try something like :%sysExec move c:\folder\xyz.xlsx c:\tgtfolder

or you can also try

X 'move c:\folder\xyz.xlsx c:\tgtfolder';