Desktop productivity for business analysts and programmers

After reading archive or save file

Reply
Contributor
Posts: 24

After reading archive or save file

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

Trusted Advisor
Posts: 2,114

Re: After reading archive or save file

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.

Contributor
Posts: 24

Re: After reading archive or save file

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?

Trusted Advisor
Posts: 2,114

Re: After reading archive or save file

I've never used %sysexec; sorry.

Maybe the MOVE command has some switches to move subfolders?

Frequent Contributor
Posts: 106

Re: After reading archive or save file

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

or you can also try

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

Ask a Question
Discussion stats
  • 4 replies
  • 292 views
  • 0 likes
  • 3 in conversation