topic Re: After reading archive or save file in SAS Enterprise Guide

After reading archive or save file

danimian — Thu, 30 Jan 2014 11:57:00 GMT

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

Re: After reading archive or save file

Doc_Duke — Fri, 31 Jan 2014 02:40:09 GMT

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.

Re: After reading archive or save file

danimian — Fri, 31 Jan 2014 14:26:38 GMT

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?

Re: After reading archive or save file

Doc_Duke — Fri, 31 Jan 2014 19:16:14 GMT

I've never used %sysexec; sorry.

Maybe the MOVE command has some switches to move subfolders?

Re: After reading archive or save file

pradeepalankar — Fri, 31 Jan 2014 21:52:16 GMT

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

or you can also try

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