SAS系統簡介

Size: px

Start display at page:

Download "SAS系統簡介"

横尤
6 years ago
Views:

1 (DATA step) SAS (SAS data set) SAS SAS SAS SAS DATA [sasdataset[(dsoptions)]] ; SAS DATA PIG; DATA PIG.BW DATA _NULL_ ====> WORK.PIG( ) ====> PIG.BW( library name PIG) ====> DATA _DATA_;(or DATA;) ====> WORK.DATA1( ) DATA MALE FEMALE ====> WORK.MALE WORK.FEMALE DATA PIG (KEEP=PEN ADG BACKFAT) DATA PIG (DROP=PIGNO BACKFAT1-BACKFAT3) 1. SAS SAS Data Set WORK Log NOTE: The data set WORK.xxxx has... SAS SAS SASWORK SAS DATA PIG; 2. SAS Library Raw data SAS data set Library Data ( SAS/AF) Library SAS Raw data SAS data set *.sas7bdat 19

$(1). SAS Library C:\SAS>MD CHEN (2). SAS (3). LIBNAME Library reference LIBNAME CHICKEN 'C:\SAS\CHEN'; DATA CHICKEN.BODYWT8; INFILE 'C:\DATA\BODYWT8.DAT'; INPUT WB BW8; CARDS; ; (4).$

2 (1). SAS Library C:\SAS>MD CHEN (2). SAS (3). LIBNAME Library reference LIBNAME CHICKEN 'C:\SAS\CHEN'; DATA CHICKEN.BODYWT8; INFILE 'C:\DATA\BODYWT8.DAT'; INPUT WB BW8; CARDS; ; (4). C:\SAS\CHEN BODYWT8. sas7bdat SAS data set (5). DATA SET SAS/ASSIST (6). SAS data set Explorer Library reference libraries File / New library library name (Chicken) Engine V8 Enable at startup Path (C:\CHEN) 20

3 INPUT ( SAS ) 1. (Column input) missing values INPUT PROTEIN 1-2 ENERGY 3-6 PEN 7-8 PIGNO $ 9-13 INITWT WT4WT FINALWT BACKFAT BACKFAT BACKFAT ; CARDS; (List input) INPUT PROTEIN ENERGY PEN PIGNO $ INITWT WT4WT FINALWT BACKFAT1-BACKFAT3; CARDS; F (Formated input) INPUT (PROTEIN ENERGY PEN PIGNO $ INITWT WT4WT FINALWT BACKFAT1-BACKFAT3) ( $5. 2* *2.1) ; CARDS;

4 4. (Named input) INPUT PULSE WAIST AGE= SEX=$1.; CARDS; AGE=35 SEX=M. : Column pointer n (@pointvariable,@(expression)) Line pointer control: #n - n / - Line INFILE SAS DATA PIG; INFILE A:\PIG.BW ; INPUT PROTEIN ENERGY PEN PIGNO INITWT WT4WT FINALWT BACKFAT1 BACKFAT2 BACKFAT3; WTGAIN= FINALWT- INITWT; ADG=WTGAIN/98; BACKFAT= (BACKFAT1+BACKFAT2+BACKFAT3)/3; INFILE A PIG.BW INFILE A:\PIG.BW FIRSTOBS=5; INFILE A:\PIG.BW OBS=20; INFILE A:\PIG.BW MISSOVER; INFILE A:\PIG.BW LRECL=200; 22

5 1.LABEL DATA PIG; INFILE A:\PIG.BW ; INPUT PROTEIN ENERGY PEN PIGNO INITWT WT4WT FINALWT BACKFAT1 BACKFAT2 BACKFAT3; BACKFAT= (BACKFAT1+BACKFAT2+BACKFAT3)/3; LABEL PROTEIN= ENERGY= PEN= PIGNO= INITWT= WT4WT= FINALWT= BACKFAT= ; 2.LENGTH DATA PIG; INFILE A:\PIG.BW ; INPUT PROTEIN ENERGY PEN PIGNO INITWT WT4WT FINALWT BACKFAT1 BACKFAT2 BACKFAT3; LENGHTH PIGNO 10;( 8) 3.INFORMAT DATA PIG; INFILE A:\PIG.BW ; INFORMAT DEFAULT=3.1; INPUT X1-X5; CARDS; KEEP DROP RENAME DATA PIG; INFILE A:\PIG.BW ; INPUT PROTEIN ENERGY PEN PIGNO INITWT WT4WT FINALWT BACKFAT1-BACKFAT3; KEEP PROTEIN ENERGY PEN PIGNO INITWT WT4WT FINALWT; (=DROP BACKFAT1-BACKFAT3;) RENAME PEN=PENNO; CARDS;. 23

