Data from the California Office of Statewide Health Planning and Development: Hospital Annual Disclosure Report


Medium:

RCF

Contents and Scope:

The files are resident on the RCF account ~graddy. in a subdirectory called UNITREE. To see the files in this subdirectory, enter:

Each directory contains data from one survey. OSHPD identifies surveys with letters; this collection begins with 'f' (which begins in 1979). The files can contain data that may come from three different years, due to different reporting periods among hospitals. Data through 1990-92 (letter 'q') is in the form of SAS data sets. Data after 1992 (letter 'r' and following) and also some data from 1990-92 ('q') are in raw (ascii) format.

Up through the first half of 1992 an older version of the survey was used. From mid-1992 until the present, a revised survey has been used. The surveys are quite similar, allowing some time-series or other analysis over time, as most of the variables are the same. In the listing below, you can see that the 1992-93 survey section has files stored in two directories, which correspond to the two different surveys: original, used in the first half of this time period, and revised, used in the second half of this time period and thereafter.

Names of directories containing raw data have the word 'raw' implanted.

Format:

SAS Data Sets (can be used in UNIX only) through 1992; ASCII data after 1992 (and some 1990-92 data also ASCII)

Access Instructions:

Documentation/Code Book:

Available from OSHPD in Sacramento.

Owner/Coordinator:

Anonymous; contact the ITS Statistics Consultant with questions/comments

