|
|
楼主
楼主 |
发表于 2006-4-10 05:50:19
|
只看该作者
SAS Adv 考证一点经验
From SASOR:
刚刚考完，趁热写几句。
复习资料：prog3, macro, sql and optimizing教程
考试比例：prog3 30%, macro30%, sql 30%, optimizing 10%(只要是chap1-4,, chap567和prog3的部分内容混合。
内容分两大类：一类是观念题，如果不清楚的话，只能猜了。有3题，我觉得不再教程中。
一类是二个数据组(4个，3个记录，3-4个变量)，看SQL和DATAstep各种join and merge 的结果。比较多的是相同结果的不同编成。还有就是各种error的解释。
-- macro考的最差
-- 有5题和proc datasets有关，建议多看看。
-- 网上的复习题没做(没时间)。但是考题比模拟题长。(第二类)
-- 旧的教程可以用。2004新版教程SQL和MACRO有一些新的SAS function(考了一个)。2004 proc3，最好用新的(斑竹的复习翻译是新版)。我的2002版，相差很大，千万不要用。2004SQL的部分解释(join and set operator)比原来的清楚。(可能是旧版是3天，新版是2天，有些读数据的内容省掉了，multidimentional array解释比旧版清楚。
-- 有空复习一下prog2，的merge部分。
-- 有空看一下proc catalog
Accessing Data Using SQL - 大约30% - 40%
Generate detail reports by working with a single table or joining tables using PROC SQL and the appropriate options - 没有
Generate summary reports by working with a single table or joining tables using PROC SQL and the appropriate options -有
Construct subqueries within a PROC SQL step -无
Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques - 大大有
Access Dictionary Tables using the SQL procedure - 有
Demonstrate advanced PROC SQL skills by creating and updating tables, updating data values, working with indexes using the macro -有interface/creating macro variables with SQL, defining integrity constraints, -有
SQL views and SET operators - view 有
Macro Processing -30%
Creating and using user-defined and automatic macro variables within the SAS Macro Language - 无
Automate programs by defining and calling macros using the SAS Macro Language -有
Understand the use of macro functions - 有
Recognize various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log - 大大有
Advanced Programming Techniques -30%
Demonstrate advanced data set processing techniques such as updating master data sets, transposing data, combining/merging data, sampling data using generation data sets, integrity constraints and audit trails - 好像没有
Reduce the space required to store SAS data sets and numeric variables within SAS data sets by using compression techniques, length statements or DATA step views - 有
Develop efficient programs by using advanced programming techniques such as permanent formats -有 and array processing -没有
Use SAS System options and SAS data set options for controlling memory usage -有
Control the processing of variables and observations in the DATA step -有
Create sorted or indexed data in order to avoid unnecessary sorts, eliminate duplicate data and to provide more efficient data access and retrieval - 有
Use PROC DATASETS to demonstrate advanced programming skills (e.g. renaming columns, displaying metadata, creating indexes, creating integrity constraints, creating audit trails) -大大有 |
|
