1、 SAS 1 SAS SAS INSIGHT Analyst SAS INSIGHT Analyst INSIGHT INSIGHT SAS SAS SAS SAS SAS Excel Excel SAS *.txt SAS INSIGHT SAS SAS INSIGHT INSIGHT D:SAS_SHIYAN Excel SAS SAS 1 SAS 1-1 Mylib 1-1 Explorer (1) SAS Explorer 1-1 (2) SAS , New New Library (3) Name Mylib 1-2 (4) Path Browse (5) Select D:SAS_
2、SHIYAN SAS 1-2 (6) Ok New Library OK Mylib (7) Mylib 1-2 1-2 Excel SAS Excel sy1_2.xls 1-3 (1) SAS File Import Data Import Wizard Select import type Excel 1-4 Next 1-3 Excel sy1_2.xls 2 SAS (2) Select file Browse Excel Option OK 1-4 Next 1-4 (3) Select library and member 1-5 Next 1-5 (4) Create SAS
3、Statements Next Finish 1-5 Explorer Mylib sy1_2 1-6 1-6 Mylib.sy1_2 Excel SAS Label _COLn 3 SAS V I EWT A BLE View Column Names 1-6 1-3 SAS sy1_3.txt 1-7 (1) SAS File Import Data Import Wizard Select import type Tab Delimited File (*.txt) 1-8 Next (2) Select file Browse 1-8 1-7 sy1_3.txt 1-8 Options
4、 SAS Import Get variable name from fist row SAS 1-9 OK Next 1-9 SAS Import (3) Select library and member Work sy1_3 Next (4) Create SAS Statements Finish 1-10 Work.sy1_3 Explorer Work sy1_3 1-104 SAS 1-4 SAS Excel (1) SAS File Export Data Export Wizard Select library and member library member 1-11 N
5、ext 1-11 (2) Select export type Excel 1-12 Next (3) Select file 1-12 Next (4) Create SAS Statements Finish 1-12 INSIGHT SAS Solution Analysis Interactive Data Analysis SAS/INSIGHT Open 1-13 SAS/INSIGHT Open SASUSER CLASS Open 1-13 SASUSER.CLASS Solutions Analysis Analyst Analyst 5 SAS Tools Sample D
6、ata OK 1-13 1-5 INSIGHT INSIGHT SASUSER.CLASS Sort Sort 1-14 Y OK Asc/Des name age 1-14 1-14 Sort Sort 1-6 New Va r i a b l e s New Variables 1-15 OK A 1-15 A 6 SAS 1-15 Edit Va r i a b l e s Other Edit Va r i a b l e s 1-16 (1) weight Y height X (2) Transformation Y / X 1-16 (3) Name D_weight (4) L
7、abel (5) OK 1-16 1-7 Define Variables Define Variables 1-17 1-17 7 SAS 1-8 (1) Edit Observations Find Find Observations 1-18 (2) sex Va l u e M OK 1-18 1-19 (3) Extract 1-19 (4) File Save Data Save Data OK 1-19 Solutions Analysis Analyst Analyst (new project) File Open By SAS Name Select A Member Sa
8、suser.Class OK 1-20 Edit Mode Edit Browse Edit Edit 8 SAS 1-20 Select A Member 1-9 1-21 Sort (1) Data Sort Sort (2) Sort By (3) Ascend/Descend 1-21 name A 1-10 Edit Insert Columns Character Numeric 1-22 Compute Data Transform Compute Compute new (height + weight)/age 9 SAS 1-22 OK new 1-11 Edit Add
9、Rows 1-12 (1) Data Filter Subset Data Subset age Operators GE 1-23 1-23 Subset (2) 1-23 Lookup Values age 13 13 (3) OK 1-24 1-24 age 13 10 SAS File Save As By SAS Name SAS Save Data Filter None 1-13 Data Random Sample Random Sample Rows Ratio Seed 1-25 10 OK 1-25 1-25 File Save As By SAS Name SAS 1-14 1-26 Data Random Variates Normal( ) Mean Standard deviation 1-26 OK 1-1 INSIGHT SASUSER.CLASS . (1) (2) (3) (4) 11 SAS (5) 1-2 SASUSER.CLASS . (1) (2) (3) (4) (5) (7) ( ) 12
