topic Re: move xls between folders in SAS Programming

move xls between folders

me55 — Thu, 04 Apr 2019 17:55:08 GMT

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....

Re: move xls between folders

Reeza — Thu, 04 Apr 2019 18:11:40 GMT

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.

Re: move xls between folders

me55 — Thu, 04 Apr 2019 18:29:02 GMT

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