Home    Contents

GENERAL GUIDELINES:
Windows in SAS
File management

The SAS Program
Program syntax
Debugging tips

---

 USING SAS PROGRAMMING TO: 
   

1. Prepare the data set 
   Types of data 
   Example programs    
    
2. View the data
   SAS Procedures
  
3. Explore the data  
   Numeric statistics    
   Frequency tables    
    
4. Manipulate the data  
   Basic techniques    
   New variables
  
5. Adding Variables and 
Observations to Data Sets
   The SET Statement
   The MERGE Statement

6. Data Processing
   ARRAY Statement
   Do Loops
   By-Group Processing
   RETAIN Statement

  
NON-PROGRAMMING 
      Alternatives

 
SAMPLE DATA SETS: 
 Height/weight
 Height/weight/region
 Simulated clinical data 
 Simulated Manitoba Health 
    

The SAS System 4 14:07 Thursday, August 12, 1999 The CONTENTS Procedure Data Set Name: WORK.TEST Observations: 5000 Member Type: DATA Variables: 33 Engine: V7 Indexes: 0 Created: 14:35 Thursday, Observation Length: 136 August 12, 1999 Last Modified: 14:35 Thursday, Deleted Observations: 0 August 12, 1999 Protection: Compressed: NO Data Set Type: Sorted: NO Label: -----Engine/Host Dependent Information----- Data Set Page Size: 12288 Number of Data Set Pages: 56 First Data Page: 1 Max Obs per Page: 90 Obs in First Data Page: 59 Number of Data Set Repairs: 0 File Name: C:\TEMP\SAS Temporary Files\_TD180\test.sas7bdat Release Created: 7.00.00P Host Created: WIN_NT -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos ------------------------------------ 30 ABSTYPE Char 1 132 3 AGE Num 8 0 12 CHARYES Char 2 110 27 CMG Char 3 128 31 DAYSFRPR Num 8 72 32 DAYSTOR Num 8 80 23 DEATHSEP Num 8 48 9 DIAG01 Char 5 100 10 DIAG02 Char 5 105 18 DISCRE Num 8 40 16 DRG Char 3 114 24 DRGRGN Char 5 122 15 DRGWT Num 8 32 2 GENDER Char 1 93 33 ICD17BRK Char 2 133 21 INCDR Char 1 120 4 LOS Num 8 8 1 NCASE Char 5 88 5 NDAYICU Num 8 16 8 OP01 Char 4 96 The SAS System 5 14:07 Thursday, August 12, 1999 The CONTENTS Procedure -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos ------------------------------------ 26 RDRGWT Num 8 56 20 REGIONH Char 1 119 19 REGIONRE Char 1 118 14 RISKDRG Char 1 113 28 RIW Num 8 64 13 SCHEDULE Char 1 112 25 SEVERDRG Char 1 127 11 TOTCHAR Num 8 24 6 TRANADM Char 1 94 7 TRANDIS Char 1 95 29 TREATY Char 1 131 22 TYPEHSP Char 1 121 17 WBURG Char 1 117 The SAS System 6 14:07 Thursday, August 12, 1999 S N T T T C C R G D R R D D O H H I N E A A A I I T A E S D C N Y N N O A A C R D K R O A D A L I A D P G G H Y U D G D b S E G O C D I 0 0 0 A E L R W R s E R E S U M S 1 1 2 R S E G T G 1 00001 2 38 8 0 1 1 2751 86509 86601 0 00 1 2 1.2472 398 2 00002 2 18 9 0 0 0 8866 4538 0 00 1 3 0.5886 131 3 00003 1 0 4 1 0 0 V3000 7701 0 00 2 3 1.7896 389 4 00004 1 0 2 0 0 0 V3000 0 00 2 1 0.2218 391 5 00005 2 65 2 0 0 1 2754 20280 2 01 2 2 0.9396 296 6 00006 2 28 2 0 0 0 7890 6149 0 00 1 2 0.5284 183 7 00007 1 21 3 0 0 0 7890 0 00 1 2 0.5284 183 8 00008 1 0 5 0 0 0 V3001 7686 0 00 2 1 0.2218 391 9 00009 2 28 6 0 0 0 741 64881 V270 0 00 1 2 0.7099 371 10 00010 2 65 12 0 0 0 2948 2449 0 00 1 1 0.8932 429 R D S D I E R T E E A A D C D G E Y A D V R T B Y A D W I I G I P T R E D R S S Y 1 B S O I N E H G R R E T F S 7 O U C N O C H S R D G C R A Y R T B b R R R N D S E G R W M I T P P O R s G E E H R P P N G T G W Y E R R K 1 3 0 6 7 3 9999 3981 1 0.9231 710 0.7473 0 1 999 274 17 2 3 0 6 7 3 9999 1300 0 0.6849 202 0.6744 0 1 999 305 7 3 0 6 7 3 9999 3913 3 . 645 0.7187 0 4 999 999 0 4 0 6 7 3 9999 3910 0 . 648 0.2262 0 4 999 316 0 5 3 0 6 7 3 9999 2961 1 0.9183 485 0.7634 0 1 999 324 3 6 3 0 6 7 3 9999 1820 0 0.5569 294 0.4398 0 1 999 318 16 7 3 0 6 7 3 9999 1820 0 0.5569 294 0.4398 0 1 999 337 16 8 0 6 7 3 9999 3911 1 . 648 0.2262 0 4 999 335 0 9 4 0 6 8 2 9999 3700 0 0.6612 604 1.0765 0 3 999 999 11 10 3 0 6 8 2 9999 4290 0 1.2336 780 2.5254 0 1 999 999 5