Employment Example: Determine how many people working at the beginning of 2002 changed jobs.

1 The SAS System 11:17 Sunday, November 21, 2004

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 ;

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

NOTE: AUTOEXEC processing completed.

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

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

5 DESCRIPTION: THIS EXAMPLE SHOWS HOW TO USE THE 2002 MEPS JOBS

6 FILE (HC-063) TO DETERMINE HOW MANY PERSONS

7 WORKING AT THE START OF THE YEAR CHANGED JOBS.

9 INPUT FILES: (1) C:\MEPS\DATA\H63.SAS7BDAT (2002 MEPS JOBS FILE)

10 (2) C:\MEPS\DATA\H62.SAS7BDAT (2002 MEPS FULL-YEAR FILE)

12 \****************************************************************/

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

NOTE: Libref CMEPS was successfully assigned as follows:

Engine: V8

Physical Name: C:\MEPS\DATA

16 FOOTNOTE 'PROGRAM: C:\MEPS\PROG\EXAMPLE_EM2.SAS';

18 TITLE1 'AHRQ MEPS DATA USERS WORKSHOP (EMPLOYMENT) -- NOV/DEC 2004';

19 TITLE2 ' ';

21 /***** THIS PROC SORT READS IN THE REQUIRED VARIABLES FROM THE *****/

22 /***** 2002 MEPS JOBS FILE FILE (HC-063) AND SUBSETS TO *****/

23 /***** PERSONS WHO HAD A JOB ON OR BEFORE JANUARY 1, 2002. *****/

24 /***** THE OUTPUT FILE *EMPSTART_POP* IS A PERSON LEVEL FILE. *****/

26 PROC SORT DATA= CMEPS.H63 (WHERE=

27 ((((PANEL = 6 AND RN = 3) OR (PANEL = 7 AND RN = 1)) AND

28 (SUBTYPE IN (1, 2, 3, 4))) AND

29 ((JSTRTY < 2002) OR (JSTRTM = 1 AND JSTRTD = 1 AND JSTRTY = 2002))))

30 NODUPKEY

31 OUT= EMPSTART_POP (KEEP= DUPERSID);

32 BY DUPERSID;

33 RUN;

NOTE: SAS sort was used.

NOTE: 2094 observations with duplicate key values were deleted.

NOTE: There were 19318 observations read from the data set CMEPS.H63.

WHERE (((PANEL=6) and (RN=3)) or ((PANEL=7) and (RN=1))) and ((JSTRTY<2002) or ((JSTRTM=1) and (JSTRTD=1) and (JSTRTY=2002)))

and SUBTYPE in (1, 2, 3, 4);

NOTE: The data set WORK.EMPSTART_POP has 17224 observations and 1 variables.

35 /***** THIS PROC SORT OUTPUTS A JOBS FILE THAT IDENTIFIES *****/

36 /***** THOSE WITH A JOB AT THE START OF 2002 WHO EITHER ADDED *****/

37 /***** A JOB OR CHANGED JOBS. *****/

39 PROC SORT DATA= CMEPS.H63 (KEEP= DUPERSID SUBTYPE JSTRTM

2 The SAS System 11:17 Sunday, November 21, 2004

40 JSTRTD JSTRTY JOBSIDX)

41 OUT= H63;

42 BY DUPERSID;

43 RUN;

NOTE: SAS sort was used.

NOTE: There were 67028 observations read from the data set CMEPS.H63.

NOTE: The data set WORK.H63 has 67028 observations and 6 variables.

45 DATA CHNGJOB_POP (KEEP= DUPERSID);

46 MERGE H63 (IN= A) EMPSTART_POP (IN= B);

47 BY DUPERSID;

48 IF (

49 (SUBTYPE IN (3,4)) OR

50 ((SUBTYPE IN (1, 2)) AND

51 (JSTRTY = 2002 AND (NOT (JSTRTD = 1 AND JSTRTM = 1))))) AND

52 (A AND B) THEN OUTPUT;

53 RUN;

NOTE: There were 67028 observations read from the data set WORK.H63.

NOTE: There were 17224 observations read from the data set WORK.EMPSTART_POP.

NOTE: The data set WORK.CHNGJOB_POP has 12159 observations and 1 variables.

55 PROC SORT DATA= CHNGJOB_POP NODUPKEY;

56 BY DUPERSID;

57 RUN;

NOTE: SAS sort was used.

NOTE: 6770 observations with duplicate key values were deleted.

