正文

Base SAS匯報

(2007-07-24 08:25:30) 下一個
發信人: fab (fab),
實際準備時間:06/16~07/20。

SAS基礎:在學校上了一學期SAS Programming,自己看了兩遍Little SAS Book。

複習資料:SAS Online Tutor,Practice Exam。

Little SAS Book用來入門不錯,而SAS Online Tutor的針對性更強。研究了一下SAS
Base Exam的e-Learning: SAS Certification: Base Programming for SAS 9(325刀
,好貴,還好沒買)。它的目錄,全部包含在Online Tutor裏。也就是說,隻要看
Online Tutor的如下章節就可以了:

Basic Concepts
Referencing Files and Setting Options
Editing and Debugging SAS Programs
Creating List Reports
Creating SAS Data Sets from Raw Data
Understanding DATA Step Processing
Creating and Applying User-Defined Formats
Creating Enhanced List and Summary Reports
Producing Descriptive Statistics
Producing HTML Output
Creating and Managing Variables
Reading SAS Data Sets
Combining SAS Data Sets
Transforming Data with SAS Functions
Generating Data with DO Loops
Processing Variables with Arrays
Reading Raw Data in Fixed Fields
Reading Free-Format Data
Reading Date and Time Values
Creating a Single Observation from Multiple Records
Creating Multiple Observations from a Single Record
Reading Hierarchical Files

一共22個部分,一天一章也隻要3周時間就差不多了。

Practice Exam一定要看,很多題目都是原封不動的照搬,還有一些是依照原題稍作改
動。

SAS Online Tutor + Practice Exam的內容大概Cover 90%,剩下的基本都在本版貼出
來過。我還記得的:

※ proc contents考到varnum option
※ proc freq的table statement考到crosslist option
※ where statement考到like operator
※ cat & catx function
※ find function

以上內容看過,考的時候再稍微仔細一點,pass肯定沒問題。考試時間是非常充足的,
我做完題又檢查兩遍還剩了半小時。

SAS Online Tutor:可以隨時上網的話,建議使用SAS中文論壇的鏈接:http://www.mysas.net/forum/viewtopic.php?t=2206

Practice Exam本版就有。除了那個50題的Practice Exam,另外還有兩套散的,每套10
題。我給合並了一下,見附件(.pdf文件)。
[ 打印 ]
閱讀 ()評論 (1)
評論
twc 回複 悄悄話 All SAS database can be accessed by SQL queries.
It is much easier for me to compose SQL to access the SAS database.
登錄後才可評論.