6 5.IF (THEN) DATA PIG1; INFILE A:\PIG.BW ; INPUT PROTEIN ENERGY PEN PIGNO INITWT WT4WT FINALWT BACKFAT1-BACKFAT3; BACKFAT= (BACKFAT1+BACKFAT2+BACKFAT3)/3; CARDS;. ; DATA PIG2; SET PIG1; IF BACKFAT <=3.0; DATA PIG3; SET PIG1; IF BACKFAT <=3.0 THEN DELETE; 24

7 1.BY ( ) PROC SORT; BY WBNO; 2.SET LIBNAME CHICKEN 'C:\SAS\CHEN'; DATA BW4; SET CHICKEN.BODYWT4(KEEP=WBNO SEX BODYWT4); DATA BW8; SET CHICKEN.BODYWT8(KEEP=WBNO SEX BODYWT8); DATA BODYWT; SET BW4 BW8; PROC PRINT ; RUN; 3.MERGE LIBNAME CHICKEN 'C:\SAS\CHEN'; DATA BW4; SET CHICKEN.BODYWT4(KEEP=WBNO SEX BODYWT4); DATA BW8; SET CHICKEN.BODYWT8(KEEP=WBNO SEX BODYWT8); DATA BODYWT; SET BW4 BW8; PROC SORT DATA=BW4; BY WBNO; PROC SORT DATA=BW8; BY WBNO; DATA BODYWT; MERGE BW4(IN=FIR) BW8(IN=SEC) END=OVER; PROC PRINT ; RUN; 25

8 4.UPDATE (TEST1) OBS NAME AGE GRADE1 ID 1 CHOU WANG SHUE LIN (TEST2) OBS NAME GRADE1 RANK3 ID LILY LEE UPDATA TEST1 TEST2; BY ID; OBS ID NAME AGE GRADE1 RANK3 1 1 CHOU SHUE LILY LEE

9 1.PUT (1). DATA CLASS; INPUT NAME $ AGE SEX HEIHGT WEIGHT; PUT NAME 6-15 AGE SEX HEIGHT WEIGHT ; CARDS; (2). DATA CLASS; INPUT NAME $ AGE SEX HEIHGT WEIGHT; PUT NAME AGE SEX HEIGHT WEIGHT ; CARDS; (3). DATA CLASS; INPUT NAME $ AGE SEX HEIHGT WEIGHT; PUT NAME 7. AGE 3. SEX 2. HEIGHT 7.2 WEIGHT 3.; CARDS; (4). DATA CLASS; INPUT NAME $ AGE SEX HEIHGT WEIGHT; PUT NAME=2.12 AGE=14-19 SEX HEIGHT WEIGHT 42-50; CARDS; 2.FILE FILE PUT LIBNAME CHICKEN 'C:\SAS\CHEN'; FILENAME CHICKBW8 'C:\SAS\CHEN\DATA'; DATA BW8; SET CHICKEN.BODYWT8(KEEP=WBNO SEX BODYWT); 27

10 FILE CHICKBW8; PUT WBNO 1-5 SEX $ 7 BODYWT ; 3.OUTPUT SAS (SAS data set) LIBNAME CHICKEN 'C:\SAS\CHEN'; FILENAME CHICKBW8 'C:\SAS\CHEN\DATA'; DATA BW8; SET CHICKEN.BODYWT8(KEEP=WBNO SEX BODYWT); IF SEX= F THEN OUTPUT FEMALE; ELSE OUTPUT MALE; PUT WBNO 1-5 SEX 7 BODYWT ; 28