NOTE: There were 12159 observations read from the data set WORK.CHNGJOB_POP.

NOTE: The data set WORK.CHNGJOB_POP has 5389 observations and 1 variables.

59 DATA HC62 (KEEP= AGE DUPERSID PERWT02P);

60 SET CMEPS.H62 (KEEP= DUPERSID AGE02X AGE42X AGE31X PERWT02P);

61 IF AGE02X >= 0

62 THEN AGE = AGE02X;

63 ELSE IF AGE42X >= 0

64 THEN AGE = AGE42X;

65 ELSE IF AGE31X >= 0

66 THEN AGE = AGE31X;

67 IF AGE GE 18

68 THEN OUTPUT;

69 RUN;

NOTE: There were 39165 observations read from the data set CMEPS.H62.

NOTE: The data set WORK.HC62 has 27573 observations and 3 variables.

71 PROC FORMAT;

72 VALUE AGEF

73 18-44 = '18-44'

74 45-64 = '45-64'

75 65-85 = '65-85';

NOTE: Format AGEF has been output.

76 RUN;

78 PROC FREQ DATA= HC62;

79 TABLES AGE;

80 FORMAT AGE AGEF. ;

81 RUN;

NOTE: There were 27573 observations read from the data set WORK.HC62.

NOTE: The PROCEDURE FREQ printed page 1.

3 The SAS System 11:17 Sunday, November 21, 2004

83 PROC SORT DATA= HC62;

84 BY DUPERSID;

85 RUN;

NOTE: SAS sort was used.

NOTE: There were 27573 observations read from the data set WORK.HC62.

NOTE: The data set WORK.HC62 has 27573 observations and 3 variables.

87 /***** CREATE A COMBINED DATA SET WHERE THE EMPSTART_POP PERSONS *****/

88 /***** AND THE CHNGJOB_POP PERSONS ARE DESIGNATED BY VARIABLES. *****/

90 DATA CHNGINFO;

91 MERGE HC62 (IN= A) EMPSTART_POP (IN= B) CHNGJOB_POP (IN= C) ;

92 BY DUPERSID;

93 IF B

94 THEN EMPSTART = 'YES';

95 ELSE EMPSTART = 'NO';

96 IF C

97 THEN CHNGJOB = 'YES';

98 ELSE CHNGJOB = 'NO';

99 IF A THEN OUTPUT;

100 RUN;

NOTE: There were 27573 observations read from the data set WORK.HC62.

NOTE: There were 17224 observations read from the data set WORK.EMPSTART_POP.

NOTE: There were 5389 observations read from the data set WORK.CHNGJOB_POP.

NOTE: The data set WORK.CHNGINFO has 27573 observations and 5 variables.

101

102 TITLE5 'UNWEIGHTED FREQUENCIES' ;

103

104 PROC FREQ DATA= CHNGINFO;

105 TABLES EMPSTART CHNGJOB

106 EMPSTART*CHNGJOB

107 / LIST MISSING ;

108 RUN;

NOTE: There were 27573 observations read from the data set WORK.CHNGINFO.

NOTE: The PROCEDURE FREQ printed page 2.

109

110 TITLE3 'AMONG PERSONS 18 AND OLDER WITH A CURRENT JOB STARTING';

111 TITLE4 'ON OR BEFORE JANUARY 1, 2002,' ;

112 TITLE4 'PERCENT WHO EITHER ADDED OR STOPPED A JOB IN 2002';

113 TITLE5 ' ';

114 TITLE6 'UNWEIGHTED FREQUENCY TABLE';

115

116 PROC FREQ DATA= CHNGINFO;

117 TABLES CHNGJOB

118 / LIST MISSING ;

119 RUN;

NOTE: There were 27573 observations read from the data set WORK.CHNGINFO.

NOTE: The PROCEDURE FREQ printed page 3.

120

121 TITLE6 'WEIGHTED FREQUENCY TABLE';

122

123 PROC FREQ DATA= CHNGINFO;

124 TABLES CHNGJOB

125 / LIST MISSING ;

126 WHERE EMPSTART = 'YES';

127 WEIGHT PERWT02P;

128 RUN;

4 The SAS System 11:17 Sunday, November 21, 2004

NOTE: There were 17089 observations read from the data set WORK.CHNGINFO.

WHERE EMPSTART='YES';

NOTE: The PROCEDURE FREQ printed page 4.

129

130

131

132

133

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