1 The SAS System 17:33 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 %macro loop(fyear=,lyear=); 6 7 * The following line should contain the directory 8 where the SAS file is to be stored ; 9 10 %let DASH=2552-10; 11 %let UNDERSCORE=2552_10; 12 *libname out "~/bulk/cost-reports/hosp/&DASH."; 13 libname out "."; 14 15 * The following line should contain the directory 16 where the SAS alphanumeric long file is stored ; 17 18 %do year=&fyear. %to &lyear.; 19 20 %let dataset=alpha&year.; 21 /*------------------------------------------------------------------------------------*/ 2 The SAS System 17:33 Monday, April 15, 2019 22 /* 23 * This program is an example of how to subset variables from HCRIS' alphnmrc database. 24 * It selects variables from HCRIS Worksheets that are the 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. 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 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 XVIII" 41 * "E02B18A" => "E, Part A: Subprovider 2, (c) Title XVIII" 42 * "E03B18A" => "E, Part A: Subprovider 3, (c) Title XVIII" 43 * "E04B18A" => "E, Part A: Subprovider 4, (c) Title XVIII" 44 * "E05B18A" => "E, Part A: Subprovider 5, (c) Title XVIII" 45 * "E06B18A" => "E, Part A: Subprovider 6, (c) Title XVIII" 46 * "E07B18A" => "E, Part A: Subprovider 7, (c) Title XVIII" 47 * "E08B18A" => "E, Part A: Subprovider 8, (c) Title XVIII" 48 * "E09B18A" => "E, Part A: Subprovider 9, (c) Title XVIII" 49 * "E00B18A" => "E, Part A: Subprovider 10, (c) Title 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 number - Hospital 56 * F18 S200000 0100 00200 alpha Hospital Name 57 * F38 S200000 0100 02500 alpha Teaching hospital? (Y/N) 58 * F71 S200000 ---- ----- alpha (SSA State Codes are the first two digits of the Medicare Provider 58 ! Number) 59 * F75 S200000 ---- ----- alpha (This is the UTIL_CD variable in hosp_rpt.zip datafile) 60 * F92 S300001 0100 02500 num Total Beds Available in Facility 61 * F100 S300001 0200 01200 num Total Hospital Bed Days Available 62 * F100 S300001 0201 01200 num Total Hospital Bed Days Available 63 * F165 S300001 0700 02500 num Interns & Residents - Total Facility 64 * F167 S300001 0900 02500 num Net I & R Replacing Non-Phys Anes. - Tot. Fac. 65 * F1828 (above) 0100 01100 num Direct Graduate medial Education Payment 66 * F2153 L00A181 0100 00403 num Indirect Medical Education Adjustment 67 * F2153 L00A191 0100 00403 num Indirect Medical Education Adjustment 68 * F2158 L00A181 0100 00504 num Disproportionate Share Adjustment 69 * F2158 L00A191 0100 00504 num Disproportionate Share Adjustment 70 * 71 * **Page 36-29 of the Cost Reporting Instructions has instructions for CLMN_NUM 2 72 * for Worksheet S-3, Part I. It says that data from Critical Access Hospitals 73 * (CAHs) has subscripted CLMN_NUMs. 74 * 75 */ 76 /*------------------------------------------------------------------------------------*/ 77 78 proc sql; 3 The SAS System 17:33 Monday, April 15, 2019 79 **select appropriate worksheets; 80 create table &dataset. as 81 select * 82 from out.hosp_alpha&UNDERSCORE._&year._long 83 where ( 84 ( wksht_cd = "S200001" ) 85 or ( wksht_cd = "S500000" ) 86 ) 87 ; 88 89 **add varname; 90 data out.&dataset.; 91 set &dataset.; 92 length varname $32. ; 93 ; *32-character varname maximum; 94 select; *12345678901234567892123456789312 94 ! ; 95 when ( wksht_cd = "S200001" and line_num = "00100" and clmn_num = "00100" ) varname = "s2_1_c1_1" ; 96 when ( wksht_cd = "S200001" and line_num = "00100" and clmn_num = "00200" ) varname = "s2_1_c2_1" ; 97 when ( wksht_cd = "S200001" and line_num = "00200" and clmn_num = "00100" ) varname = "s2_1_c1_2" ; 98 when ( wksht_cd = "S200001" and line_num = "00200" and clmn_num = "00200" ) varname = "s2_1_c2_2" ; 99 when ( wksht_cd = "S200001" and line_num = "00200" and clmn_num = "00300" ) varname = "s2_1_c3_2" ; 100 when ( wksht_cd = "S200001" and line_num = "00200" and clmn_num = "00400" ) varname = "s2_1_c4_2" ; 101 when ( wksht_cd = "S200001" and line_num = "00300" and clmn_num = "00100" ) varname = "s2_1_c1_3" ; 102 when ( wksht_cd = "S200001" and line_num = "00400" and clmn_num = "00200" ) varname = "s2_1_c1_4" ; 103 when ( wksht_cd = "S200001" and line_num = "00500" and clmn_num = "00200" ) varname = "s2_1_c1_5" ; 104 when ( wksht_cd = "S200001" and line_num = "00600" and clmn_num = "00200" ) varname = "s2_1_c2_6" ; 105 when ( wksht_cd = "S200001" and line_num = "00601" and clmn_num = "00200" ) varname = "s2_1_c2_601" ; 106 when ( wksht_cd = "S200001" and line_num = "00700" and clmn_num = "00200" ) varname = "s2_1_c2_7" ; 107 when ( wksht_cd = "S200001" and line_num = "00800" and clmn_num = "00200" ) varname = "s2_1_c2_8" ; 108 when ( wksht_cd = "S200001" and line_num = "00900" and clmn_num = "00200" ) varname = "s2_1_c2_9" ; 109 when ( wksht_cd = "S200001" and line_num = "01000" and clmn_num = "00200" ) varname = "s2_1_c2_10" ; 110 when ( wksht_cd = "S200001" and line_num = "01001" and clmn_num = "00200" ) varname = "s2_1_c2_1001" ; 111 when ( wksht_cd = "S200001" and line_num = "01200" and clmn_num = "00200" ) varname = "s2_1_c2_12" ; 112 when ( wksht_cd = "S200001" and line_num = "01201" and clmn_num = "00200" ) varname = "s2_1_c2_1201" ; 113 when ( wksht_cd = "S200001" and line_num = "01202" and clmn_num = "00200" ) varname = "s2_1_c2_1202" ; 114 when ( wksht_cd = "S200001" and line_num = "01203" and clmn_num = "00200" ) varname = "s2_1_c2_1203" ; 115 when ( wksht_cd = "S200001" and line_num = "01204" and clmn_num = "00200" ) varname = "s2_1_c2_1204" ; 116 when ( wksht_cd = "S200001" and line_num = "01205" and clmn_num = "00200" ) varname = "s2_1_c2_1205" ; 117 when ( wksht_cd = "S200001" and line_num = "01206" and clmn_num = "00200" ) varname = "s2_1_c2_1206" ; 118 when ( wksht_cd = "S200001" and line_num = "01207" and clmn_num = "00200" ) varname = "s2_1_c2_1207" ; 119 when ( wksht_cd = "S200001" and line_num = "01208" and clmn_num = "00200" ) varname = "s2_1_c2_1208" ; 120 when ( wksht_cd = "S200001" and line_num = "01209" and clmn_num = "00200" ) varname = "s2_1_c2_1209" ; 121 when ( wksht_cd = "S200001" and line_num = "01300" and clmn_num = "00200" ) varname = "s2_1_c2_13" ; 122 when ( wksht_cd = "S200001" and line_num = "01301" and clmn_num = "00200" ) varname = "s2_1_c2_1301" ; 123 when ( wksht_cd = "S200001" and line_num = "01302" and clmn_num = "00200" ) varname = "s2_1_c2_1302" ; 124 when ( wksht_cd = "S200001" and line_num = "01303" and clmn_num = "00200" ) varname = "s2_1_c2_1303" ; 125 when ( wksht_cd = "S200001" and line_num = "01304" and clmn_num = "00200" ) varname = "s2_1_c2_1304" ; 126 when ( wksht_cd = "S200001" and line_num = "01305" and clmn_num = "00200" ) varname = "s2_1_c2_1305" ; 127 when ( wksht_cd = "S200001" and line_num = "01306" and clmn_num = "00200" ) varname = "s2_1_c2_1306" ; 128 when ( wksht_cd = "S200001" and line_num = "01307" and clmn_num = "00200" ) varname = "s2_1_c2_1307" ; 129 when ( wksht_cd = "S200001" and line_num = "01308" and clmn_num = "00200" ) varname = "s2_1_c2_1308" ; 130 when ( wksht_cd = "S200001" and line_num = "01309" and clmn_num = "00200" ) varname = "s2_1_c2_1309" ; 131 when ( wksht_cd = "S200001" and line_num = "01400" and clmn_num = "00200" ) varname = "s2_1_c2_14" ; 132 when ( wksht_cd = "S200001" and line_num = "01401" and clmn_num = "00200" ) varname = "s2_1_c2_1401" ; 133 when ( wksht_cd = "S200001" and line_num = "01402" and clmn_num = "00200" ) varname = "s2_1_c2_1402" ; 134 when ( wksht_cd = "S200001" and line_num = "01403" and clmn_num = "00200" ) varname = "s2_1_c2_1403" ; 135 when ( wksht_cd = "S200001" and line_num = "01404" and clmn_num = "00200" ) varname = "s2_1_c2_1404" ; 4 The SAS System 17:33 Monday, April 15, 2019 136 when ( wksht_cd = "S200001" and line_num = "01405" and clmn_num = "00200" ) varname = "s2_1_c2_1405" ; 137 when ( wksht_cd = "S200001" and line_num = "01500" and clmn_num = "00200" ) varname = "s2_1_c2_15" ; 138 when ( wksht_cd = "S200001" and line_num = "01501" and clmn_num = "00200" ) varname = "s2_1_c2_1501" ; 139 when ( wksht_cd = "S200001" and line_num = "01502" and clmn_num = "00200" ) varname = "s2_1_c2_1502" ; 140 when ( wksht_cd = "S200001" and line_num = "01503" and clmn_num = "00200" ) varname = "s2_1_c2_1503" ; 141 when ( wksht_cd = "S200001" and line_num = "01504" and clmn_num = "00200" ) varname = "s2_1_c2_1504" ; 142 when ( wksht_cd = "S200001" and line_num = "01505" and clmn_num = "00200" ) varname = "s2_1_c2_1505" ; 143 when ( wksht_cd = "S200001" and line_num = "01506" and clmn_num = "00200" ) varname = "s2_1_c2_1506" ; 144 when ( wksht_cd = "S200001" and line_num = "01507" and clmn_num = "00200" ) varname = "s2_1_c2_1507" ; 145 when ( wksht_cd = "S200001" and line_num = "01508" and clmn_num = "00200" ) varname = "s2_1_c2_1508" ; 146 when ( wksht_cd = "S200001" and line_num = "01509" and clmn_num = "00200" ) varname = "s2_1_c2_1509" ; 147 when ( wksht_cd = "S200001" and line_num = "01510" and clmn_num = "00200" ) varname = "s2_1_c2_1510" ; 148 when ( wksht_cd = "S200001" and line_num = "01511" and clmn_num = "00200" ) varname = "s2_1_c2_1511" ; 149 when ( wksht_cd = "S200001" and line_num = "01512" and clmn_num = "00200" ) varname = "s2_1_c2_1512" ; 150 when ( wksht_cd = "S200001" and line_num = "01513" and clmn_num = "00200" ) varname = "s2_1_c2_1513" ; 151 when ( wksht_cd = "S200001" and line_num = "01514" and clmn_num = "00200" ) varname = "s2_1_c2_1514" ; 152 when ( wksht_cd = "S200001" and line_num = "01515" and clmn_num = "00200" ) varname = "s2_1_c2_1515" ; 153 when ( wksht_cd = "S200001" and line_num = "01516" and clmn_num = "00200" ) varname = "s2_1_c2_1516" ; 154 when ( wksht_cd = "S200001" and line_num = "01517" and clmn_num = "00200" ) varname = "s2_1_c2_1517" ; 155 when ( wksht_cd = "S200001" and line_num = "01518" and clmn_num = "00200" ) varname = "s2_1_c2_1518" ; 156 when ( wksht_cd = "S200001" and line_num = "01519" and clmn_num = "00200" ) varname = "s2_1_c2_1519" ; 157 when ( wksht_cd = "S200001" and line_num = "01520" and clmn_num = "00200" ) varname = "s2_1_c2_1520" ; 158 when ( wksht_cd = "S200001" and line_num = "01521" and clmn_num = "00200" ) varname = "s2_1_c2_1521" ; 159 when ( wksht_cd = "S200001" and line_num = "01522" and clmn_num = "00200" ) varname = "s2_1_c2_1522" ; 160 when ( wksht_cd = "S200001" and line_num = "01523" and clmn_num = "00200" ) varname = "s2_1_c2_1523" ; 161 when ( wksht_cd = "S200001" and line_num = "01524" and clmn_num = "00200" ) varname = "s2_1_c2_1524" ; 162 when ( wksht_cd = "S200001" and line_num = "01600" and clmn_num = "00200" ) varname = "s2_1_c2_16" ; 163 when ( wksht_cd = "S200001" and line_num = "01601" and clmn_num = "00200" ) varname = "s2_1_c2_1601" ; 164 when ( wksht_cd = "S200001" and line_num = "01602" and clmn_num = "00200" ) varname = "s2_1_c2_1602" ; 165 when ( wksht_cd = "S200001" and line_num = "01603" and clmn_num = "00200" ) varname = "s2_1_c2_1603" ; 166 when ( wksht_cd = "S200001" and line_num = "01604" and clmn_num = "00200" ) varname = "s2_1_c2_1604" ; 167 when ( wksht_cd = "S200001" and line_num = "01605" and clmn_num = "00200" ) varname = "s2_1_c2_1605" ; 168 when ( wksht_cd = "S200001" and line_num = "01606" and clmn_num = "00200" ) varname = "s2_1_c2_1606" ; 169 when ( wksht_cd = "S200001" and line_num = "01607" and clmn_num = "00200" ) varname = "s2_1_c2_1607" ; 170 when ( wksht_cd = "S200001" and line_num = "01608" and clmn_num = "00200" ) varname = "s2_1_c2_1608" ; 171 when ( wksht_cd = "S200001" and line_num = "01609" and clmn_num = "00200" ) varname = "s2_1_c2_1609" ; 172 when ( wksht_cd = "S200001" and line_num = "01610" and clmn_num = "00200" ) varname = "s2_1_c2_1610" ; 173 when ( wksht_cd = "S200001" and line_num = "01611" and clmn_num = "00200" ) varname = "s2_1_c2_1611" ; 174 when ( wksht_cd = "S200001" and line_num = "01612" and clmn_num = "00200" ) varname = "s2_1_c2_1612" ; 175 when ( wksht_cd = "S200001" and line_num = "01613" and clmn_num = "00200" ) varname = "s2_1_c2_1613" ; 176 when ( wksht_cd = "S200001" and line_num = "01614" and clmn_num = "00200" ) varname = "s2_1_c2_1614" ; 177 when ( wksht_cd = "S200001" and line_num = "01615" and clmn_num = "00200" ) varname = "s2_1_c2_1615" ; 178 when ( wksht_cd = "S200001" and line_num = "01616" and clmn_num = "00200" ) varname = "s2_1_c2_1616" ; 179 when ( wksht_cd = "S200001" and line_num = "01617" and clmn_num = "00200" ) varname = "s2_1_c2_1617" ; 180 when ( wksht_cd = "S200001" and line_num = "01618" and clmn_num = "00200" ) varname = "s2_1_c2_1618" ; 181 when ( wksht_cd = "S200001" and line_num = "01619" and clmn_num = "00200" ) varname = "s2_1_c2_1619" ; 182 when ( wksht_cd = "S200001" and line_num = "01620" and clmn_num = "00200" ) varname = "s2_1_c2_1620" ; 183 when ( wksht_cd = "S200001" and line_num = "01621" and clmn_num = "00200" ) varname = "s2_1_c2_1621" ; 184 when ( wksht_cd = "S200001" and line_num = "01622" and clmn_num = "00200" ) varname = "s2_1_c2_1622" ; 185 when ( wksht_cd = "S200001" and line_num = "01623" and clmn_num = "00200" ) varname = "s2_1_c2_1623" ; 186 when ( wksht_cd = "S200001" and line_num = "01624" and clmn_num = "00200" ) varname = "s2_1_c2_1624" ; 187 when ( wksht_cd = "S200001" and line_num = "01700" and clmn_num = "00200" ) varname = "s2_1_c2_17" ; 188 when ( wksht_cd = "S200001" and line_num = "01701" and clmn_num = "00200" ) varname = "s2_1_c2_1701" ; 189 when ( wksht_cd = "S200001" and line_num = "01702" and clmn_num = "00200" ) varname = "s2_1_c2_1702" ; 190 when ( wksht_cd = "S200001" and line_num = "01703" and clmn_num = "00200" ) varname = "s2_1_c2_1703" ; 191 when ( wksht_cd = "S200001" and line_num = "01704" and clmn_num = "00200" ) varname = "s2_1_c2_1704" ; 192 when ( wksht_cd = "S200001" and line_num = "01705" and clmn_num = "00200" ) varname = "s2_1_c2_1705" ; 193 when ( wksht_cd = "S200001" and line_num = "01706" and clmn_num = "00200" ) varname = "s2_1_c2_1706" ; 5 The SAS System 17:33 Monday, April 15, 2019 194 when ( wksht_cd = "S200001" and line_num = "01707" and clmn_num = "00200" ) varname = "s2_1_c2_1707" ; 195 when ( wksht_cd = "S200001" and line_num = "01708" and clmn_num = "00200" ) varname = "s2_1_c2_1708" ; 196 when ( wksht_cd = "S200001" and line_num = "01709" and clmn_num = "00200" ) varname = "s2_1_c2_1709" ; 197 when ( wksht_cd = "S200001" and line_num = "01800" and clmn_num = "00200" ) varname = "s2_1_c2_18" ; 198 when ( wksht_cd = "S200001" and line_num = "01801" and clmn_num = "00200" ) varname = "s2_1_c2_1801" ; 199 when ( wksht_cd = "S200001" and line_num = "01802" and clmn_num = "00200" ) varname = "s2_1_c2_1802" ; 200 when ( wksht_cd = "S200001" and line_num = "01803" and clmn_num = "00200" ) varname = "s2_1_c2_1803" ; 201 when ( wksht_cd = "S200001" and line_num = "01804" and clmn_num = "00200" ) varname = "s2_1_c2_1804" ; 202 when ( wksht_cd = "S200001" and line_num = "01805" and clmn_num = "00200" ) varname = "s2_1_c2_1805" ; 203 when ( wksht_cd = "S200001" and line_num = "01806" and clmn_num = "00200" ) varname = "s2_1_c2_1806" ; 204 when ( wksht_cd = "S200001" and line_num = "01807" and clmn_num = "00200" ) varname = "s2_1_c2_1807" ; 205 when ( wksht_cd = "S200001" and line_num = "01808" and clmn_num = "00200" ) varname = "s2_1_c2_1808" ; 206 when ( wksht_cd = "S200001" and line_num = "01809" and clmn_num = "00200" ) varname = "s2_1_c2_1809" ; 207 when ( wksht_cd = "S200001" and line_num = "00300" and clmn_num = "00700" ) varname = "s2_1_c7_3" ; 208 when ( wksht_cd = "S200001" and line_num = "00600" and clmn_num = "00700" ) varname = "s2_1_c7_6" ; 209 when ( wksht_cd = "S200001" and line_num = "00601" and clmn_num = "00700" ) varname = "s2_1_c7_601" ; 210 when ( wksht_cd = "S200001" and line_num = "02200" and clmn_num = "00100" ) varname = "s2_1_c1_22" ; 211 when ( wksht_cd = "S200001" and line_num = "00300" and clmn_num = "00300" ) varname = "s2_1_c3_3" ; 212 when ( wksht_cd = "S200001" and line_num = "11600" and clmn_num = "00100" ) varname = "s2_1_c1_116" ; 213 when ( wksht_cd = "S200001" and line_num = "12500" and clmn_num = "00100" ) varname = "s2_1_c1_125" ; 214 when ( wksht_cd = "S200001" and line_num = "12600" and clmn_num = "00100" ) varname = "s2_1_c1_126" ; 215 when ( wksht_cd = "S200001" and line_num = "12700" and clmn_num = "00100" ) varname = "s2_1_c1_127" ; 216 when ( wksht_cd = "S200001" and line_num = "12800" and clmn_num = "00100" ) varname = "s2_1_c1_128" ; 217 when ( wksht_cd = "S200001" and line_num = "12900" and clmn_num = "00100" ) varname = "s2_1_c1_129" ; 218 when ( wksht_cd = "S200001" and line_num = "13100" and clmn_num = "00100" ) varname = "s2_1_c1_131" ; 219 when ( wksht_cd = "S200001" and line_num = "13200" and clmn_num = "00100" ) varname = "s2_1_c1_132" ; 220 when ( wksht_cd = "S200001" and line_num = "12600" and clmn_num = "00200" ) varname = "s2_1_c2_126" ; 221 when ( wksht_cd = "S200001" and line_num = "12700" and clmn_num = "00200" ) varname = "s2_1_c2_127" ; 222 when ( wksht_cd = "S200001" and line_num = "12800" and clmn_num = "00200" ) varname = "s2_1_c2_128" ; 223 when ( wksht_cd = "S200001" and line_num = "12900" and clmn_num = "00200" ) varname = "s2_1_c2_129" ; 224 when ( wksht_cd = "S200001" and line_num = "13000" and clmn_num = "00200" ) varname = "s2_1_c2_130" ; 225 when ( wksht_cd = "S200001" and line_num = "13100" and clmn_num = "00200" ) varname = "s2_1_c2_131" ; 226 when ( wksht_cd = "S200001" and line_num = "13200" and clmn_num = "00200" ) varname = "s2_1_c2_132" ; 227 when ( wksht_cd = "S200001" and line_num = "13400" and clmn_num = "00100" ) varname = "s2_1_c1_134" ; 228 when ( wksht_cd = "S200001" and line_num = "13400" and clmn_num = "00200" ) varname = "s2_1_c2_134" ; 229 when ( wksht_cd = "S200001" and line_num = "05600" and clmn_num = "00100" ) varname = "s2_1_c1_56" ; 230 when ( wksht_cd = "S200001" and line_num = "03600" and clmn_num = "00100" ) varname = "s2_1_c1_36" ; 231 when ( wksht_cd = "S200001" and line_num = "03600" and clmn_num = "00200" ) varname = "s2_1_c2_36" ; 232 when ( wksht_cd = "S200001" and line_num = "03601" and clmn_num = "00100" ) varname = "s2_1_c1_3601" ; 233 when ( wksht_cd = "S200001" and line_num = "03601" and clmn_num = "00200" ) varname = "s2_1_c2_3601" ; 234 when ( wksht_cd = "S200001" and line_num = "10500" and clmn_num = "00100" ) varname = "s2_1_c1_105" ; 235 when ( wksht_cd = "S200001" and line_num = "10600" and clmn_num = "00100" ) varname = "s2_1_c1_106" ; 236 when ( wksht_cd = "S200001" and line_num = "10800" and clmn_num = "00100" ) varname = "s2_1_c1_108" ; 237 when ( wksht_cd = "S200001" and line_num = "11500" and clmn_num = "00100" ) varname = "s2_1_c1_115" ; 238 when ( wksht_cd = "S200001" and line_num = "11500" and clmn_num = "00200" ) varname = "s2_1_c2_115" ; 239 when ( wksht_cd = "S200001" and line_num = "04700" and clmn_num = "00100" ) varname = "s2_1_c1_47" ; 240 when ( wksht_cd = "S200001" and line_num = "08500" and clmn_num = "00100" ) varname = "s2_1_c1_85" ; 241 when ( wksht_cd = "S200001" and line_num = "08600" and clmn_num = "00100" ) varname = "s2_1_c1_86" ; 242 when ( wksht_cd = "S200001" and line_num = "04800" and clmn_num = "00100" ) varname = "s2_1_c1_48" ; 243 when ( wksht_cd = "S200001" and line_num = "02200" and clmn_num = "00100" ) varname = "s2_1_c1_22" ; 244 when ( wksht_cd = "S200001" and line_num = "09200" and clmn_num = "00100" ) varname = "s2_1_c1_92" ; 245 when ( wksht_cd = "S200001" and line_num = "09300" and clmn_num = "00100" ) varname = "s2_1_c1_93" ; 246 when ( wksht_cd = "S200001" and line_num = "14000" and clmn_num = "00100" ) varname = "s2_1_c1_140" ; 247 when ( wksht_cd = "S200001" and line_num = "14000" and clmn_num = "00200" ) varname = "s2_1_c2_140" ; 248 when ( wksht_cd = "S200001" and line_num = "14100" and clmn_num = "00100" ) varname = "s2_1_c1_141" ; 249 when ( wksht_cd = "S200001" and line_num = "14000" and clmn_num = "00200" ) varname = "s2_1_c2_140" ; 250 when ( wksht_cd = "S200001" and line_num = "14000" and clmn_num = "00300" ) varname = "s2_1_c3_140" ; 251 when ( wksht_cd = "S200001" and line_num = "14200" and clmn_num = "00100" ) varname = "s2_1_c1_142" ; 6 The SAS System 17:33 Monday, April 15, 2019 252 when ( wksht_cd = "S200001" and line_num = "14200" and clmn_num = "00200" ) varname = "s2_1_c2_142" ; 253 when ( wksht_cd = "S200001" and line_num = "14300" and clmn_num = "00100" ) varname = "s2_1_c1_143" ; 254 when ( wksht_cd = "S200001" and line_num = "14300" and clmn_num = "00200" ) varname = "s2_1_c2_143" ; 255 when ( wksht_cd = "S200001" and line_num = "14300" and clmn_num = "00300" ) varname = "s2_1_c3_143" ; 256 when ( wksht_cd = "S200001" and line_num = "14400" and clmn_num = "00100" ) varname = "s2_1_c1_144" ; 257 when ( wksht_cd = "S200001" and line_num = "14500" and clmn_num = "00100" ) varname = "s2_1_c1_145" ; 258 when ( wksht_cd = "S200001" and line_num = "03800" and clmn_num = "00100" ) varname = "s2_1_c1_38" ; 259 when ( wksht_cd = "S200001" and line_num = "03800" and clmn_num = "00200" ) varname = "s2_1_c2_38" ; 260 when ( wksht_cd = "S200001" and line_num = "03801" and clmn_num = "00100" ) varname = "s2_1_c1_3801" ; 261 when ( wksht_cd = "S200001" and line_num = "03801" and clmn_num = "00200" ) varname = "s2_1_c2_3801" ; 262 when ( wksht_cd = "S200001" and line_num = "06000" and clmn_num = "00100" ) varname = "s2_1_c1_60" ; 263 when ( wksht_cd = "S200001" and line_num = "10700" and clmn_num = "00100" ) varname = "s2_1_c1_107" ; 264 when ( wksht_cd = "S200001" and line_num = "10700" and clmn_num = "00200" ) varname = "s2_1_c2_107" ; 265 when ( wksht_cd = "S500000" and line_num = "02100" and clmn_num = "00100" ) varname = "s5_c1_21" ; 266 when ( wksht_cd = "S500000" and line_num = "02100" and clmn_num = "00200" ) varname = "s5_c2_21" ; 267 268 otherwise; 269 end; 270 run; 271 proc contents; 272 proc print data=out.&dataset ( obs = 50 ); 273 *where WKSHT_CD EQ "S200000" ; 274 %end; 275 %mend; 276 %loop(fyear=2010,lyear=2018); NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2552-10 NOTE: Data file OUT.HOSP_ALPHA2552_10_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 284410 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.50 seconds cpu time 0.46 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. NOTE: There were 284410 observations read from the data set WORK.ALPHA2010. NOTE: The data set OUT.ALPHA2010 has 284410 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.80 seconds cpu time 0.65 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. NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.16 seconds cpu time 0.02 seconds 7 The SAS System 17:33 Monday, April 15, 2019 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. NOTE: There were 50 observations read from the data set OUT.ALPHA2010. NOTE: The PROCEDURE PRINT printed page 2. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.HOSP_ALPHA2552_10_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 745777 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 1.13 seconds cpu time 1.13 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 745777 observations read from the data set WORK.ALPHA2011. NOTE: The data set OUT.ALPHA2011 has 745777 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.99 seconds cpu time 1.62 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: The PROCEDURE CONTENTS printed page 3. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.01 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 50 observations read from the data set OUT.ALPHA2011. NOTE: The PROCEDURE PRINT printed page 4. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.HOSP_ALPHA2552_10_2012_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.ALPHA2012 created, with 784656 rows and 5 columns. 8 The SAS System 17:33 Monday, April 15, 2019 NOTE: PROCEDURE SQL used (Total process time): real time 1.12 seconds cpu time 1.11 seconds NOTE: Data file OUT.ALPHA2012.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 784656 observations read from the data set WORK.ALPHA2012. NOTE: The data set OUT.ALPHA2012 has 784656 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 2.01 seconds cpu time 1.74 seconds NOTE: Data file OUT.ALPHA2012.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: The PROCEDURE CONTENTS printed page 5. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.ALPHA2012.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 50 observations read from the data set OUT.ALPHA2012. NOTE: The PROCEDURE PRINT printed page 6. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.HOSP_ALPHA2552_10_2013_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.ALPHA2013 created, with 827655 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 1.11 seconds cpu time 1.11 seconds NOTE: Data file OUT.ALPHA2013.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 827655 observations read from the data set WORK.ALPHA2013. NOTE: The data set OUT.ALPHA2013 has 827655 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 2.19 seconds cpu time 1.78 seconds 9 The SAS System 17:33 Monday, April 15, 2019 NOTE: Data file OUT.ALPHA2013.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: The PROCEDURE CONTENTS printed page 7. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: Data file OUT.ALPHA2013.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 50 observations read from the data set OUT.ALPHA2013. NOTE: The PROCEDURE PRINT printed page 8. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.HOSP_ALPHA2552_10_2014_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.ALPHA2014 created, with 853822 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 1.17 seconds cpu time 1.16 seconds NOTE: Data file OUT.ALPHA2014.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 853822 observations read from the data set WORK.ALPHA2014. NOTE: The data set OUT.ALPHA2014 has 853822 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 2.27 seconds cpu time 1.87 seconds NOTE: Data file OUT.ALPHA2014.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: The PROCEDURE CONTENTS printed page 9. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.ALPHA2014.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 50 observations read from the data set OUT.ALPHA2014. 10 The SAS System 17:33 Monday, April 15, 2019 NOTE: The PROCEDURE PRINT printed page 10. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Data file OUT.HOSP_ALPHA2552_10_2015_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.ALPHA2015 created, with 880521 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 1.14 seconds cpu time 1.14 seconds NOTE: Data file OUT.ALPHA2015.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 880521 observations read from the data set WORK.ALPHA2015. NOTE: The data set OUT.ALPHA2015 has 880521 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 3.47 seconds cpu time 2.13 seconds NOTE: Data file OUT.ALPHA2015.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: The PROCEDURE CONTENTS printed page 11. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: Data file OUT.ALPHA2015.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 50 observations read from the data set OUT.ALPHA2015. NOTE: The PROCEDURE PRINT printed page 12. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file OUT.HOSP_ALPHA2552_10_2016_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.ALPHA2016 created, with 894195 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 1.18 seconds cpu time 1.18 seconds 11 The SAS System 17:33 Monday, April 15, 2019 NOTE: Data file OUT.ALPHA2016.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 894195 observations read from the data set WORK.ALPHA2016. NOTE: The data set OUT.ALPHA2016 has 894195 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 2.38 seconds cpu time 1.97 seconds NOTE: Data file OUT.ALPHA2016.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: The PROCEDURE CONTENTS printed page 13. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: Data file OUT.ALPHA2016.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 50 observations read from the data set OUT.ALPHA2016. NOTE: The PROCEDURE PRINT printed page 14. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: Table WORK.ALPHA2017 created, with 900499 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.22 seconds cpu time 0.22 seconds NOTE: There were 900499 observations read from the data set WORK.ALPHA2017. NOTE: The data set OUT.ALPHA2017 has 900499 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 1.77 seconds cpu time 1.39 seconds NOTE: The PROCEDURE CONTENTS printed page 15. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 50 observations read from the data set OUT.ALPHA2017. NOTE: The PROCEDURE PRINT printed page 16. NOTE: PROCEDURE PRINT used (Total process time): 12 The SAS System 17:33 Monday, April 15, 2019 real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.ALPHA2018 created, with 144903 rows and 5 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.03 seconds NOTE: There were 144903 observations read from the data set WORK.ALPHA2018. NOTE: The data set OUT.ALPHA2018 has 144903 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.39 seconds cpu time 0.22 seconds NOTE: The PROCEDURE CONTENTS printed page 17. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 277 *%loop(fyear=2017,lyear=2017); 278 279 /* 280 Copyright 2012 shared by Jean Roth and the National Bureau of Economic Research 281 282 National Bureau of Economic Research. 283 1050 Massachusetts Avenue 284 Cambridge, MA 02138 285 jroth@nber.org 286 287 This program and all programs referenced in it are free software. You 288 can redistribute the program or modify it under the terms of the GNU 289 General Public License as published by the Free Software Foundation; 290 either version 2 of the License, or (at your option) any later version. 291 292 This program is distributed in the hope that it will be useful, 293 but WITHOUT ANY WARRANTY; without even the implied warranty of 294 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 295 GNU General Public License for more details. 296 297 You should have received a copy of the GNU General Public License 298 along with this program; if not, write to the Free Software 299 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 300 USA. 301 */ NOTE: There were 50 observations read from the data set OUT.ALPHA2018. NOTE: The PROCEDURE PRINT printed page 18. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 13 The SAS System 17:33 Monday, April 15, 2019 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 26.43 seconds cpu time 21.05 seconds