11 NOTE: Copyright (c) by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to NATIONAL CHUNG HSING UNIV. - ANIMAL HUSBANDRY, Site NOTE: This session is executing on the WIN_PRO platform. NOTE: SAS initialization used: 5.93 seconds 1.54 seconds 1 OPTIONS PS=60 LS=80; 2 /********************************************************/ 3 /*THIS EXAMPLE SHOWS HOW TO DO SEVERAL BASIC DATA MANIPULATION 4 /* */ 5 /* 1: ENTERING DATA INTO A DATA SET */ 6 /* 2: TAKING A SUBSET OF THE OBSERVATIONS */ 7 /* 3: TAKING A SUBSET OF THE VARIABLES */ 8 /* 4: ADDING NEW VARIABLES */ 9 /* 5: COMBINING SEVERAL OPERATIONS */ 10 /* 6: MULTIPLE OUTPUT DATA SET */ 11 /* 7: CONCATENAION */ 12 /* 8: INTERLEAVING */ 13 /* 9: MERGING */ 14 /* 10: UPDATING */ 15 /* */ 16 /********************************************************/ DATA CLASS; 19 INPUT NAME $ 1-8 SEX $ 11 AGE HEIGHT WEIGHT 21-25; 21 CARDS; NOTE: The data set WORK.CLASS has 19 observations and 5 variables. NOTE: DATA statement used: 0.63 seconds 0.13 seconds 41 ; 42 RUN; 43 PROC SORT; 44 BY NAME; 45 RUN; 29

12 NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.CLASS has 19 observations and 5 variables. NOTE: PROCEDURE SORT used: 0.15 seconds 0.09 seconds PROC PRINT; 48 TITLE 'ORIGINAL DATA SET'; 49 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: PROCEDURE PRINT used: 0.17 seconds 0.08 seconds DATA B; SET CLASS; IF SEX="M" THEN DELETE; 52 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.B has 9 observations and 5 variables. NOTE: DATA statement used: 0.05 seconds 0.05 seconds PROC PRINT; 55 TITLE 'SUBSET OF OBSERVATIONS'; 56 RUN; NOTE: There were 9 observations read from the data set WORK.B. NOTE: PROCEDURE PRINT used: 0.02 seconds 0.02 seconds DATA C; SET CLASS; DROP HEIGHT WEIGHT; 59 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.C has 19 observations and 3 variables. 30

13 NOTE: DATA statement used: 0.07 seconds 0.07 seconds PROC PRINT; 62 TITLE 'SUBSET OF VARIABLES'; 63 RUN; NOTE: There were 19 observations read from the data set WORK.C. NOTE: PROCEDURE PRINT used: 0.05 seconds 0.05 seconds DATA D; SET CLASS; BIRTHYR=1977-AGE; 66 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.D has 19 observations and 6 variables. NOTE: DATA statement used: 0.06 seconds 0.06 seconds PROC PRINT; 69 TITLE 'ADDING A NEW VARIABLE'; 70 RUN; NOTE: There were 19 observations read from the data set WORK.D. NOTE: PROCEDURE PRINT used: 0.04 seconds 0.04 seconds DATA E; SET CLASS; 73 IF SEX="M" THEN DELETE; 74 DROP HEIGHT WEIGHT; 75 BIRTHYR=1977-AGE; 76 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.E has 9 observations and 4 variables. 31

14 NOTE: DATA statement used: 0.06 seconds 0.06 seconds PROC PRINT; 79 TITLE 'COMBINING SEVERAL OPERATIONS'; 80 RUN; NOTE: There were 9 observations read from the data set WORK.E. NOTE: PROCEDURE PRINT used: DATA MALES FEMALES; KEEP NAME; 83 SET CLASS; 84 IF SEX="M" THEN OUTPUT MALES; 85 IF SEX="F" THEN OUTPUT FEMALES; 86 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.MALES has 10 observations and 1 variables. NOTE: The data set WORK.FEMALES has 9 observations and 1 variables. NOTE: DATA statement used: 0.11 seconds 0.11 seconds PROC PRINT DATA=MALES; 89 TITLE 'MALES--FIRST OUTPUT DATA SET'; 90 RUN; NOTE: There were 10 observations read from the data set WORK.MALES. NOTE: PROCEDURE PRINT used: 0.02 seconds 0.02 seconds PROC PRINT DATA=FEMALES; 93 TITLE 'FEMALES--SECOND OUTPUT DATA SET'; 94 RUN; 32

