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 13 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: 15:22 Thursday, Observation Length: 128 August 12, 1999 Last Modified: 15:22 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: 54 First Data Page: 1 Max Obs per Page: 95 Obs in First Data Page: 56 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 Format Label ---------------------------------------------------------------- 30 ABSTYPE Char 1 125 $ABSTYPL. HOSPITAL DISCHARGE ABSTRACT TYPE 3 AGE Num 8 0 AGE OF PATIENT AT DISCHARGE 12 CHARYES Char 2 102 $CHARL. HIGH RISK DIAGNOSIS 27 CMG Char 3 121 CASE MIX GROUP 31 DAYSFRPR Num 8 64 DAYS FROM PREVIOUS ADMISSION 32 DAYSTOR Num 8 72 DAYS TO READMISSION 23 DEATHSEP Num 8 40 DAYS FROM HSP SEP TO DEATH 9 DIAG01 Char 5 92 PRIMARY DIAGNOSIS 10 DIAG02 Char 5 97 SECONDARY DIAGNOSIS 18 DISCRE Char 1 110 $DISCREL. DISCRETIONARY DIAGNOSIS 16 DRG Char 3 106 DIAGNOSIS RELATED GROUP 24 DRGRGN Char 5 115 DRG REFINEMENT GROUP NUMBER 15 DRGWT Num 8 32 DRG WEIGHT 2 GENDER Char 1 85 $GENDERL. SEX OF PATIENT 33 ICD17BRK Char 2 126 $ICD17L. ICD-9-CM DIAGS (1-999) IN 17 CATEGORIES 21 INCDR Char 1 113 $INCDRL. INCOME QUINTILE BASED ON MEAN HSEHLD INC 4 LOS Num 8 8 LENGTH OF HOSPITAL STAY The SAS System 14 14:07 Thursday, August 12, 1999 The CONTENTS Procedure -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos Format Label ---------------------------------------------------------------- 1 NCASE Char 5 80 CASE NUMBER 5 NDAYICU Num 8 16 N DAYS IN INTENSIVE CARE 8 OP01 Char 4 88 PRIMARY OPERATIVE PROCEDURE 26 RDRGWT Num 8 48 REFINED DRG WEIGHT 20 REGIONH Char 1 112 $REGIONL. REGION OF HOSPITAL 19 REGIONRE Char 1 111 $REGIONL. REGION OF PT RESIDENCE 14 RISKDRG Char 1 105 RISK SCORE OF ADVERSE EVENT W ADM. 28 RIW Num 8 56 RESOURCE INTENSITY WEIGHT 13 SCHEDULE Char 1 104 $SCHEDL. SCHEDULED ADMISSION 25 SEVERDRG Char 1 120 $SEVRL. DRG SEVERITY CODE 11 TOTCHAR Num 8 24 WTED SCORE HIGH RISK DIAG INDEX (CCI) 6 TRANADM Char 1 86 $TRNADML. ON ADMISSION, PT TRANSFERRED FROM 7 TRANDIS Char 1 87 $TRNDISL. ON DISCHARGE, PT TRANSFERRED TO 29 TREATY Char 1 124 $TREATYL. TREATY FIRST NATIONS 22 TYPEHSP Char 1 114 $TYPEHL. TYPE OF HOSPITAL 17 WBURG Char 1 109 $WBURGL. WENNBERG VARIATION CODE The SAS System 15 14:07 Thursday, August 12, 1999 Obs NCASE GENDER AGE LOS NDAYICU TRANADM 1 00001 2. FEMALE 38 8 0 1. TR.FROM HOSP 2 00002 2. FEMALE 18 9 0 0. OTHER,NO TR. 3 00003 1. MALE 0 4 1 0. OTHER,NO TR. 4 00004 1. MALE 0 2 0 0. OTHER,NO TR. 5 00005 2. FEMALE 65 2 0 0. OTHER,NO TR. 6 00006 2. FEMALE 28 2 0 0. OTHER,NO TR. 7 00007 1. MALE 21 3 0 0. OTHER,NO TR. 8 00008 1. MALE 0 5 0 0. OTHER,NO TR. 9 00009 2. FEMALE 28 6 0 0. OTHER,NO TR. 10 00010 2. FEMALE 65 12 0 0. OTHER,NO TR. Obs TRANDIS OP01 DIAG01 DIAG02 TOTCHAR CHARYES 1 1. TR.TO HOSP 2751 86509 86601 0 00 2 0. OTHER, NO TR. 8866 4538 0 00 3 0. OTHER, NO TR. V3000 7701 0 00 4 0. OTHER, NO TR. V3000 0 00 5 1. TR.TO HOSP 2754 20280 2 01 6 0. OTHER, NO TR. 7890 6149 0 00 7 0. OTHER, NO TR. 7890 0 00 8 0. OTHER, NO TR. V3001 7686 0 00 9 0. OTHER, NO TR. 741 64881 V270 0 00 10 0. OTHER, NO TR. 2948 2449 0 00 Obs SCHEDULE RISKDRG DRGWT DRG 1 1. SURG NOT SCHEDULE 2 1.2472 398 2 1. SURG NOT SCHEDULE 3 0.5886 131 3 2. SURG SCHEDULE 3 1.7896 389 4 2. SURG SCHEDULE 1 0.2218 391 5 2. SURG SCHEDULE 2 0.9396 296 6 1. SURG NOT SCHEDULE 2 0.5284 183 7 1. SURG NOT SCHEDULE 2 0.5284 183 8 2. SURG SCHEDULE 1 0.2218 391 9 1. SURG NOT SCHEDULE 2 0.7099 371 10 1. SURG NOT SCHEDULE 1 0.8932 429 The SAS System 16 14:07 Thursday, August 12, 1999 Obs WBURG DISCRE REGIONRE REGIONH 1 3. HIGH VAR.MED.COND. 0. OTHER 6-THOMPSON 7-WESTMAN 2 3. HIGH VAR.MED.COND. 0. OTHER 6-THOMPSON 7-WESTMAN 3 0. OTHER 6-THOMPSON 7-WESTMAN 4 0. OTHER 6-THOMPSON 7-WESTMAN 5 3. HIGH VAR.MED.COND. 0. OTHER 6-THOMPSON 7-WESTMAN 6 3. HIGH VAR.MED.COND. 0. OTHER 6-THOMPSON 7-WESTMAN 7 3. HIGH VAR.MED.COND. 0. OTHER 6-THOMPSON 7-WESTMAN 8 0. OTHER 6-THOMPSON 7-WESTMAN 9 4. OBSTETRIC 0. OTHER 6-THOMPSON 8-WINNIPEG 10 3. HIGH VAR.MED.COND. 0. OTHER 6-THOMPSON 8-WINNIPEG Obs INCDR TYPEHSP DEATHSEP DRGRGN SEVERDRG 1 3. OTHER MANITOBA 9999 3981 1. MODERATE CC 2 3. OTHER MANITOBA 9999 1300 0. NO/MINOR CC 3 3. OTHER MANITOBA 9999 3913 3. CATASTROPHIC CC 4 3. OTHER MANITOBA 9999 3910 0. NO/MINOR CC 5 3. OTHER MANITOBA 9999 2961 1. MODERATE CC 6 3. OTHER MANITOBA 9999 1820 0. NO/MINOR CC 7 3. OTHER MANITOBA 9999 1820 0. NO/MINOR CC 8 3. OTHER MANITOBA 9999 3911 1. MODERATE CC 9 2. WPG NON-TEACH 9999 3700 0. NO/MINOR CC 10 2. WPG NON-TEACH 9999 4290 0. NO/MINOR CC Obs RDRGWT CMG RIW TREATY ABSTYPE 1 0.9231 710 0.7473 0. NON-TREATY ADULT/CHILD 2 0.6849 202 0.6744 0. NON-TREATY ADULT/CHILD 3 . 645 0.7187 0. NON-TREATY NEWBORN/STILLBORN 4 . 648 0.2262 0. NON-TREATY NEWBORN/STILLBORN 5 0.9183 485 0.7634 0. NON-TREATY ADULT/CHILD 6 0.5569 294 0.4398 0. NON-TREATY ADULT/CHILD 7 0.5569 294 0.4398 0. NON-TREATY ADULT/CHILD 8 . 648 0.2262 0. NON-TREATY NEWBORN/STILLBORN 9 0.6612 604 1.0765 0. NON-TREATY OBSTETRIC 10 1.2336 780 2.5254 0. NON-TREATY ADULT/CHILD The SAS System 17 14:07 Thursday, August 12, 1999 Obs DAYSFRPR DAYSTOR ICD17BRK 1 999 274 17.INJURY/POISONING 2 999 305 7.CIRCULATORY SYSTEM 3 999 999 0 4 999 316 0 5 999 324 3.ENDOCRINE/NUTR/MET/IMM 6 999 318 16.SYMPTOMS/SIGNS/ILL-DEF 7 999 337 16.SYMPTOMS/SIGNS/ILL-DEF 8 999 335 0 9 999 999 11.COMPL.PREGNANCY 10 999 999 5.MENTAL DISORDERS