DD's SAS notes 29Aug2012

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

今天有些收获，找到一些不错的学习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)
略

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：notes note Aug G20 not report EXCEL forum 网站 资源