15 NOTE: There were 9 observations read from the data set WORK.FEMALES. NOTE: PROCEDURE PRINT used: DATA BOTH; 97 SET MALES(IN=M) FEMALES(IN=F); 98 IF M THEN SEX="M"; IF F THEN SEX="F"; 99 RUN; NOTE: There were 10 observations read from the data set WORK.MALES. NOTE: There were 9 observations read from the data set WORK.FEMALES. NOTE: The data set WORK.BOTH has 19 observations and 2 variables. NOTE: DATA statement used: 0.06 seconds 0.06 seconds PROC PRINT; 102 TITLE 'CONCATENATED DATA SET'; 103 RUN; NOTE: There were 19 observations read from the data set WORK.BOTH. NOTE: PROCEDURE PRINT used: 0.16 seconds DATA BOTH; 106 SET MALES(IN=M) FEMALES(IN=F); BY NAME; 107 IF M THEN SEX="M"; IF F THEN SEX="F"; 108 RUN; NOTE: There were 10 observations read from the data set WORK.MALES. NOTE: There were 9 observations read from the data set WORK.FEMALES. NOTE: The data set WORK.BOTH has 19 observations and 2 variables. NOTE: DATA statement used: 0.06 seconds 0.06 seconds PROC PRINT; 33

16 111 TITLE 'INTERLEAVED DATA SET'; 112 RUN; NOTE: There were 19 observations read from the data set WORK.BOTH. NOTE: PROCEDURE PRINT used: DATA LIBRARY; 115 INPUT NAME $ DATE TEXTBOOK :$12.; 116 CARDS; NOTE: The data set WORK.LIBRARY has 9 observations and 3 variables. NOTE: DATA statement used: 0.14 seconds 0.06 seconds 126 ; 127 RUN; 128 PROC PRINT; 129 TITLE 'LIBRARY TRANSACTIONS DATA SET'; 130 RUN; NOTE: There were 9 observations read from the data set WORK.LIBRARY. NOTE: PROCEDURE PRINT used: DATA NEWCLASS; 133 MERGE CLASS(IN=C) LIBRARY; BY NAME; 134 IF C & LAST.NAME; 135 RUN; NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: There were 9 observations read from the data set WORK.LIBRARY. NOTE: The data set WORK.NEWCLASS has 19 observations and 7 variables. NOTE: DATA statement used: 0.07 seconds 0.07 seconds 34

17 PROC PRINT; 138 TITLE 'FOR EACH STUDENT WHAT IS THE MOST RECENTLY CHECKED BOOK?'; 139 RUN; NOTE: There were 19 observations read from the data set WORK.NEWCLASS. NOTE: PROCEDURE PRINT used: DATA NEWLIB; 142 MERGE LIBRARY(IN=L) CLASS(KEEP=NAME AGE SEX); BY NAME; 143 IF L; 144 RUN; NOTE: There were 9 observations read from the data set WORK.LIBRARY. NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: The data set WORK.NEWLIB has 9 observations and 5 variables. NOTE: DATA statement used: 0.07 seconds 0.07 seconds PROC PRINT; 147 TITLE 'FOR EACH LIBRARY TRANSACTION, WHAT IS THE AGE AND SEX OF 147! CHECKER?'; 148 RUN; NOTE: There were 9 observations read from the data set WORK.NEWLIB. NOTE: PROCEDURE PRINT used: DATA TRANSACT; 154 INPUT NAME $8. SEX $9 AGE HEIGHT WEIGHT; 155 LIST; 35

18 156 CARDS; RULE: ANN F DAVID M WILLIAM NOTE: The data set WORK.TRANSACT has 3 observations and 5 variables. NOTE: DATA statement used: 0.07 seconds 0.07 seconds 160 ; 161 RUN; PROC PRINT; 164 TITLE 'TRANSACTIONS'; 165 RUN; NOTE: There were 3 observations read from the data set WORK.TRANSACT. NOTE: PROCEDURE PRINT used: DATA CLASS2; 168 UPDATE CLASS TRANSACT; BY NAME; 169 NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: There were 3 observations read from the data set WORK.TRANSACT. NOTE: The data set WORK.CLASS2 has 21 observations and 5 variables. NOTE: DATA statement used: 0.07 seconds 0.07 seconds 170 PROC PRINT; 171 TITLE 'NEW UPDATED MASTER FILE'; 172 RUN; NOTE: There were 21 observations read from the data set WORK.CLASS2. NOTE: PROCEDURE PRINT used: 36

