@Patrick Mine is UNIX environment.  NOXCMD is set by default in our platform. How to tackle the problem in UNIX?   NOXCMD Disables the X command in SAS ... View more

@andreas_lds Thank you for the answer. What would be the alternative solution for my problem statement as told in my initial post? ... View more

@Patrick  Got this error when I ran your code in SASViya. So I don't have access to local machine from SAS server?   ERROR: Insufficient authorization to access PIPE. ... View more

@Tom Here are we copying the file from the xx folder to yy folder? ... View more

This option sounds good. How to rename the .jung_file to .xlsx while in proc export? Because our programs are using both ODS EXCEL and proc export to generate output.xlsx files. ... View more

@Tom Please see my initial post. Background of the problem is 'I was asked to tweak the following code (see my initial post) and the idea is to create file in WORK folder first and then copy that file to the output folder. Because our client observed that the users are accessing the file from the output folder before it is fully being generated. In order to prevent this issue, we came up with the above said approach. Is it good?' ... View more

@Tom that's great. Is this the alternate solution when compared to @Kurt_Bremser program which he posted before. So recfm=n is not required when I consider to use the Kurt's approach? ... View more

@Tom Thank you for the explanation. I yet to try the proposed solution per my initial post. So using 'rm -f' is the only efficient solution for my problem? It looks that the SAS runs on UNIX in our platform. ... View more

What's the use of 2>&1 in your infile statement?  On a separate note, whether my proposed solution will work for windows? Sorry to ask this question again. ... View more

@Patrick  From your statement below, I don't see XCMD option or call system statement in your code. I could see only 'pipe' option in infile statement   The SAS code I share with you is showing it. SAS Option XCMD is required for issuing an OS command out of SAS (for example via a pipe). You could also use call system(<here your OS command>) instead of a pipe. And you will make your life much easier if you make the OS command first work out of a command prompt. My apologies if I missed something ... View more

@Shmuel To clarify, Target output location is in network drive. I'm looking for efficient sample SAS program to copy files from WORK to network drive.  I don't wish to repeat the same steps over again and again. SAS environment is SAS Studio. ... View more

@Patrick Thank you for the insights. To clarify, Target output location is in network drive.   Two quick questions.   a) Were you able to show me how this can be achieved via SAS program,  "As long as option XCMD is set you can do something similar in a Unix/Linux environment. I'd be using rsync in place of xcopy" ? b) Can I understand that the following infile statement will work if I change the target path from C:\ to network drive? Is %tslit  inbuild SAS macro? What is the meaning of /F/Y here? infile %tslit(xcopy "&work_path\*.xlsx" "c:\temp" /F/Y) pipe truncover end=done; ... View more

Final output and work directory are in different device. How to handle now? ... View more

What's the use of 2>&1 in your infile statement?    On a separate note, whether my proposed solution will work for windows? Sorry to ask this question again. ... View more

@Kurt_Bremser Thanks for your reply. Two questions. A) Whether my proposed solution is correct even though it is not efficient? B) I have not used UNIX command  in my SAS program yet. It would be nice if you show me how and where to place rm -f command from my program? ... View more