1 The SAS System 17:38 Monday, April 15, 2019 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3 MBCS3170) Licensed to NATIONAL BUREAU OF ECONOMIC RESEARCH, Site 70111350. NOTE: This session is executing on the Linux 3.10.0-957.1.3.el7.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.1 NOTE: Additional host information: Linux LIN X64 3.10.0-957.1.3.el7.x86_64 #1 SMP Mon Nov 26 12:36:06 CST 2018 x86_64 Scientific Linux release 7.6 (Nitrogen) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS initialization used: real time 0.07 seconds cpu time 0.02 seconds 1 options nocenter; 2 3 options linesize=70; 4 *options obs=10000; 5 6 * The following line should contain the directory 7 where the SAS file is to be stored ; 8 9 *libname out "~/bulk/cost-reports/hosp/"; 10 libname out "/homes/data/hcris/2552-96"; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /homes/data/hcris/2552-96 11 12 * The following line should contain the directory 13 where the SAS alphanumeric long file is stored ; 14 15 %macro loop(fyear=,lyear=); 16 %do year=&fyear. %to &lyear.; 17 18 *libname y&year. "/home/data/hcris/&year./"; 2 The SAS System 17:38 Monday, April 15, 2019 19 %let dataset=alpha&year.; 20 %let user=; 21 /*--------------------------------------------------------- 21 ! ---------------------------*/ 22 /* 23 * This program is an example of how to subset variables 23 ! from HCRIS' alphnmrc database. 24 * It selects variables from HCRIS Worksheets that are the 24 ! old PPS 25 * variables F1 F18 and F38 and outputs a SAS dataset 26 * 27 * by Jean Roth, jroth@nber.org , 2003-07-25 ; 28 * 60 variables added 2006-05-19 ; 29 * Please report any problems or errors to jroth@nber.org 30 * NOTE: This program is distributed under the GNU GPL. 30 ! See end of 31 * this file and http://www.gnu.org/licenses/ for details. 32 * 33 * wk_xwalk.sas7bdat is a WKSHT_CD / worksheet label 33 ! crosswalk. 34 * The worksheet codes, WKSHT_CD, are as follows : 35 * 36 * "S200000" => "S-2" 37 * "S300001" => "S-3, Part I" 38 * "E001000" => "E-1" , ## not in worksheet docs 39 * "E00A18A" => "E, Part A: Hospital Title XVIII" 40 * "E01B18A" => "E, Part A: Subprovider 1, (c) Title 40 ! XVIII" 41 * "E02B18A" => "E, Part A: Subprovider 2, (c) Title 41 ! XVIII" 42 * "E03B18A" => "E, Part A: Subprovider 3, (c) Title 42 ! XVIII" 43 * "E04B18A" => "E, Part A: Subprovider 4, (c) Title 43 ! XVIII" 44 * "E05B18A" => "E, Part A: Subprovider 5, (c) Title 44 ! XVIII" 45 * "E06B18A" => "E, Part A: Subprovider 6, (c) Title 45 ! XVIII" 46 * "E07B18A" => "E, Part A: Subprovider 7, (c) Title 46 ! XVIII" 47 * "E08B18A" => "E, Part A: Subprovider 8, (c) Title 47 ! XVIII" 48 * "E09B18A" => "E, Part A: Subprovider 9, (c) Title 48 ! XVIII" 49 * "E00B18A" => "E, Part A: Subprovider 10, (c) Title 49 ! XVIII" 50 * "L00A181" => "L, Part I: Hospital Title XVIII" 51 * "L00A191" => "L, Part I: Hospital Title XIX" 52 * 53 * PPS99 WKSHT_CD CLMN_NUM LINE_NUM USAGE Notes/Label 54 * ----- -------- -------- -------- ----- ----------- 55 * F1 S200000 0200 00200 alpha? Provider 55 ! number - Hospital 56 * F18 S200000 0100 00200 alpha Hospital 56 ! Name 57 * F38 S200000 0100 02500 alpha Teaching 57 ! hospital? (Y/N) 3 The SAS System 17:38 Monday, April 15, 2019 58 * F71 S200000 ---- ----- alpha (SSA State 58 ! Codes are the first two digits of the Medicare Provider 58 ! Number) 59 * F75 S200000 ---- ----- alpha (This is 59 ! the UTIL_CD variable in hosp_rpt.zip datafile) 60 * F92 S300001 0100 02500 num Total Beds 60 ! Available in Facility 61 * F100 S300001 0200 01200 num Total 61 ! Hospital Bed Days Available 62 * F100 S300001 0201 01200 num Total 62 ! Hospital Bed Days Available 63 * F165 S300001 0700 02500 num Interns & 63 ! Residents - Total Facility 64 * F167 S300001 0900 02500 num Net I & R 64 ! Replacing Non-Phys Anes. - Tot. Fac. 65 * F1828 (above) 0100 01100 num Direct 65 ! Graduate medial Education Payment 66 * F2153 L00A181 0100 00403 num Indirect 66 ! Medical Education Adjustment 67 * F2153 L00A191 0100 00403 num Indirect 67 ! Medical Education Adjustment 68 * F2158 L00A181 0100 00504 num 68 ! Disproportionate Share Adjustment 69 * F2158 L00A191 0100 00504 num 69 ! Disproportionate Share Adjustment 70 * 71 * **Page 36-29 of the Cost Reporting Instructions has 71 ! instructions for CLMN_NUM 2 72 * for Worksheet S-3, Part I. It says that data from 72 ! Critical Access Hospitals 73 * (CAHs) has subscripted CLMN_NUMs. 74 * 75 */ 76 /*--------------------------------------------------------- 76 ! ---------------------------*/ 77 78 proc sql; 79 **select appropriate worksheets; 80 create table &dataset. as 81 select * 82 from out.hosp_alpha2552_96_&year._long 83 where ( 84 ( WKSHT_CD EQ "S200000" ) 85 | ( WKSHT_CD EQ "A000000" ) 86 87 ) 88 ; 89 90 **add varname; 91 data out.&dataset.&user.; 92 set &dataset.; 93 length varname $32. ; 94 ; 94 ! *32-character varname 94 ! maximum; 95 select; 95 ! *1234567890123456789212345 4 The SAS System 17:38 Monday, April 15, 2019 95 ! 6789312; 96 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 96 ! LINE_NUM = "00100" ) varname = "street" ; 97 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 97 ! LINE_NUM = "00200" ) varname = "hospname" ; 98 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 98 ! LINE_NUM = "00101" ) varname = "city" ; 99 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 99 ! LINE_NUM = "02100" ) varname = "f29"; ** urban or rural ; 100 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 100 ! LINE_NUM = "02101" ) varname = "dsh"; ** disproportionate 100 ! share ; 101 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 101 ! LINE_NUM = "02101" ) varname = "pickle"; ** Pickle 101 ! amendment ; 102 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 102 ! LINE_NUM = "02500" ) varname = "f38"; ** teaching hospital 102 ! ; 103 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 103 ! LINE_NUM = "02601" ) varname = "s2_c1_2601"; 104 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 104 ! LINE_NUM = "02602" ) varname = "s2_c1_2602"; 105 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 105 ! LINE_NUM = "02604" ) varname = "s2_c1_2604"; 106 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 106 ! LINE_NUM = "03000" ) varname = "s2_c1_3000" ; 107 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 107 ! LINE_NUM = "03001" ) varname = "s2_c1_3001" ; 108 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 108 ! LINE_NUM = "03002" ) varname = "s2_c1_3002" ; 109 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 109 ! LINE_NUM = "03003" ) varname = "s2_c1_3003" ; 110 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0100" and 110 ! LINE_NUM = "03004" ) varname = "s2_c1_3004" ; 111 112 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 112 ! LINE_NUM = "00200" ) varname = "prov_num" ; 113 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 113 ! LINE_NUM = "00200" ) varname = "provider" ; 114 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 114 ! LINE_NUM = "00300" ) varname = "subprovider" ; 115 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 115 ! LINE_NUM = "00100" ) varname = "po_box" ; 116 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 116 ! LINE_NUM = "00101" ) varname = "state" ; 117 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 117 ! LINE_NUM = "02601" ) varname = "s2_c2_2601"; 118 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 118 ! LINE_NUM = "02602" ) varname = "s2_c2_2602"; 119 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 119 ! LINE_NUM = "02603" ) varname = "s2_c2_2603"; 120 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0200" and 120 ! LINE_NUM = "02604" ) varname = "s2_c2_2604"; 121 122 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0300" and 122 ! LINE_NUM = "00101" ) varname = "zip" ; 123 when ( WKSHT_CD EQ "S200000" and CLMN_NUM = "0400" and 5 The SAS System 17:38 Monday, April 15, 2019 123 ! LINE_NUM = "00101" ) varname = "county" ; 124 125 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0100" and 125 ! LINE_NUM="04001") varname="chainname"; 126 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0100" and 126 ! LINE_NUM="04002") varname="chainstreet"; 127 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0100" and 127 ! LINE_NUM="04003") varname="chaincity"; 128 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0200" and 128 ! LINE_NUM="04003") varname="chainstate"; 129 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0300" and 129 ! LINE_NUM="04003") varname="chainzip"; 130 131 132 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0100" and 132 ! LINE_NUM="05301") varname="s2_c1_5301"; 133 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0100" and 133 ! LINE_NUM="05302") varname="s2_c1_5302"; 134 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0100" and 134 ! LINE_NUM="05303") varname="s2_c1_5303"; 135 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0200" and 135 ! LINE_NUM="05301") varname="s2_c2_5301"; 136 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0200" and 136 ! LINE_NUM="05302") varname="s2_c2_5302"; 137 when (WKSHT_CD EQ "S200000" and CLMN_NUM="0200" and 137 ! LINE_NUM="05303") varname="s2_c2_5303"; 138 139 otherwise; 140 end; 141 run; 142 %end; 143 %mend; 144 *%loop(fyear=1996,lyear=2011); 145 %loop(fyear=1995,lyear=2011); NOTE: Data file OUT.HOSP_ALPHA2552_96_1995_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA1995 created, with 118 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: Data file OUT.ALPHA1995.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 118 observations read from the data set WORK.ALPHA1995. NOTE: The data set OUT.ALPHA1995 has 118 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds 6 The SAS System 17:38 Monday, April 15, 2019 cpu time 0.01 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_1996_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA1996 created, with 536785 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.26 seconds cpu time 0.26 seconds NOTE: Data file OUT.ALPHA1996.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 536785 observations read from the data set WORK.ALPHA1996. NOTE: The data set OUT.ALPHA1996 has 536785 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.77 seconds cpu time 0.56 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_1997_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA1997 created, with 589004 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.29 seconds cpu time 0.28 seconds NOTE: Data file OUT.ALPHA1997.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 589004 observations read from the data set WORK.ALPHA1997. NOTE: The data set OUT.ALPHA1997 has 589004 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.80 seconds cpu time 0.82 seconds 7 The SAS System 17:38 Monday, April 15, 2019 NOTE: Data file OUT.HOSP_ALPHA2552_96_1998_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA1998 created, with 610913 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.33 seconds cpu time 0.30 seconds NOTE: Data file OUT.ALPHA1998.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 610913 observations read from the data set WORK.ALPHA1998. NOTE: The data set OUT.ALPHA1998 has 610913 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.87 seconds cpu time 0.64 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_1999_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA1999 created, with 633495 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.33 seconds cpu time 0.32 seconds NOTE: Data file OUT.ALPHA1999.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 633495 observations read from the data set WORK.ALPHA1999. NOTE: The data set OUT.ALPHA1999 has 633495 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.04 seconds cpu time 0.63 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2000_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will 8 The SAS System 17:38 Monday, April 15, 2019 be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2000 created, with 679891 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.35 seconds cpu time 0.34 seconds NOTE: Data file OUT.ALPHA2000.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 679891 observations read from the data set WORK.ALPHA2000. NOTE: The data set OUT.ALPHA2000 has 679891 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.50 seconds cpu time 0.69 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2001_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2001 created, with 765667 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.37 seconds cpu time 0.37 seconds NOTE: Data file OUT.ALPHA2001.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 765667 observations read from the data set WORK.ALPHA2001. NOTE: The data set OUT.ALPHA2001 has 765667 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.16 seconds cpu time 0.78 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2002_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2002 created, with 798512 rows and 5 columns. 9 The SAS System 17:38 Monday, April 15, 2019 NOTE: PROCEDURE SQL used (Total process time): real time 0.41 seconds cpu time 0.40 seconds NOTE: Data file OUT.ALPHA2002.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 798512 observations read from the data set WORK.ALPHA2002. NOTE: The data set OUT.ALPHA2002 has 798512 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.19 seconds cpu time 0.83 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2003_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2003 created, with 805356 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.42 seconds cpu time 0.40 seconds NOTE: Data file OUT.ALPHA2003.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 805356 observations read from the data set WORK.ALPHA2003. NOTE: The data set OUT.ALPHA2003 has 805356 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.32 seconds cpu time 0.83 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2004_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2004 created, with 821245 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.41 seconds 10 The SAS System 17:38 Monday, April 15, 2019 cpu time 0.40 seconds NOTE: Data file OUT.ALPHA2004.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 821245 observations read from the data set WORK.ALPHA2004. NOTE: The data set OUT.ALPHA2004 has 821245 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.24 seconds cpu time 0.83 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2005_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2005 created, with 846715 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.42 seconds cpu time 0.41 seconds NOTE: Data file OUT.ALPHA2005.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 846715 observations read from the data set WORK.ALPHA2005. NOTE: The data set OUT.ALPHA2005 has 846715 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.35 seconds cpu time 0.87 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2006_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2006 created, with 856350 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.46 seconds cpu time 0.41 seconds 11 The SAS System 17:38 Monday, April 15, 2019 NOTE: Data file OUT.ALPHA2006.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 856350 observations read from the data set WORK.ALPHA2006. NOTE: The data set OUT.ALPHA2006 has 856350 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.23 seconds cpu time 0.87 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2007_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2007 created, with 851980 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.42 seconds cpu time 0.41 seconds NOTE: Data file OUT.ALPHA2007.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 851980 observations read from the data set WORK.ALPHA2007. NOTE: The data set OUT.ALPHA2007 has 851980 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.22 seconds cpu time 0.86 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2008_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2008 created, with 868106 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.43 seconds cpu time 0.42 seconds NOTE: Data file OUT.ALPHA2008.DATA is in a format that is native to another host, or the file encoding does not match the session 12 The SAS System 17:38 Monday, April 15, 2019 encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 868106 observations read from the data set WORK.ALPHA2008. NOTE: The data set OUT.ALPHA2008 has 868106 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.30 seconds cpu time 0.88 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2009_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2009 created, with 874529 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.43 seconds cpu time 0.41 seconds NOTE: Data file OUT.ALPHA2009.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 874529 observations read from the data set WORK.ALPHA2009. NOTE: The data set OUT.ALPHA2009 has 874529 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.27 seconds cpu time 0.89 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2010_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2010 created, with 547738 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.27 seconds cpu time 0.25 seconds NOTE: Data file OUT.ALPHA2010.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 13 The SAS System 17:38 Monday, April 15, 2019 NOTE: There were 547738 observations read from the data set WORK.ALPHA2010. NOTE: The data set OUT.ALPHA2010 has 547738 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.84 seconds cpu time 0.56 seconds NOTE: Data file OUT.HOSP_ALPHA2552_96_2011_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: Table WORK.ALPHA2011 created, with 3671 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.00 seconds NOTE: Data file OUT.ALPHA2011.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 3671 observations read from the data set WORK.ALPHA2011. NOTE: The data set OUT.ALPHA2011 has 3671 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 146 *%loop(fyear=2005,lyear=2011); 147 *%loop(fyear=1996,lyear=2004); 148 *%loop(fyear=1995,lyear=1995); 149 *%loop(fyear=2004,lyear=2009); 150 *%loop(fyear=1997,lyear=1997); 151 *%loop(fyear=2004,lyear=2004); 152 *%loop(fyear=2005,lyear=2005); 153 *%loop(fyear=2006,lyear=2006); 154 *%loop(fyear=2007,lyear=2007); 155 *%loop(fyear=2008,lyear=2008); 156 *%loop(fyear=2009,lyear=2009); 157 158 /* 159 Copyright 2003 shared by Jean Roth and the National Bureau 159 ! of Economic Research 160 161 National Bureau of Economic Research. 162 1050 Massachusetts Avenue 163 Cambridge, MA 02138 164 jroth@nber.org 165 14 The SAS System 17:38 Monday, April 15, 2019 166 This program and all programs referenced in it are free 166 ! software. You 167 can redistribute the program or modify it under the terms 167 ! of the GNU 168 General Public License as published by the Free Software 168 ! Foundation; 169 either version 2 of the License, or (at your option) any 169 ! later version. 170 171 This program is distributed in the hope that it will be 171 ! useful, 172 but WITHOUT ANY WARRANTY; without even the implied warranty 172 ! of 173 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See 173 ! the 174 GNU General Public License for more details. 175 176 You should have received a copy of the GNU General Public 176 ! License 177 along with this program; if not, write to the Free Software 178 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 178 ! 02111-1307 179 USA. 180 */ NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 24.09 seconds cpu time 16.99 seconds