2012年04月_qq1323362960

11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

转载 Safely Merging Many Datasets

如题，该代码摘自“Safely Merging Many Datasets”一文，可以下载原文http://support.sas.com/resources/papers/proceedings11/409-2011.pdf/********************************************************A macro to safely merge al

2012-04-28 17:50:59 446

转载 sas做广义估计方程

赵目等在“纵向数据下广义估计方程估计”一文从数学角度对广义估计方程进行了探讨，这里转载个sas做广义估计方程的例子：data thall; input id y visit trt bline age; intercpt=1; cards;104 5 1 0 11 31104 3 2 0 11 31104 3 3 0 11 31104 3 4 0

2012-04-26 21:04:26 5210

原创极差标准化方法&因子分析综合得分

1.极差标准化方法经济统计分析中对正负指标标准化的一种处理方法：sas计算：proc sql; create table new as select (x-min(x))/(max(x)-min(x)) as z_x, (max(x)-x)/(max(x)-min(x)) as f_x from mydata;quit;

2012-04-22 22:29:32 19125

转载 proc glm vs proc reg

1.0 Introduction to Regression Procedures in SAS Statistical ProcedureFunctionsREGperforms linear regression with many diagnostic capabilities, selects models using

2012-04-20 14:26:28 6095

原创提取数据的变量信息content

proc contents 可以用来提前数据的一些信息，利用ods trace on语句可以检查代码运行结果的细节，找到生成变量数据并将其输出。ods trace on;proc contents data=sashelp.class; ods output variables=need;run;ods trace off;熟悉proc contents语句的，也可以一

2012-04-20 14:23:25 3125

原创 proc g3d VS scatterplot3d （R）

1.SAS的G3D语句，其语法：PROC G3D input-data-set>annotate-data-set> libref.>output-catalog>; PLOT plot-requestoption(s)>; SCATTER plot-requestoption(s)>;例如：proc g3

2012-04-19 09:23:56 1559

原创 missing函数

missing()函数是用来检验缺失值的函数帮助文档里有个例子，它是用来检查包含缺失值的变量的：data _null_; input @1 var1 3. @5 var2 3.; if missing(var1) then do; put 'Variable 1 is Missing.'; end; else if m

2012-04-17 19:06:23 4105

原创 proc sql 语句中的case 表达

proc sql; select name,sex,age,weight,height, case when height> 65 then "Tall" when height else "Average Height" end as New_height from sashelp.

2012-04-16 19:50:41 4848

转载 USING SAS TO FIND THE BEST K FOR K-NEAREST-NEIGHBOR CLASSIFICATION

******(1) USE K-MEANS CLUSTERING TO FIND NEAREAST NEIGHBORS****************;proc modeclus data = sashelp.iris m = 1 k = 4 out = _test1 neighbor; var petallength petalwidth sepallength sepalwidth

2012-04-15 21:48:22 1155

转载 SAS读取含多个子表的EXCEL表

转自：http://www.nesug.org/Proceedings/nesug11/cc/cc17.pdf该文主要应用proc sql将字表文件名赋予宏变量，然后循环读取字表中的变量名。%macro xlread; /**Assign a libname for excel sheet*/ LIBNAME XLSLIB "C:\NESUG-2011\Metabolite

2012-04-13 19:32:51 4444

转载 GLMSELECT Procedure

FROM http://support.sas.com/rnd/app/papers/glmselect.pdfThe GLMSELECT procedure performs effect selection in the framework of general linear models. A variety ofmodel selection methods are availab

2012-04-11 11:39:56 1871

原创带误差区间图

google到很多资源，整理如下：一.sas HILOCTJ interpolation1.1 proc gplot gchart等a.support.sas官网的例子：带误差线的均值图http://support.sas.com/kb/42/515.htmlb.几篇文章“A Generalized Procedure to Create SAS®/Graph Er

2012-04-10 11:34:40 2068

翻译 SAS的DM 命令

它的语法结构很简单：DM 'command(s)' ;窗口可以是编辑窗口edit,记录窗口log，或者，输出窗口output.'command(s)'命令必须在引号' '里面，如果是几条命令则必须用分号;隔开即DM语句运行后在执行的SAS语句。简单应用：dm 'flsvlast'; *保存代码;dm 'log; clear; output; clear;'; *清除

2012-04-07 16:00:49 7094

原创 SAS dictionary工具

*得到库信息;proc sql; select * from dictionary.dictionaries;quit;*获取查询表名;proc sql; select unique memname from dictionary.dictionaries;quit;*or;proc sql; select memname from dictio

2012-04-06 20:45:30 1691

转载消费信用中的漏斗图

"Application of SAS to monitoring loan defaults in consumer credit portfolios“libname maps 'D:\Program Files\SAS\SASFoundation\9.2\maps\'; libname temp 'D:\temp\sas Temporary Files';/* Resetti

2012-04-04 21:47:28 1153

转载 PROC SQL中的逻辑判别和描述性统计函数

1.逻辑表达：>,*data step;data class_flags; set sashelp.class; tall = (height > 60); male = (sex = 'M'); female = (sex = 'F');run;*proc sql;proc sql; select name, (

2012-04-04 19:59:27 2329

转载 SGplot画图样例

*Grouping a Scatter Plot;proc sgplot data=sashelp.class; scatter x=height y=weight / group=sex;run;*Plotting Three Series;proc sgplot data=sashelp.stocks (where=(date >= "01jan2000"d and

2012-04-03 21:26:40 9545