Using Windows Batch File to Execute SAS Program Efficiently

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

（Under SAS 9.3  Environment）
SAS users commonly have the need to repeatedly execute sas programs and efficiently perform log scans.we discuss one simple method that uses windows batch(*.bat) files to submit sas program
1. Sample Directory structure




2.SAS file(include main.sas & program.sas)
code for main.sas:

1. %macro Program_initial;
   
2. filename fileref pipe "cd";
   
3. %put &Root;
   
4. data Root;
   
5. infile fileref pad;
   
6. input Root $200. ;
   
7. call symputx('Root',Root);
   
8. newdir=dcreate('work',"&Root");
   
9. newdir=dcreate('result',"&Root");
   
10. run;
    
11. libname worklib "&Root/work";
    
12. filename result "&Root/result";
    
13. %include "&Root/program.sas";
    
14. %mend;
    
15. %macro Program_Main;
    
16. %Program_initial;
    
17. ods listing close;
    
18. ods html path=result(url=none) file='index.html' ;
    
19. /*===============================*/
    
20. /*画图全局控制*/
    
21. ods graphics on / reset  border=off;
    
22. /*===============================*/
    
23. %program;
    
24. ods html close;
    
25. %mend;
    
26. %global Root;
    
27. %Program_Main;

复制代码

code for program.sas

1. %macro dataproc;
   
2. data worklib.a;
   
3. set sashelp.heart ;
   
4. run;
   
5. %mend;
   
6. %macro drawproc;
   
7. proc sgpanel data=sashelp.heart noautolegend;
   
8.   title "Cholesterol Distribution in Heart Study";
   
9.   panelby sex;
   
10.   histogram cholesterol;
    
11.   density cholesterol;
    
12. run;
    
13. proc sgscatter data=sashelp.iris;
    
14.   title "Scatterplot Matrix for Iris Data";
    
15.   matrix sepallength petallength sepalwidth petalwidth
    
16.          / group=species;
    
17. run;
    
18. title;
    
19. %mend;
    
20. %macro program;
    
21. %dataproc;
    
22. %drawproc;
    
23. %mend;

复制代码

for exmaple:

3.Creating and using sasauto.Bat file
code for  sasauto.bat ,you may need to change the installation path "C:\Program Files\SASHome\SASFoundation\9.3\sas.exe "

1. @ECHO OFF
   
2. SET /P FOLD=Enter Specific Project(i.e. P001)
   
3. rem set /p ANALYSIS=Batch Analysis Programs?(Enter Y for yes ,Otherwise hit enter)
   
4. rem ECHO Analysis Programs Batch Indicator=%ANALYSIS% >> Batch-Summary.txt
   
5. rem set /p GRAPHS=Batch Graph Programs?(Enter Y for yes ,Otherwise hit enter)
   
6. rem ECHO Graph Programs Batch Indicator=%GRAPHS% >> Batch-Summary.txt
   
7. 
   
8. ECHO Project=%FOLD%>>Batch-Summary.txt
   
9. ECHO Start:%DATE%: %TIME%>>Batch-Summary.txt
   
10. 
    
11. "C:\Program Files\SASHome\SASFoundation\9.3\sas.exe" -sysin  main.sas  -nolog  -nologo -icon -rsasuser
    
12. 
    
13. 
    
14. 
    
15. ECHO End:%DATE%: %TIME%>>Batch-Summary.txt
    
16. explorer result\index.html

复制代码

for exmaple

4.Run the bat file
(1) Initial Directory Environment
del the file "work" "result" which will recreate by main.sas
double click the sasauto.bat，input your program name and press enter

view the result in dir "result/index.html"

5.check the efficient

本帖隐藏的内容

sastest.rar (1.17 KB, 需要: 1 个论坛币)

2013-4-17 14:44:03 上传

象征式收一个
需要: 1 个论坛币  [购买]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享1 收藏7 回帖

关键词：EFFICIENT EXECUTE Program Windows Window SAS

好文章，顶一下！

相当实用

支持原创！

来看看

看起来相当不错，拿下来研究一下

Create a directory 'inifile' to  store your initial data would be better

看看看

呢，很好

看看