The MCHP SAS MANUAL - Simulated MB Health Data (Version 1)

         


Sample Data Sets: Simulated MB Health - Version 1

Two versions were created of the program that creates a temporary SAS data set called "test" from the simulated Manitoba Health data available at MCHP, this data can be used to answer the accompanying questions.

Version 1, shown below, does not include labels or formats, so the output shows a list of unlabelled variables (in the CONTENTS output) and unlabelled values (in the PRINT output)

Information regarding record layouts (for raw files) and formats and labels (for all types of files) is normally available to the user as well. Version 2 adds labels (for labeling variables) and formats (for labeling values) from several files . The formats and labels specific to the simulated Manitoba Health raw data set are based on a record layout that describes all 33 variables.

Note: The data contained in the file fivet93m.raw is not available on the online tutorial, but is only available for workshops and courses run throught MCHP.

The following steps are required to create the output for Version 1:

  1. Ensure that the file called "fivet93m.raw" containing values for 5,000 observations is accessible (e.g., on A:\ or C:\ drive).

  2. Enter the following program directly into the SAS Program Editor window (the comments do not need to be entered). Two changes should be made:
    • The statement options linesize=min; does not need to be entered; this was used to reduce the width of the output so that it would fit on the website.
    • The FILENAME statement should be changed to reflect the actual location of the data on your system.

  3. Save the program (e.g., mb_cr.sas; do not save it as fivet93m.raw because this would overwrite the raw data set).

  4. Submit the program for processing.

  5. Check both log and output windows to ensure the program ran accurately. Debug the program, if necessary, saving and submitting it again (clearing the log and output windows first so that only the most recently-submitted versions will appear).


Last modified on