DD's SAS notes 29Aug2012-经管之家官网！

今天有些收获，找到一些不错的学习SAS的网站资源
SAS global forum 的Proceedings online
2011 的 http://support.sas.com/resources/papers/proceedings11/TOC.html

Paper 054-2011:		Singh, Subhashree; Singh, Sovraj
	Learn SAS® in 50 Minutes
Paper 055-2011:		Shipp, Charles E.; Lafler, Kirk P.
	Top Ten SAS® Sites for Programmers: A Review

Top ten里排第二的http://lexjansen.com/也不错，集合了很多资源，很容易找到东西。
生成EXCEL report的不同方式比较

Paper 074-2011:		Miralles, Romain
	Creating a Microsoft Excel Report: A Comparison of the Different Techniques

PROC EXPORT

1. PROC EXPORT DATA = sasglf
   
2. DBMS=excel
   
3. OUTFILE = "c:\sas_globalforum.xls"
   
4. REPLACE;
   
5. sheet='page1';
   
6. RUN;

复制代码
LIBNAME ENGINE
A. LIBNAME engine without a template

1. LIBNAME toexcel EXCEL 'c:\sugi_libname.xls' VER=2002 ;
   
2. DATA toexcel.sugi(DBLABEL=YES);
   
3. SET sugi.sugi ;
   
4. RUN;
   
5. LIBNAME toexcel CLEAR;

复制代码
B. LIBNAME engine with a template

1. PROC DATASETS LIB=toexcel;
   
2. DELETE sugi; /* Sugi is the named range defined in excel*/
   
3. RUN;
   
4. QUIT;
   
5. PROC DATASETS LIB=toexcel;
   
6. DELETE param; /* 2nd named range defined in excel*/
   
7. RUN;
   
8. QUIT;
   
9. DATA toexcel.sugi; /* 2nd output the data in the ‘sugi’ range defined in Excel*/
   
10. SET sugi ;
    
11. RUN;
    
12. DATA toexcel.param ;
    
13. SET param ;
    
14. RUN;
    
15. LIBNAME toexcel CLEAR; /* Disconnect from workbook*/

复制代码
EXCELXP TAGSET
略
ODS CSV

1. ODS CSV FILE='C:\sasglobal.csv';
   
2. PROC PRINT DATA=sasglobalforum;
   
3. RUN;

复制代码
ODS HTML

1. ODS HTML BODY = 'C:\sugi.xls';
   
2. PROC FREQ DATA=sugi;
   
3. TABLES var1 var2;
   
4. RUN;
   
5. ODS HTML CLOSE;

复制代码
ODS MSOFFICE2K
略
DDE
略
INTEGRATED OBJECT MODEL(IOM)
略