BookmarkSubscribeRSS Feed
danimian
Calcite | Level 5

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

4 REPLIES 4
Doc_Duke
Rhodochrosite | Level 12

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
Calcite | Level 5

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
Rhodochrosite | Level 12

I've never used %sysexec; sorry.

Maybe the MOVE command has some switches to move subfolders?

pradeepalankar
Obsidian | Level 7

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

or you can also try

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 961 views
  • 0 likes
  • 3 in conversation