19 PROC SORT DATA=CLASS2; BY SEX AGE; 175 NOTE: There were 21 observations read from the data set WORK.CLASS2. NOTE: The data set WORK.CLASS2 has 21 observations and 5 variables. NOTE: PROCEDURE SORT used: 0.05 seconds 0.05 seconds 176 PROC MEANS NOPRINT; BY SEX AGE; 177 VAR HEIGHT WEIGHT; 178 OUTPUT OUT=TEMP MEAN=HEIGHT WEIGHT; 179 NOTE: There were 21 observations read from the data set WORK.CLASS2. NOTE: The data set WORK.TEMP has 11 observations and 6 variables. NOTE: PROCEDURE MEANS used: 0.08 seconds 0.08 seconds 180 PROC PRINT; 181 RUN; NOTE: There were 11 observations read from the data set WORK.TEMP. NOTE: PROCEDURE PRINT used: 0.02 seconds 0.02 seconds DATA _NULL_; SET TEMP; 184 FILE 'MEANS'; 185 PUT SEX $ 5 AGE HEIGHT WEIGHT ; 186 RUN; NOTE: The file 'MEANS' is: File Name=C:\Program Files\SAS Institute\SAS\V8\MEANS, RECFM=V,LRECL=256 NOTE: 11 records were written to the file 'MEANS'. The minimum record length was 32. The maximum record length was

20 NOTE: There were 11 observations read from the data set WORK.TEMP. NOTE: DATA statement used: 0.04 seconds 0.01 seconds ORIGINAL DATA SET 1 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT 1 ALFRED M ALICE F BARBARA F CAROL F HENRY M JAMES M JANE F JANET F JEFFREY M JOHN M JOYCE F JUDY F LOUISE F MARY F PHILIP M ROBERT M RONALD M THOMAS M WILLIAM M SUBSET OF OBSERVATIONS 2 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT 1 ALICE F BARBARA F CAROL F JANE F JANET F JOYCE F JUDY F

21 8 LOUISE F MARY F SUBSET OF VARIABLES 3 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE 1 ALFRED M 14 2 ALICE F 13 3 BARBARA F 13 4 CAROL F 14 5 HENRY M 14 6 JAMES M 12 7 JANE F 12 8 JANET F 15 9 JEFFREY M JOHN M JOYCE F JUDY F LOUISE F MARY F PHILIP M ROBERT M RONALD M THOMAS M WILLIAM M 15 ADDING A NEW VARIABLE 4 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT BIRTHYR 1 ALFRED M ALICE F BARBARA F CAROL F HENRY M

22 6 JAMES M JANE F JANET F JEFFREY M JOHN M JOYCE F JUDY F LOUISE F MARY F PHILIP M ROBERT M RONALD M THOMAS M WILLIAM M COMBINING SEVERAL OPERATIONS 5 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE BIRTHYR 1 ALICE F BARBARA F CAROL F JANE F JANET F JOYCE F JUDY F LOUISE F MARY F MALES--FIRST OUTPUT DATA SET 6 19:57 Thursday, April 3, 2003 Obs NAME 1 ALFRED 2 HENRY 3 JAMES 40

23 4 JEFFREY 5 JOHN 6 PHILIP 7 ROBERT 8 RONALD 9 THOMAS 10 WILLIAM FEMALES--SECOND OUTPUT DATA SET 7 19:57 Thursday, April 3, 2003 Obs NAME 1 ALICE 2 BARBARA 3 CAROL 4 JANE 5 JANET 6 JOYCE 7 JUDY 8 LOUISE 9 MARY CONCATENATED DATA SET 8 19:57 Thursday, April 3, 2003 Obs NAME SEX 1 ALFRED M 2 HENRY M 3 JAMES M 4 JEFFREY M 5 JOHN M 6 PHILIP M 41

24 7 ROBERT M 8 RONALD M 9 THOMAS M 10 WILLIAM M 11 ALICE F 12 BARBARA F 13 CAROL F 14 JANE F 15 JANET F 16 JOYCE F 17 JUDY F 18 LOUISE F 19 MARY F INTERLEAVED DATA SET 9 19:57 Thursday, April 3, 2003 Obs NAME SEX 1 ALFRED M 2 ALICE F 3 BARBARA F 4 CAROL F 5 HENRY M 6 JAMES M 7 JANE F 8 JANET F 9 JEFFREY M 10 JOHN M 11 JOYCE F 12 JUDY F 13 LOUISE F 14 MARY F 15 PHILIP M 16 ROBERT M 17 RONALD M 18 THOMAS M 19 WILLIAM M 42

