1                                     The SAS System     13:27 Saturday, November 20, 2004

 

NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.

NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)

      Licensed to AGENCY FOR HEALTHCARE RESEARCH & QUALITY, Site 0040776001.

NOTE: This session is executing on the WIN_PRO  platform.

 

 

 

NOTE: This installation is running Base SAS hot fix bundle 82BX08.

 

 

NOTE: AUTOEXEC processing beginning; file is C:\PROGRA~1\SASINS~1\SAS\V8\autoexec.sas.

 

1          ** C:\PROGRAM FILES\SAS INSTITUTE\SAS\V8\AUTOEXEC.SAS ;

2         

3          OPTIONS LS= 132 PS= 70 MERGENOBY=ERROR MSGLEVEL=i;

 

NOTE: AUTOEXEC processing completed.

 

1          /****************************************************************\

2         

3          PROGRAM:       C:\MEPS\PROG\EXAMPLE_E5.SAS

4         

5          DESCRIPTION:      THIS EXAMPLE SHOWS HOW TO COMPUTE EVENT-LEVEL

6                         ESTIMATES.

7                         IN THIS PROGRAM

 

8                         (1) THE 2001 MEPS INPATIENT HOSPITAL STAYS FILE IS

9                             USED TO COMPUTE MEAN FACILITY EXPENSE PER

10                            STAY.

11                        (2) THE 2001 MEPS OFFICE-BASED MEDICAL PROVIDER

12                            VISITS FILE IS USED TO COMPUTE MEAN

13                            EXPENSE PER OFFICE VISIT TO A MEDICAL

14                            PROVIDER.

15        

16         INPUT FILE:       (1) C:\MEPS\DATA\H59D.SAS7BDAT

17                                 -- 2001 HOSPITAL STAYS FILE

18                        (2) C:\MEPS\DATA\H59G.SAS7BDAT

19                                 -- 2001 OFFICE-BASED VISITS FILE

20        

21         \****************************************************************/

22        

23         LIBNAME CMEPS V8 'C:\MEPS\DATA' ;

NOTE: Libref CMEPS was successfully assigned as follows:

      Engine:        V8

      Physical Name: C:\MEPS\DATA

24        

25         FOOTNOTE 'PROGRAM: C:\MEPS\PROG\EXAMPLE_E5.SAS';

26        

27         TITLE1 'AHRQ MEPS DATA USERS WORKSHOP (ESTIMATION) -- NOV/DEC 2004';

28         TITLE2 'COMPUTING EVENT-LEVEL ESTIMATES';

29         TITLE3 ' ';

30        

31         /***** THESE DATA STEPS READS IN THE REQUIRED VARIABLES FROM THE *****/

32         /***** FULL-YEAR FILES.                                          *****/

33        

34         /***** INPATIENT HOSPITAL STAYS FILE.                            *****/

35         /***** *IPFXP01X* IS THE TOTAL EXPENSE VARIABLE.                 *****/

36        

37         TITLE4 'MEAN FACILITY EXPENSE PER INPATIENT STAY' ;

38        

39         DATA IP2001;

40            SET CMEPS.H59D (KEEP= DUPERSID IPFXP01X PERWT01F VARSTR01

41                                          VARPSU01);

42            LABEL IPFXP01X = 'TOTAL HOSP. STAY EXPENSES';

43         RUN;

 

NOTE: There were 3428 observations read from the data set CMEPS.H59D.

NOTE: The data set WORK.IP2001 has 3428 observations and 5 variables.

 

 

 

2                                                          The SAS System                          13:27 Saturday, November 20, 2004

 

44        

45         PROC SURVEYMEANS DATA= IP2001 NOBS SUMWGT MEAN STDERR CLM;

46            VAR IPFXP01X;

47            STRATA VARSTR01;

48            CLUSTER VARPSU01;

49            WEIGHT PERWT01F;

50         RUN;

 

NOTE: Due to nonpositive weights, 100 observation(s) were deleted.

NOTE: Only one cluster in a stratum for variable(s) IPFXP01X. The variance of IPFXP01X in that stratum is estimated by zero.

NOTE: There were 3428 observations read from the data set WORK.IP2001.

NOTE: The PROCEDURE SURVEYMEANS printed page 1.

 

51        

52         /***** OFFICE BASED MEDICAL PROVIDER VISITS FILE.                 *****/

53         /***** *OBXP01X* IS THE TOTAL EXPENSE VARIABLE.                   *****/

54        

55         TITLE4 'MEAN EXPENSE PER OFFICE VISIT TO A MEDICAL PROVIDER' ;

56        

57         DATA OB2001;

58            SET CMEPS.H59G (KEEP= DUPERSID OBXP01X PERWT01F VARSTR01

59                                                VARPSU01);

60            LABEL OBXP01X = 'TOTAL OFFICE VISIT EXPENSES';

61         RUN;

 

NOTE: There were 147490 observations read from the data set CMEPS.H59G.

 

NOTE: The data set WORK.OB2001 has 147490 observations and 5 variables.

 

62        

63         PROC SURVEYMEANS DATA= OB2001 NOBS SUMWGT MEAN STDERR CLM;

64            VAR OBXP01X;

65            STRATA VARSTR01;

66            CLUSTER VARPSU01;

67            WEIGHT PERWT01F;

68         RUN;

 

NOTE: Due to nonpositive weights, 2980 observation(s) were deleted.

NOTE: There were 147490 observations read from the data set WORK.OB2001.

NOTE: The PROCEDURE SURVEYMEANS printed page 2.

 

69        

 

 

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414