SASBASE考前备注..doc

SAS Programming II: 1、The ODS CSVALL Statement (SAS9) 2、The FSLIST Procedure 3、The SUBSTR Function (Right Side) 4、The RIGHT Function 5、The SCAN Function(If no special assignment,Length=200) 6、The TRIM Function 7、The CATX Function(CAT()) (SAS9) 8、The FIND Function (SAS9) 9、The INDEX Function 10、The UPCASE Function 11、The PROPCASE Function (SAS9) 12、The TRANWRD Function(If no special assignment,Length=200) 13、The LOWCASE Function 14、The SUBSTR Function (Left Side) 15、Data Conversion 16、Excel (xls)文件及其sheets，SAS怎样调用这样的Sheets SAS Programming I： 17、Proc report 18、Proc tabulate 19、Proc freq 20、Proc report 21、Proc datasets（1：Referencing Files and Setting Options _11-12） 22、Proc contents（1：Referencing Files and Setting Options _11-12） 23、OPTIONS statement（1：Referencing Files and Setting Options _20-21） PART I:  proc print data=sasuser.heart(firstobs=10 obs=15); run; options firstobs=10 obs=15; proc print data=sasuser.heart; run; options obs=max; If you are generating SAS listing output, one way to control the layout is to double space it. To do so, specify the DOUBLE option in the PROC PRINT statement. For example, proc print data=clinic.stress double; var resthr maxhr rechr; where tolerance=I; run; control where text strings split in labels by using the SPLIT= option. proc print data=reps split=*; var salesrep type unitsold net commission; label salesrep=Sales*Representative; run; You can also use SAS time constants and SAS datetime constants in assignment statements. Time=9:25t; DateTime=18jan2005:9:27:05dt; When reading variables from raw data, SAS sets the value of each variable in the DATA step to missing at the beginning of each cycle of execution, with these exceptions: variables that are named in a RETAIN statement variables that are created in a sum statement data elements in a _TEMPORARY_ array any variables that are created with options in the FILE or INFILE statements au