(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). 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
INPUT ( SAS ) 1. (Column input) missing values INPUT PROTEIN 1-2 ENERGY 3-6 PEN 7-8 PIGNO $ 9-13 INITWT 14-16.1 WT4WT 17-19.1 FINALWT 20-23.1 BACKFAT1 24-25.1 BACKFAT 26-27.1 BACKFAT3 28-29.1; CARDS; 142800 326384107204 897182219. 2. (List input) INPUT PROTEIN ENERGY PEN PIGNO $ INITWT WT4WT FINALWT BACKFAT1-BACKFAT3; CARDS; 14 2800 3 26384 10.7 20.4 89.7 1.8 2.2 1.9 14 2800 3 F101 11.3 22.4 100.7 2.3 2.7 2.5. 3. (Formated input) INPUT (PROTEIN ENERGY PEN PIGNO $ INITWT WT4WT FINALWT BACKFAT1-BACKFAT3) (2. 4. 2. $5. 2*3.1 4.1 3*2.1) ; CARDS; 142800 326384107204 897182219. 21
4. (Named input) INPUT PULSE WAIST AGE= SEX=$1.; CARDS; 80 32 AGE=35 SEX=M. : Column pointer control @n- n (@pointvariable,@(expression)) Line pointer control: #n - n / - Line hold specifiers: @ @@ 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
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; 11 22 33 44 55. 4.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
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
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
4.UPDATE (TEST1) OBS NAME AGE GRADE1 ID 1 CHOU 31 90 1 2 WANG 30 96 2 3 SHUE 34 99 3 4 LIN 28 88 4 (TEST2) OBS NAME GRADE1 RANK3 ID 1 92 1 2 111 2 3 LILY 5559 4 4 90 4 5 LEE 99 999 5 UPDATA TEST1 TEST2; BY ID; OBS ID NAME AGE GRADE1 RANK3 1 1 CHOU 31 92 2 2 30 111 3 3 SHUE 34 99 4 4 LILY 28 90 555 5 5 LEE 89 999 26
1.PUT (1). DATA CLASS; INPUT NAME $ AGE SEX HEIHGT WEIGHT; PUT NAME 6-15 AGE 17-19 SEX 20-21 HEIGHT 23-30.1 WEIGHT 32-35.1; 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 21-26 HEIGHT 28-40.2 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
FILE CHICKBW8; PUT WBNO 1-5 SEX $ 7 BODYWT 9-14.1; 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 9-14.1; 28
NOTE: Copyright (c) 1999-2001 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 0023147002. 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 /********************************************************/ 17 18 DATA CLASS; 19 INPUT NAME $ 1-8 SEX $ 11 AGE 13-14 20 HEIGHT 16-19 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
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 46 47 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 50 51 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 53 54 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 57 58 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
NOTE: DATA statement used: 0.07 seconds 0.07 seconds 60 61 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 64 65 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 67 68 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 71 72 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
NOTE: DATA statement used: 0.06 seconds 0.06 seconds 77 78 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: 81 82 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 87 88 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 91 92 PROC PRINT DATA=FEMALES; 93 TITLE 'FEMALES--SECOND OUTPUT DATA SET'; 94 RUN; 32
NOTE: There were 9 observations read from the data set WORK.FEMALES. NOTE: PROCEDURE PRINT used: 95 96 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 100 101 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 104 105 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 109 110 PROC PRINT; 33
111 TITLE 'INTERLEAVED DATA SET'; 112 RUN; NOTE: There were 19 observations read from the data set WORK.BOTH. NOTE: PROCEDURE PRINT used: 113 114 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: 131 132 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
136 137 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: 140 141 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 145 146 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: 149 150 151 152 153 DATA TRANSACT; 154 INPUT NAME $8. SEX $9 AGE HEIGHT WEIGHT; 155 LIST; 35
156 CARDS; RULE: ----+----1----+----2----+----3----+----4----+----5----+----6-- 157 ANN F 13 64 93 158 DAVID M 13 70 120 159 WILLIAM.. 67 120 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; 162 163 PROC PRINT; 164 TITLE 'TRANSACTIONS'; 165 RUN; NOTE: There were 3 observations read from the data set WORK.TRANSACT. NOTE: PROCEDURE PRINT used: 166 167 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
173 174 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 182 183 DATA _NULL_; SET TEMP; 184 FILE 'MEANS'; 185 PUT SEX $ 5 AGE 10-11 HEIGHT 16-21.2 WEIGHT 26-32.2; 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 32. 37
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 14 69.0 112.5 2 ALICE F 13 56.5 84.0 3 BARBARA F 13 65.3 98.0 4 CAROL F 14 62.8 102.5 5 HENRY M 14 63.5 102.5 6 JAMES M 12 57.3 83.0 7 JANE F 12 59.8 84.5 8 JANET F 15 62.5 112.5 9 JEFFREY M 13 62.5 84.0 10 JOHN M 12 59.0 99.5 11 JOYCE F 11 51.3 50.5 12 JUDY F 14 64.3 90.0 13 LOUISE F 12 56.3 77.0 14 MARY F 15 66.5 112.0 15 PHILIP M 16 72.0 150.0 16 ROBERT M 12 64.8 128.0 17 RONALD M 15 67.0 133.0 18 THOMAS M 11 57.5 85.0 19 WILLIAM M 15 66.5 112.0 SUBSET OF OBSERVATIONS 2 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT 1 ALICE F 13 56.5 84.0 2 BARBARA F 13 65.3 98.0 3 CAROL F 14 62.8 102.5 4 JANE F 12 59.8 84.5 5 JANET F 15 62.5 112.5 6 JOYCE F 11 51.3 50.5 7 JUDY F 14 64.3 90.0 38
8 LOUISE F 12 56.3 77.0 9 MARY F 15 66.5 112.0 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 13 10 JOHN M 12 11 JOYCE F 11 12 JUDY F 14 13 LOUISE F 12 14 MARY F 15 15 PHILIP M 16 16 ROBERT M 12 17 RONALD M 15 18 THOMAS M 11 19 WILLIAM M 15 ADDING A NEW VARIABLE 4 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT BIRTHYR 1 ALFRED M 14 69.0 112.5 1963 2 ALICE F 13 56.5 84.0 1964 3 BARBARA F 13 65.3 98.0 1964 4 CAROL F 14 62.8 102.5 1963 5 HENRY M 14 63.5 102.5 1963 39
6 JAMES M 12 57.3 83.0 1965 7 JANE F 12 59.8 84.5 1965 8 JANET F 15 62.5 112.5 1962 9 JEFFREY M 13 62.5 84.0 1964 10 JOHN M 12 59.0 99.5 1965 11 JOYCE F 11 51.3 50.5 1966 12 JUDY F 14 64.3 90.0 1963 13 LOUISE F 12 56.3 77.0 1965 14 MARY F 15 66.5 112.0 1962 15 PHILIP M 16 72.0 150.0 1961 16 ROBERT M 12 64.8 128.0 1965 17 RONALD M 15 67.0 133.0 1962 18 THOMAS M 11 57.5 85.0 1966 19 WILLIAM M 15 66.5 112.0 1962 COMBINING SEVERAL OPERATIONS 5 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE BIRTHYR 1 ALICE F 13 1964 2 BARBARA F 13 1964 3 CAROL F 14 1963 4 JANE F 12 1965 5 JANET F 15 1962 6 JOYCE F 11 1966 7 JUDY F 14 1963 8 LOUISE F 12 1965 9 MARY F 15 1962 MALES--FIRST OUTPUT DATA SET 6 19:57 Thursday, April 3, 2003 Obs NAME 1 ALFRED 2 HENRY 3 JAMES 40
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
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
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 14 69.0 112.5. 2 ALICE F 13 56.5 84.0. 3 BARBARA F 13 65.3 98.0 2 ENGLISH 4 CAROL F 14 62.8 102.5 3 ENGLISH 5 HENRY M 14 63.5 102.5. 6 JAMES M 12 57.3 83.0 4 ARITHMETIC 7 JANE F 12 59.8 84.5. 8 JANET F 15 62.5 112.5. 9 JEFFREY M 13 62.5 84.0. 10 JOHN M 12 59.0 99.5. 11 JOYCE F 11 51.3 50.5 5 SEWING 12 JUDY F 14 64.3 90.0. 13 LOUISE F 12 56.3 77.0. 14 MARY F 15 66.5 112.0 2 ART 15 PHILIP M 16 72.0 150.0 1 MECHANICS 16 ROBERT M 12 64.8 128.0. 17 RONALD M 15 67.0 133.0. 18 THOMAS M 11 57.5 85.0. 19 WILLIAM M 15 66.5 112.0 2 SCIENCE 43
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 13 64 93 2 DAVID M 13 70 120 3 WILLIAM. 67 120 NEW UPDATED MASTER FILE 14 19:57 Thursday, April 3, 2003 Obs NAME SEX AGE HEIGHT WEIGHT 1 ALFRED M 14 69.0 112.5 2 ALICE F 13 56.5 84.0 3 ANN F 13 64.0 93.0 4 BARBARA F 13 65.3 98.0 5 CAROL F 14 62.8 102.5 6 DAVID M 13 70.0 120.0 44
7 HENRY M 14 63.5 102.5 8 JAMES M 12 57.3 83.0 9 JANE F 12 59.8 84.5 10 JANET F 15 62.5 112.5 11 JEFFREY M 13 62.5 84.0 12 JOHN M 12 59.0 99.5 13 JOYCE F 11 51.3 50.5 14 JUDY F 14 64.3 90.0 15 LOUISE F 12 56.3 77.0 16 MARY F 15 66.5 112.0 17 PHILIP M 16 72.0 150.0 18 ROBERT M 12 64.8 128.0 19 RONALD M 15 67.0 133.0 20 THOMAS M 11 57.5 85.0 21 WILLIAM M 15 67.0 120.0 NEW UPDATED MASTER FILE 15 19:57 Thursday, April 3, 2003 Obs SEX AGE _TYPE FREQ_ HEIGHT WEIGHT 1 F 11 0 1 51.3000 50.500 2 F 12 0 2 58.0500 80.750 3 F 13 0 3 61.9333 91.667 4 F 14 0 2 63.5500 96.250 5 F 15 0 2 64.5000 112.250 6 M 11 0 1 57.5000 85.000 7 M 12 0 3 60.3667 103.500 8 M 13 0 2 66.2500 102.000 9 M 14 0 2 66.2500 107.500 10 M 15 0 2 67.0000 126.500 11 M 16 0 1 72.0000 150.000 45
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
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
48