Additional Details regarding Contents of Files:

    Subdirectories and the years they cover are as follows:

      SAS Data Sets
      years
      f6
      1979-81
      g7
      1980-82
      h8
      1981-83
      i9
      1982-84
      j10
      1983-85
      k11
      1984-86
      l12
      1985-87
      m13
      1986-88
      n14
      1987-89
      o15
      1988-90
      p16
      1989-91
      q17
      1990-92
      ASCII Data
      years
      q17raw
      1991-92
      r18raw/original
      1992-93
      r18raw/revised
      1992-93
      s19raw
      1993-94

    SAS Data Sets. Within each directory containing SAS Data Sets are separate files associated with survey pages. All relevant files are named according to the following convention: hXXpYYZ.ssd01 The extension .ssd01 denotes that the files are SAS data sets (not transport files), and as such must be moved to UNIX disk before being used in an analysis. In the file names, the XX refers to the OSHPD sequence number for the study (and this will match the UniTree directory number); the YY refers to the survey page number; Z refers to the column designation if a page of the survey form contains more than one.

    For example, file h15p21b.ssd01 denotes data entered from page 21 of survey 15 (OSHPD also uses the letter 'o' to designate this survey), column b.

    ASCII Data files. Beginning in 1991, the files in this collection are available in ASCII (raw data) form. They may be read using SAS, SPSS, or other statistics package programs that can read in raw data. SAS and SPSS can make use of the data directly from UniTree, through the use of PIPEs. Other packages will require that you copy the data from UniTree to local UNIX disk for processing. See the SAS or SPSS documentation for information on using PIPEs to read UniTree-based data.

    The raw (ASCII) files are named using the original OSHPD conventions. For most files, the code has the form sh.hXX.pYYZ.ca For data in study 18 (letter r) that used the revised survey form (see below), the form would be sh.hrXX.pYYZ.ca, with the 'r' in 'hrXX' designating 'revised'. In the file names, the XX refers to the OSHPD sequence number for the study (and this will match the UniTree directory number); the YY refers to the survey page number; Z refers to the column designation if a page of the survey form contains more than one.

    For example, file sh.h19.p17a.ca denotes data entered from page 17 of survey 19 (OSHPD also uses the letter 's' to designate this survey), column a.

    NOTE on the ASCII files: The ASCII files in these directories seem to have a garbage character (^C) on a separate line after the end of the data. This will probably not affect the reading of the 'real' data, but it may cause your statistics software to issue warning messages. There is a technique for cleaning this up, explained in a document called "Telling a Stat Package to Ignore Garbage Data Lines", which is found in:

    Cautions:
    • In the ASCII (raw) data, each fiscal-year study may not include all data pertaining to that year. It is often the case that some information belonging to a particular year's study is posted to OSHPD data files for the subsequent year. Because of this, you may need to read the data from at least two years to get complete information for any particular study 'cycle'.
    • Since the survey varies somewhat from year to year, you may need a copy of the survey instrument and/or codebook for each survey year that you plan to use. These can be obtained directly from OSHPD.


    Following is a complete list of the files in each directory.



      Files for 1979-1981 in /users/graddy/f6:
      
        h6p00.ssd01 h6p01.ssd01 h6p02.ssd01 h6p03a.ssd01 h6p03b.ssd01 h6p04.ssd01 h6p05.ssd01 h6p08.ssd01 h6p09.ssd01 h6p12.ssd01 h6p16.ssd01 h6p21a.ssd01 h6p21b.ssd01

      Files for 1980-1982 in /users/graddy/g7:
        h7p00.ssd01 h7p01.ssd01 h7p02.ssd01 h7p03a.ssd01 h7p03b.ssd01 h7p04.ssd01 h7p05.ssd01 h7p08.ssd01 h7p09.ssd01 h7p12.ssd01 h7p16.ssd01 h7p21a.ssd01 h7p21b.ssd01

      Files for 1981-1983 in /users/graddy/h8:
        h8_pg00.ssd01 h8_pg01.ssd01 h8_pg01d.ssd01 h8_pg02.ssd01 h8_pg03a.ssd01 h8_pg03b.ssd01 h8_pg04.ssd01 h8_pg05.ssd01 h8_pg051.ssd01 h8_pg06.ssd01 h8_pg07.ssd01 h8_pg08.ssd01 h8_pg09.ssd01 h8_pg10.ssd01 h8_pg10a.ssd01 h8_pg12.ssd01 h8_pg121.ssd01 h8_pg14.ssd01 h8_pg15.ssd01 h8_pg16.ssd01 h8_pg17a.ssd01 h8_pg17b.ssd01 h8_pg18a.ssd01 h8_pg18b.ssd01 h8_pg19a.ssd01 h8_pg19b.ssd01 h8_pg19c.ssd01 h8_pg20a.ssd01 h8_pg20b.ssd01 h8_pg20c.ssd01 h8_pg20d.ssd01 h8_pg20e.ssd01 h8_pg21a.ssd01 h8_pg21b.ssd01 h8_pg22a.ssd01 h8_pg22b.ssd01

      Files for 1982-1984 in /users/graddy/i9:
        h9_pg00.ssd01 h9_pg01.ssd01 h9_pg02.ssd01 h9_pg03a.ssd01 h9_pg03b.ssd01 h9_pg04.ssd01 h9_pg05.ssd01 h9_pg051.ssd01 h9_pg06.ssd01 h9_pg07.ssd01 h9_pg08.ssd01 h9_pg09.ssd01 h9_pg10.ssd01 h9_pg10a.ssd01 h9_pg12.ssd01 h9_pg121.ssd01 h9_pg14.ssd01 h9_pg15.ssd01 h9_pg16.ssd01 h9_pg17a.ssd01 h9_pg17b.ssd01 h9_pg18a.ssd01 h9_pg18b.ssd01 h9_pg19a.ssd01 h9_pg19b.ssd01 h9_pg19c.ssd01 h9_pg20a.ssd01 h9_pg20b.ssd01 h9_pg20c.ssd01 h9_pg20d.ssd01 h9_pg20e.ssd01 h9_pg21a.ssd01 h9_pg21b.ssd01 h9_pg22a.ssd01 h9_pg22b.ssd01

      Files for 1983-1985 in /users/graddy/j10:
        h10pg00.ssd01 h10pg01.ssd01 h10pg02.ssd01 h10pg03a.ssd01 h10pg03b.ssd01 h10pg04.ssd01 h10pg05.ssd01 h10pg051.ssd01 h10pg06.ssd01 h10pg07.ssd01 h10pg08.ssd01 h10pg09.ssd01 h10pg10.ssd01 h10pg10a.ssd01 h10pg11.ssd01 h10pg12.ssd01 h10pg121.ssd01 h10pg14.ssd01 h10pg15.ssd01 h10pg16.ssd01 h10pg17a.ssd01 h10pg17b.ssd01 h10pg18a.ssd01 h10pg18b.ssd01 h10pg19a.ssd01 h10pg19b.ssd01 h10pg19c.ssd01 h10pg20a.ssd01 h10pg20b.ssd01 h10pg20c.ssd01 h10pg20d.ssd01 h10pg20e.ssd01 h10pg21a.ssd01 h10pg21b.ssd01 h10pg22a.ssd01 h10pg22b.ssd01

      Files for 1984-1986 in /users/graddy/k11:
        h11ap00.ssd01 h11ap01.ssd01 h11ap02.ssd01 h11ap03a.ssd01 h11ap03b.ssd01 h11ap04.ssd01 h11ap05.ssd01 h11ap051.ssd01 h11ap06.ssd01 h11ap07.ssd01 h11ap08.ssd01 h11ap09.ssd01 h11ap10.ssd01 h11ap10a.ssd01 h11ap11.ssd01 h11ap12.ssd01 h11ap121.ssd01 h11ap14.ssd01 h11ap15.ssd01 h11ap16.ssd01 h11ap17a.ssd01 h11ap17b.ssd01 h11ap18a.ssd01 h11ap18b.ssd01 h11ap19a.ssd01 h11ap19b.ssd01 h11ap19c.ssd01 h11ap20a.ssd01 h11ap20b.ssd01 h11ap20c.ssd01 h11ap20d.ssd01 h11ap20e.ssd01 h11ap21a.ssd01 h11ap21b.ssd01 h11ap22a.ssd01 h11ap22b.ssd01 h11bp00.ssd01 h11bp01.ssd01 h11bp02.ssd01 h11bp03a.ssd01 h11bp03b.ssd01 h11bp03c.ssd01 h11bp04.ssd01 h11bp05.ssd01 h11bp051.ssd01 h11bp06.ssd01 h11bp07.ssd01 h11bp08.ssd01 h11bp09.ssd01 h11bp10.ssd01 h11bp12.ssd01 h11bp14.ssd01 h11bp15.ssd01 h11bp16.ssd01 h11bp17a.ssd01 h11bp17b.ssd01 h11bp18a.ssd01 h11bp18b.ssd01 h11bp19a.ssd01 h11bp19b.ssd01 h11bp19c.ssd01 h11bp1a.ssd01 h11bp20a.ssd01 h11bp20b.ssd01 h11bp20c.ssd01 h11bp20d.ssd01 h11bp21a.ssd01 h11bp21b.ssd01 h11bp22a.ssd01 h11bp22b.ssd01 h11p.ssd01 h11p00.ssd01 h11p01.ssd01 h11p02.ssd01 h11p03a.ssd01 h11p03b.ssd01 h11p04.ssd01 h11p05.ssd01 h11p051.ssd01 h11p06.ssd01 h11p07.ssd01 h11p08.ssd01 h11p09.ssd01 h11p10.ssd01 h11p10a.ssd01 h11p12.ssd01 h11p14.ssd01 h11p15.ssd01 h11p16.ssd01 h11p17a.ssd01 h11p17b.ssd01 h11p18a.ssd01 h11p18b.ssd01 h11p19a.ssd01 h11p19b.ssd01 h11p19c.ssd01 h11p20a.ssd01 h11p20b.ssd01 h11p20c.ssd01 h11p20d.ssd01 h11p21a.ssd01 h11p21b.ssd01 h11p22a.ssd01 h11p22b.ssd01 h11pg01t.ssd01

      Files for 1985-1987 in /users/graddy/l12:
        h12p00.ssd01 h12p01.ssd01 h12p02.ssd01 h12p03a.ssd01 h12p03b.ssd01 h12p03c.ssd01 h12p04.ssd01 h12p05.ssd01 h12p051.ssd01 h12p06.ssd01 h12p07.ssd01 h12p08.ssd01 h12p09.ssd01 h12p10.ssd01 h12p12.ssd01 h12p14.ssd01 h12p15.ssd01 h12p16.ssd01 h12p17a.ssd01 h12p17b.ssd01 h12p18a.ssd01 h12p18b.ssd01 h12p19a.ssd01 h12p19b.ssd01 h12p19c.ssd01 h12p20a.ssd01 h12p20b.ssd01 h12p20c.ssd01 h12p20d.ssd01 h12p21a.ssd01 h12p21b.ssd01 h12p22a.ssd01 h12p22b.ssd01

      Files for 1986-1988 in /users/graddy/m13:
        h13p00.ssd01 h13p01.ssd01 h13p02.ssd01 h13p03a.ssd01 h13p03b.ssd01 h13p03c.ssd01 h13p04.ssd01 h13p05.ssd01 h13p051.ssd01 h13p06.ssd01 h13p07.ssd01 h13p08.ssd01 h13p09.ssd01 h13p10.ssd01 h13p12.ssd01 h13p14.ssd01 h13p15.ssd01 h13p16.ssd01 h13p17a.ssd01 h13p17b.ssd01 h13p18a.ssd01 h13p18b.ssd01 h13p19a.ssd01 h13p19b.ssd01 h13p19c.ssd01 h13p20a.ssd01 h13p20b.ssd01 h13p20c.ssd01 h13p20d.ssd01 h13p21a.ssd01 h13p21b.ssd01 h13p22a.ssd01 h13p22b.ssd01

      Files for 1987-1989 in /users/graddy/n14:
        h14p00.ssd01 h14p01.ssd01 h14p02.ssd01 h14p03a.ssd01 h14p03b.ssd01 h14p03c.ssd01 h14p04.ssd01 h14p05a.ssd01 h14p05b.ssd01 h14p08.ssd01 h14p09.ssd01 h14p12.ssd01 h14p16.ssd01 h14p21a.ssd01 h14p21b.ssd01

      Files for 1988-1990 in /users/graddy/o15:
        h15p00.ssd01 h15p01.ssd01 h15p02.ssd01 h15p03a.ssd01 h15p03b.ssd01 h15p03c.ssd01 h15p04.ssd01 h15p05a.ssd01 h15p05b.ssd01 h15p08.ssd01 h15p09.ssd01 h15p12.ssd01 h15p16.ssd01 h15p21a.ssd01 h15p21b.ssd01

      Files for 1989-1991 in /users/graddy/p16:
        h16p01.ssd01 h16p02.ssd01 h16p03a.ssd01 h16p03b.ssd01 h16p03c.ssd01 h16p04.ssd01 h16p05a.ssd01 h16p05b.ssd01 h16p08.ssd01 h16p09.ssd01 h16p12.ssd01 h16p16.ssd01 h16p21a.ssd01 h16p21b.ssd01 h16pg00.ssd01

      Files for 1990-1992 in /users/graddy/q17:
        h17p00.ssd01 h17p01.ssd01 h17p02.ssd01 h17p03a.ssd01 h17p03b.ssd01 h17p03c.ssd01 h17p04.ssd01 h17p05a.ssd01 h17p05b.ssd01 h17p08.ssd01 h17p09.ssd01 h17p12.ssd01 h17p16.ssd01 h17p21a.ssd01 h17p21b.ssd01

      Files for 1991-1992 in /users/graddy/q17raw:
        sh.h17.p000.ca sh.h17.p001.ca sh.h17.p002.ca sh.h17.p004.ca sh.h17.p006.ca sh.h17.p007.ca sh.h17.p008.ca sh.h17.p009.ca sh.h17.p010.ca sh.h17.p012.ca sh.h17.p014.ca sh.h17.p015.ca sh.h17.p016.ca sh.h17.p035.ca sh.h17.p03a.ca sh.h17.p03b.ca sh.h17.p05a.ca sh.h17.p05b.ca sh.h17.p17a.ca sh.h17.p17b.ca sh.h17.p18a.ca sh.h17.p18b.ca sh.h17.p19a.ca sh.h17.p19b.ca sh.h17.p19c.ca sh.h17.p20a.ca sh.h17.p20b.ca sh.h17.p20c.ca sh.h17.p20d.ca sh.h17.p21a.ca sh.h17.p21b.ca sh.h17.p22a.ca sh.h17.p22b.ca

      Files for 1992-1993 in /users/graddy/r18raw/original:
        sh.h18.p000.ca sh.h18.p001.ca sh.h18.p002.ca sh.h18.p004.ca sh.h18.p006.ca sh.h18.p007.ca sh.h18.p008.ca sh.h18.p009.ca sh.h18.p010.ca sh.h18.p012.ca sh.h18.p014.ca sh.h18.p015.ca sh.h18.p016.ca sh.h18.p035.ca sh.h18.p03a.ca sh.h18.p03b.ca sh.h18.p05a.ca sh.h18.p05b.ca sh.h18.p17a.ca sh.h18.p17b.ca sh.h18.p18a.ca sh.h18.p18b.ca sh.h18.p19a.ca sh.h18.p19b.ca sh.h18.p19c.ca sh.h18.p20a.ca sh.h18.p20b.ca sh.h18.p20c.ca sh.h18.p20d.ca sh.h18.p21a.ca sh.h18.p21b.ca sh.h18.p22a.ca sh.h18.p22b.ca

      Files for 1992-1993 in /users/graddy/r18raw/revised:
        sh.hr18.p000.ca sh.hr18.p010.ca sh.hr18.p020.ca sh.hr18.p03a.ca sh.hr18.p03b.ca sh.hr18.p041.ca sh.hr18.p042.ca sh.hr18.p050.ca sh.hr18.p051.ca sh.hr18.p052.ca sh.hr18.p060.ca sh.hr18.p070.ca sh.hr18.p080.ca sh.hr18.p090.ca sh.hr18.p100.ca sh.hr18.p12a.ca sh.hr18.p12b.ca sh.hr18.p140.ca sh.hr18.p150.ca sh.hr18.p160.ca sh.hr18.p17a.ca sh.hr18.p17b.ca sh.hr18.p180.ca sh.hr18.p19a.ca sh.hr18.p19b.ca sh.hr18.p19c.ca sh.hr18.p201.ca sh.hr18.p20a.ca sh.hr18.p20b.ca sh.hr18.p20c.ca sh.hr18.p211.ca sh.hr18.p21a.ca sh.hr18.p21b.ca sh.hr18.p220.ca sh.hr18.p221.ca

      Files for 1993-1994 in /users/graddy/s19raw:
        sh.h19.p000.ca sh.h19.p010.ca sh.h19.p020.ca sh.h19.p03a.ca sh.h19.p03b.ca sh.h19.p041.ca sh.h19.p042.ca sh.h19.p050.ca sh.h19.p051.ca sh.h19.p052.ca sh.h19.p060.ca sh.h19.p070.ca sh.h19.p080.ca sh.h19.p090.ca sh.h19.p100.ca sh.h19.p12a.ca sh.h19.p12b.ca sh.h19.p140.ca sh.h19.p150.ca sh.h19.p160.ca sh.h19.p17a.ca sh.h19.p17b.ca sh.h19.p180.ca sh.h19.p19a.ca sh.h19.p19b.ca sh.h19.p19c.ca sh.h19.p201.ca sh.h19.p20a.ca sh.h19.p20b.ca sh.h19.p20c.ca sh.h19.p211.ca sh.h19.p21a.ca sh.h19.p21b.ca sh.h19.p220.ca sh.h19.p221.ca