25 LIBRARY TRANSACTIONS DATA SET 10 19:57 Thursday, April 3, 2003 Obs NAME DATE TEXTBOOK 1 BARBARA 2 ENGLISH 2 CAROL 2 SCIENCE 3 CAROL 3 ENGLISH 4 DONALD 1 ART 5 JAMES 4 ARITHMETIC 6 JOYCE 5 SEWING 7 MARY 2 ART 8 PHILIP 1 MECHANICS 9 WILLIAM 2 SCIENCE FOR EACH STUDENT WHAT IS THE MOST RECENTLY CHECKED BOOK? 11 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT DATE TEXTBOOK 1 ALFRED M ALICE F BARBARA F ENGLISH 4 CAROL F ENGLISH 5 HENRY M JAMES M ARITHMETIC 7 JANE F JANET F JEFFREY M JOHN M JOYCE F SEWING 12 JUDY F LOUISE F MARY F ART 15 PHILIP M MECHANICS 16 ROBERT M RONALD M THOMAS M WILLIAM M SCIENCE 43

26 FOR EACH LIBRARY TRANSACTION,WHAT IS THE AGE AND SEX OF CHECKER? 12 19:57 Thursday, April 3, 2003 Obs NAME DATE TEXTBOOK SEX AGE 1 BARBARA 2 ENGLISH F 13 2 CAROL 2 SCIENCE F 14 3 CAROL 3 ENGLISH F 14 4 DONALD 1 ART. 5 JAMES 4 ARITHMETIC M 12 6 JOYCE 5 SEWING F 11 7 MARY 2 ART F 15 8 PHILIP 1 MECHANICS M 16 9 WILLIAM 2 SCIENCE M 15 TRANSACTIONS 13 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT 1 ANN F DAVID M WILLIAM NEW UPDATED MASTER FILE 14 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT 1 ALFRED M ALICE F ANN F BARBARA F CAROL F DAVID M

27 7 HENRY M JAMES M JANE F JANET F JEFFREY M JOHN M JOYCE F JUDY F LOUISE F MARY F PHILIP M ROBERT M RONALD M THOMAS M WILLIAM M NEW UPDATED MASTER FILE 15 19:57 Thursday, April 3, 2003 Obs SEX AGE _TYPE FREQ_ HEIGHT WEIGHT 1 F F F F F M M M M M M

28 SAS data set SAS data set ( ) SAS 6.12 SAS 8.02 Libname out V6 c:\ Chen \ Data \ V6 ; Libname in V8 c:\ Chen \ Data \ V8 ; Options validvarname = V6; DATA in.example; set out.example; RUN; ( ) SAS ( unix SAS data set *.ssd01) PC "proc cport" "proc cimport" 1. unix "cport" binary PC "cimport" cport filename mylib '/xx/xx/out'; proc cport data=saslib.xx file=mylib; run; "mylib" "/xx/xx" "proc cport" "out" "/xx/xx" "saslib.xx" "saslib" library "xx" 46

29 cimport libname mylib 'c:\sas'; filename in 'c:\sas\out'; proc cimport data=mylib.xx infile=in; run; "mylib" library "c:\sas" "in" "c:\sas\out" "xx" "mylib" library "xx" proc datasets "delete" SAS proc datasets library= ; run; delete one two; " " library "one" "two" 47

30 48

技巧 5: 避免除以 0 的運算在做除的運算時, 先檢查除數的數值, 避免有除以 0 的情況若運算中除數為 0,SAS 會在 LOG 中註記提醒並將運算結果設定為遺漏值, 減慢程式的執行

技巧 5: 避免除以 0 的運算在做除的運算時, 先檢查除數的數值, 避免有除以 0 的情況若運算中除數為 0,SAS 會在 LOG 中註記提醒並將運算結果設定為遺漏值, 減慢程式的執行提升 SAS 效率的小技巧 ( 二 ) 統計分析師嚴友君在使用 SAS 的時候, 效率的考量除了程式運行的時間, 還包括資料佔用的空間暫存記憶體的使用量程式的長度與易讀性等等以下介紹一些初學者容易應用, 且在討論使用 SAS 處理分析資