move xls between folders

[me55]

hey, i am working in sas eg on a sas server.  i can create an xls, say outfile.xls, in the working directory but i need it in another directory, say /sas/sas01/project/output/.  so i need a way to either copy the xls to another directory or create it in another directory and i am having issues figuring that out.  here is how i am creating it...

ods html file="WORK.OUTFILE.xls";

proc print DATE=DATAFILE;
run;

ods html close;

when i tried just subbing in the directory, that failed.  then i tried using a libref and that failed....

[Reeza · Accepted solution]

Your have to determine the correct server path to use and you need to do that on the server. Your IT area can tell you or you can try to create a new library and see where you can navigate. You can look into the COPY FILES task from Chris Hemidinger to move files to/from the server.

[me55]

thanks, stupid me forgot to create the output directory and didnt realize it....once i did that, subbing in the directory worked great.