An Image/Link below is provided (as is) to download presentation
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.Content is provided to you AS IS for your information and personal use only.Download presentation by click this link.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.During download, if you can't get a presentation, the file might be deleted by the publisher.
例:DATA B; INPUT SEX $ AGE NUMBER; CARDS ; F 20 10 F 22 23 M 21 19 M 22 16 PROC MEANS ; VAR AGE ; PROC MEANS ; FREQ NUMBER ; VAR AGE ;
6.7 ID 语句 • 语句格式: ID 变量表; • 功能: 在输出数据集时,用该语句所规定的变量来识别观测值。 • 例:PROC PRINT DATA=A; PROC PRINT DATA=A; ID NAME;
6.8 FORMAT 语句 • 语句格式: FORMAT 变量 [格式] …; • 功能: 用于在过程中设置变量输出格式。 • 说明: • 使用宽度值、小数点和小数位数的格式 PROC PRINT DATA=A; FORMAT H 6.2 W 5.2 ; • 格式名以小数点结束 FORMAT SEX SEXFMT.;
DATA EMPLO; INPUT NAME $ T DATE7.; CARDS; zhongli 15jan84 liuwei 03mar85 proc print; FORMAT T WORDDATE.; run;
取消所有现存标题: TITLE; • 取消第n行和它后面行的标题:TITLEn; • 给某个过程步的输出加上标题,语句放在前一步的RUN语句之后和下一个DATA、PROC或RUN语句之前的任何地方。 • 例1:PROC PRINT ; TITLE 'TITLE FOR FIRST PROC'; PROC MEANS; • 例2:PROC PRINT DATA = A; RUN ; TITLE 'TITLE FOR SECOND PROC'; PROC MEANS ;
例: PROC PRINT DATA= A; TITLE1 'THIS IS '; TITLE2 'A DATASET'; FOOTNOTE 1 '------------'; FOOTNOTE 2 'END'; RUN;
SAS 服务过程不直接给出统计值,常被用于准备或整理统计资料。 PRINT FORMAT SORT DBF TRANSPOSE STANDARD 第七章 SAS服务过程
7.1 PRINT 过程 PRINT 过程语句 PROC PRINT [ DATA=数据集 ] [ NOOBS ][ LABEL ] ; VAR 变量表; ID 变量; LABEL 表达式; SUM 变量表; BY 变量; WHERE 表达式;
例1:有一关于两个不同地区在职人员与退休人员年平均收入与消费水平的调查, 要求:分在职与不在职打印出每一地区两种人员收入与消费的总和。 DATA A; INPUT NAME $15. D $ W $ EARN EXP @@; CARDS; LILING A 1 5500 4700 LIUHONG B 2 4600 4000 PROC SORT; BY D W; PROC PRINT; BY D W; SUM EARN EXP;
VALUE $ GRADE 'A'='GOOD' 'B'-'D'='FAIR' ‘F'-‘H'='SEE INSTRUCTOR' OTHER='MISCODED'; VALUE LOW-10='-10' 10<-20='-20' 20<-HIGH='20+';
7.2.3 应用举例 PROC FORMAT; VALUE $ SEXFMT ‘1’=‘FEMALE’ ‘2’=‘MALE’; VALUE AGEFMT LOW-20='-20' 20<-45='-45' 45<-HIGH='45+'; DATA A; INPUT NAME $ SEX $ AGE V @@; FORMAT AGE AGEFMT. SEX $SEXFMT. ; CARDS; wangdong 1 24 4300 xueping 2 18 4500 …… PROC MEANS; CLASS SEX AGE; VAR V; RUN;
Statistic list 统计量列表: MEANS过程可以计算的统计量有21种,可用下列关键词表示:N、MAEN、MAX、MIN、STD、STDERR、SUM、VAR、USS、CSS、NMISS、RANGE、T、PRT、SUMWGT、CV、SKEWNESS、KURTOSIS、CLM、LCLM、UCLM。 缺省时为N、MIN、MAX、MEAN、STD。
例:DATA B; INPUT SEX $ AGE NUMBER; CARDS ; F 20 10 F 22 23 M 21 19 M 22 16 PROC MEANS ; VAR AGE ; PROC MEANS ; FREQ NUMBER ; VAR AGE ;
MEANS过程例1: DATA SCORE; LENGTH NAME $ 12; INPUT NAME SEX GROUP $ T1-T3 @@; S=SUM( OF T1-T3); CARDS; SUNHONG 2 3 89 97 87 ZHAOBIN 2 3 66 98 86 WANGDONG 1 1 90 70 60 XUEPING 2 2 85 95 88 ZHOUHUA 1 1 77 84 69 HEYAN 1 2 95 78 88 HUANGSHAN 2 3 67 75 76
proc means data=score maxdec=3 ; var t1 t2 t3; class group; title 'statistics with class variable'; proc sort data=score;by group; proc means maxdec=3 ; by group; var t1 t2 t3; title 'statistics with by variable'; Run;