Applications on Running Dos Commands within （应用程序在运行Dos命令）.pdf

Paper PO13 Applications for Running DOS Commands within SAS Na Li, Pharmacyclics, Sunnyvale, CA ABSTRACT ® Using the X statement in SAS to issue DOS commands and initiate other Windows applications can be very useful and efficient in managing, comparing and scheduling SAS programs and setting data set and program permission attributes. This paper details some application examples for programmatically copying programs from one directory to another, creating directories based on the contents of the data, scheduling programs to execute in sequence, comparing programs between directories, and setting up read/write permissions. The advantages of using the X statement and some usage considerations are also discussed. INTRODUCTION Within SAS the X statement can be submitted to execute operating system commands. In the Windows operating system, using the X statement allows SAS to perform DOS commands and initiate Windows applications such as Word and Excel from within a SAS program. Using the X statement not only provides the convenience of programmatically and automatically managing files but also provides a tracking document to trace the file source and track the process, which can be a difficult task when the process is done manually in the manner of click and drag. Executing a DOS command from within SAS is relatively simple. However, this paper reveals some efficiency techniques and useful tips that are not commonly documented. The examples in this paper are processed by using the PC MS Windows XP operating system and the SAS version 8.2 is used to execute the programs. COPY FILES The syntax for issuing a DOS Command from within SAS is simply, X ‘DOS command’. Here is an example for copying an Excel file with the name of PGMTEST from C:\My Documents to F:\STUDY101. X ‘c