1 The SAS System 17:37 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.14 seconds cpu time 0.04 seconds 1 options nocenter; 2 options notes mlogic mprint symbolgen; 3 ** by Jean Roth, jroth@nber.org , 2010-12-15 ; 4 5 libname out "/homes/data/hcris/2552-96"; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /homes/data/hcris/2552-96 6 7 %macro loop(provider=,type=,type4=,type1=); 8 *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./"; 9 libname in "/homes/data/hcris/2552-96"; 10 11 %do year=1995 %to 2011; 12 proc sort data=in.&provider._&type.2552_96_&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 13 by wksht_cd clmn_num line_num; 14 %end; 15 16 data out.&provider._&type4._wksht_clmn_line_combos; 17 set _1995&type1. _1996&type1. _1997&type1. _1998&type1. _1999&type1. 18 _2000&type1. _2001&type1. _2002&type1. _2003&type1. _2004&type1. 2 The SAS System 17:37 Monday, April 15, 2019 19 _2005&type1. _2006&type1. _2007&type1. _2008&type1. _2009&type1. 20 _2010&type1. _2011&type1. 21 ; 22 23 proc sort data=out.&provider._&type4._wksht_clmn_line_combos nodupkey; 24 by wksht_cd clmn_num line_num; 25 26 proc contents data=out.&provider._&type4._wksht_clmn_line_combos; 27 28 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.csv -y -o"; 29 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.dta -y -o"; 30 *x "echo 'combo done' | mail jroth"; 31 %mend loop; 32 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 33 *%loop(provider=hha,type=nmrc,type4=nmrc,type1=n); 34 %loop(provider=hosp,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hosp MLOGIC(LOOP): Parameter TYPE has value alpha MLOGIC(LOOP): Parameter TYPE4 has value alph MLOGIC(LOOP): Parameter TYPE1 has value a MPRINT(LOOP): *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./"; MPRINT(LOOP): libname in "/homes/data/hcris/2552-96"; NOTE: Libref IN refers to the same physical library as OUT. NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /homes/data/hcris/2552-96 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1995; stop value is 2011; by value is 1. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1995 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_1995_long out=_1995a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1996; loop will iterate again. NOTE: There were 141 observations read from the data set IN.HOSP_ALPHA2552_96_1995_LONG. NOTE: 45 observations with duplicate key values were deleted. NOTE: The data set WORK._1995A has 96 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1996 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_1996_long out=_1996a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; 3 The SAS System 17:37 Monday, April 15, 2019 MLOGIC(LOOP): %DO loop index variable YEAR is now 1997; loop will iterate again. NOTE: There were 671179 observations read from the data set IN.HOSP_ALPHA2552_96_1996_LONG. NOTE: 668957 observations with duplicate key values were deleted. NOTE: The data set WORK._1996A has 2222 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.41 seconds cpu time 0.57 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1997 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_1997_long out=_1997a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1998; loop will iterate again. NOTE: There were 739730 observations read from the data set IN.HOSP_ALPHA2552_96_1997_LONG. NOTE: 737043 observations with duplicate key values were deleted. NOTE: The data set WORK._1997A has 2687 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.35 seconds cpu time 0.56 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1998 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_1998_long out=_1998a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1999; loop will iterate again. NOTE: There were 808472 observations read from the data set IN.HOSP_ALPHA2552_96_1998_LONG. NOTE: 804836 observations with duplicate key values were deleted. NOTE: The data set WORK._1998A has 3636 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.38 seconds cpu time 0.60 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1999 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable TYPE1 resolves to a 4 The SAS System 17:37 Monday, April 15, 2019 MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_1999_long out=_1999a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2000; loop will iterate again. NOTE: There were 832214 observations read from the data set IN.HOSP_ALPHA2552_96_1999_LONG. NOTE: 828736 observations with duplicate key values were deleted. NOTE: The data set WORK._1999A has 3478 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.43 seconds cpu time 0.64 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: Data file IN.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 be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2000 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2000_long out=_2000a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2001; loop will iterate again. NOTE: There were 888813 observations read from the data set IN.HOSP_ALPHA2552_96_2000_LONG. NOTE: 885199 observations with duplicate key values were deleted. NOTE: The data set WORK._2000A has 3614 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.44 seconds cpu time 0.71 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2001_long out=_2001a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2002; loop will iterate again. NOTE: There were 966419 observations read from the data set IN.HOSP_ALPHA2552_96_2001_LONG. NOTE: 962772 observations with duplicate key values were deleted. NOTE: The data set WORK._2001A has 3647 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.46 seconds cpu time 0.75 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: Data file IN.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. 5 The SAS System 17:37 Monday, April 15, 2019 SYMBOLGEN: Macro variable YEAR resolves to 2002 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2002_long out=_2002a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2003; loop will iterate again. NOTE: There were 1031734 observations read from the data set IN.HOSP_ALPHA2552_96_2002_LONG. NOTE: 1028281 observations with duplicate key values were deleted. NOTE: The data set WORK._2002A has 3453 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.46 seconds cpu time 0.72 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2003 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2003_long out=_2003a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2004; loop will iterate again. NOTE: There were 1083852 observations read from the data set IN.HOSP_ALPHA2552_96_2003_LONG. NOTE: 1080404 observations with duplicate key values were deleted. NOTE: The data set WORK._2003A has 3448 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.83 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2004 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2004_long out=_2004a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2005; loop will iterate again. NOTE: There were 1053152 observations read from the data set IN.HOSP_ALPHA2552_96_2004_LONG. NOTE: 1049592 observations with duplicate key values were deleted. NOTE: The data set WORK._2004A has 3560 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.50 seconds cpu time 0.81 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: Data file IN.HOSP_ALPHA2552_96_2005_LONG.DATA is in a format that is native to another host, or the file encoding does not 6 The SAS System 17:37 Monday, April 15, 2019 match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2005 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2005_long out=_2005a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2006; loop will iterate again. NOTE: There were 1079040 observations read from the data set IN.HOSP_ALPHA2552_96_2005_LONG. NOTE: 1075289 observations with duplicate key values were deleted. NOTE: The data set WORK._2005A has 3751 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.81 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2006_long out=_2006a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2007; loop will iterate again. NOTE: There were 1087530 observations read from the data set IN.HOSP_ALPHA2552_96_2006_LONG. NOTE: 1083812 observations with duplicate key values were deleted. NOTE: The data set WORK._2006A has 3718 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.83 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2007_long out=_2007a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2008; loop will iterate again. NOTE: There were 1069432 observations read from the data set IN.HOSP_ALPHA2552_96_2007_LONG. NOTE: 1065627 observations with duplicate key values were deleted. NOTE: The data set WORK._2007A has 3805 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.81 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha 7 The SAS System 17:37 Monday, April 15, 2019 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2008 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2008_long out=_2008a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2009; loop will iterate again. NOTE: There were 1083547 observations read from the data set IN.HOSP_ALPHA2552_96_2008_LONG. NOTE: 1079886 observations with duplicate key values were deleted. NOTE: The data set WORK._2008A has 3661 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.81 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2009_long out=_2009a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2010; loop will iterate again. NOTE: There were 1081784 observations read from the data set IN.HOSP_ALPHA2552_96_2009_LONG. NOTE: 1078767 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 3017 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.82 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2010_long out=_2010a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2011; loop will iterate again. NOTE: There were 676198 observations read from the data set IN.HOSP_ALPHA2552_96_2010_LONG. NOTE: 673302 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 2896 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.31 seconds cpu time 0.49 seconds 8 The SAS System 17:37 Monday, April 15, 2019 SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2011 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_96_2011_long out=_2011a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 4321 observations read from the data set IN.HOSP_ALPHA2552_96_2011_LONG. NOTE: 3815 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 506 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.hosp_alph_wksht_clmn_line_combos; SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): set _1995a _1996a _1997a _1998a _1999a _2000a _2001a _2002a _2003a _2004a _2005a _2006a _2007a _2008a _2009a _2010a _2011a ; NOTE: Data file OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS.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 96 observations read from the data set WORK._1995A. NOTE: There were 2222 observations read from the data set WORK._1996A. NOTE: There were 2687 observations read from the data set WORK._1997A. NOTE: There were 3636 observations read from the data set WORK._1998A. NOTE: There were 3478 observations read from the data set WORK._1999A. NOTE: There were 3614 observations read from the data set WORK._2000A. NOTE: There were 3647 observations read from the data set WORK._2001A. NOTE: There were 3453 observations read from the data set WORK._2002A. NOTE: There were 3448 observations read from the data set WORK._2003A. NOTE: There were 3560 observations read from the data set WORK._2004A. NOTE: There were 3751 observations read from the data set WORK._2005A. NOTE: There were 3718 observations read from the data set WORK._2006A. 9 The SAS System 17:37 Monday, April 15, 2019 NOTE: There were 3805 observations read from the data set WORK._2007A. NOTE: There were 3661 observations read from the data set WORK._2008A. NOTE: There were 3017 observations read from the data set WORK._2009A. NOTE: There were 2896 observations read from the data set WORK._2010A. NOTE: There were 506 observations read from the data set WORK._2011A. NOTE: The data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS has 51195 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS.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. MPRINT(LOOP): proc sort data=out.hosp_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; NOTE: Data file OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS.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 51195 observations read from the data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 45252 observations with duplicate key values were deleted. NOTE: The data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS has 5943 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.hosp_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS.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. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hosp_alph_wksht_clmn_line_combos.sas7bdat hosp_alph_wksht_clmn_line_combos.csv -y -o"; SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hosp_alph_wksht_clmn_line_combos.sas7bdat hosp_alph_wksht_clmn_line_combos.dta -y -o"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 35 %loop(provider=hosp,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hosp MLOGIC(LOOP): Parameter TYPE has value nmrc MLOGIC(LOOP): Parameter TYPE4 has value nmrc MLOGIC(LOOP): Parameter TYPE1 has value n MPRINT(LOOP): *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./"; MPRINT(LOOP): libname in "/homes/data/hcris/2552-96"; NOTE: Libref IN refers to the same physical library as OUT. NOTE: Libref IN was successfully assigned as follows: Engine: V9 10 The SAS System 17:37 Monday, April 15, 2019 Physical Name: /homes/data/hcris/2552-96 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1995; stop value is 2011; by value is 1. NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.33 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 1995 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_1995_long out=_1995n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1996; loop will iterate again. NOTE: There were 2878 observations read from the data set IN.HOSP_NMRC2552_96_1995_LONG. NOTE: 712 observations with duplicate key values were deleted. NOTE: The data set WORK._1995N has 2166 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 1996 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_1996_long out=_1996n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1997; loop will iterate again. NOTE: There were 12480099 observations read from the data set IN.HOSP_NMRC2552_96_1996_LONG. NOTE: 12364930 observations with duplicate key values were deleted. NOTE: The data set WORK._1996N has 115169 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.42 seconds cpu time 8.94 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 1997 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_1997_long out=_1997n (keep=wksht_cd clmn_num line_num) nodupkey; 11 The SAS System 17:37 Monday, April 15, 2019 MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1998; loop will iterate again. NOTE: There were 13468819 observations read from the data set IN.HOSP_NMRC2552_96_1997_LONG. NOTE: 13342967 observations with duplicate key values were deleted. NOTE: The data set WORK._1997N has 125852 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.75 seconds cpu time 9.50 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 1998 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_1998_long out=_1998n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1999; loop will iterate again. NOTE: There were 13440407 observations read from the data set IN.HOSP_NMRC2552_96_1998_LONG. NOTE: 13314632 observations with duplicate key values were deleted. NOTE: The data set WORK._1998N has 125775 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.66 seconds cpu time 9.81 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 1999 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_1999_long out=_1999n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2000; loop will iterate again. NOTE: There were 13272724 observations read from the data set IN.HOSP_NMRC2552_96_1999_LONG. NOTE: 13146584 observations with duplicate key values were deleted. NOTE: The data set WORK._1999N has 126140 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.09 seconds cpu time 8.96 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: Data file IN.HOSP_NMRC2552_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 be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2000 12 The SAS System 17:37 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2000_long out=_2000n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2001; loop will iterate again. NOTE: There were 13744977 observations read from the data set IN.HOSP_NMRC2552_96_2000_LONG. NOTE: 13614018 observations with duplicate key values were deleted. NOTE: The data set WORK._2000N has 130959 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.25 seconds cpu time 9.09 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2001_long out=_2001n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2002; loop will iterate again. NOTE: There were 11906442 observations read from the data set IN.HOSP_NMRC2552_96_2001_LONG. NOTE: 11785348 observations with duplicate key values were deleted. NOTE: The data set WORK._2001N has 121094 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.93 seconds cpu time 8.17 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2002 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2002_long out=_2002n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2003; loop will iterate again. NOTE: There were 11283771 observations read from the data set IN.HOSP_NMRC2552_96_2002_LONG. NOTE: 11166882 observations with duplicate key values were deleted. NOTE: The data set WORK._2002N has 116889 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.56 seconds cpu time 8.23 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: Data file IN.HOSP_NMRC2552_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 13 The SAS System 17:37 Monday, April 15, 2019 might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2003 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2003_long out=_2003n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2004; loop will iterate again. NOTE: There were 11088199 observations read from the data set IN.HOSP_NMRC2552_96_2003_LONG. NOTE: 10974543 observations with duplicate key values were deleted. NOTE: The data set WORK._2003N has 113656 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.58 seconds cpu time 7.77 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2004 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2004_long out=_2004n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2005; loop will iterate again. NOTE: There were 11089062 observations read from the data set IN.HOSP_NMRC2552_96_2004_LONG. NOTE: 10977480 observations with duplicate key values were deleted. NOTE: The data set WORK._2004N has 111582 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.62 seconds cpu time 7.54 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2005 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2005_long out=_2005n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2006; loop will iterate again. NOTE: There were 10989547 observations read from the data set IN.HOSP_NMRC2552_96_2005_LONG. NOTE: 10878131 observations with duplicate key values were deleted. NOTE: The data set WORK._2005N has 111416 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.47 seconds cpu time 7.71 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2006 14 The SAS System 17:37 Monday, April 15, 2019 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2006_long out=_2006n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2007; loop will iterate again. NOTE: There were 10825459 observations read from the data set IN.HOSP_NMRC2552_96_2006_LONG. NOTE: 10716330 observations with duplicate key values were deleted. NOTE: The data set WORK._2006N has 109129 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.45 seconds cpu time 7.59 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2007_long out=_2007n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2008; loop will iterate again. NOTE: There were 10617576 observations read from the data set IN.HOSP_NMRC2552_96_2007_LONG. NOTE: 10507521 observations with duplicate key values were deleted. NOTE: The data set WORK._2007N has 110055 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.07 seconds cpu time 7.95 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2008 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2008_long out=_2008n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2009; loop will iterate again. NOTE: There were 10533464 observations read from the data set IN.HOSP_NMRC2552_96_2008_LONG. NOTE: 10423717 observations with duplicate key values were deleted. NOTE: The data set WORK._2008N has 109747 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.73 seconds cpu time 7.96 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp 15 The SAS System 17:37 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2009_long out=_2009n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2010; loop will iterate again. NOTE: There were 10397286 observations read from the data set IN.HOSP_NMRC2552_96_2009_LONG. NOTE: 10285470 observations with duplicate key values were deleted. NOTE: The data set WORK._2009N has 111816 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 5.71 seconds cpu time 8.32 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2010_long out=_2010n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2011; loop will iterate again. NOTE: There were 6382172 observations read from the data set IN.HOSP_NMRC2552_96_2010_LONG. NOTE: 6293611 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 88561 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.64 seconds cpu time 4.46 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2011 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_96_2011_long out=_2011n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 33641 observations read from the data set IN.HOSP_NMRC2552_96_2011_LONG. NOTE: 26127 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 7514 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.37 seconds 16 The SAS System 17:37 Monday, April 15, 2019 cpu time 0.01 seconds MPRINT(LOOP): data out.hosp_nmrc_wksht_clmn_line_combos; SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): set _1995n _1996n _1997n _1998n _1999n _2000n _2001n _2002n _2003n _2004n _2005n _2006n _2007n _2008n _2009n _2010n _2011n ; NOTE: Data file OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS.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 2166 observations read from the data set WORK._1995N. NOTE: There were 115169 observations read from the data set WORK._1996N. NOTE: There were 125852 observations read from the data set WORK._1997N. NOTE: There were 125775 observations read from the data set WORK._1998N. NOTE: There were 126140 observations read from the data set WORK._1999N. NOTE: There were 130959 observations read from the data set WORK._2000N. NOTE: There were 121094 observations read from the data set WORK._2001N. NOTE: There were 116889 observations read from the data set WORK._2002N. NOTE: There were 113656 observations read from the data set WORK._2003N. NOTE: There were 111582 observations read from the data set WORK._2004N. NOTE: There were 111416 observations read from the data set WORK._2005N. NOTE: There were 109129 observations read from the data set WORK._2006N. NOTE: There were 110055 observations read from the data set WORK._2007N. NOTE: There were 109747 observations read from the data set WORK._2008N. NOTE: There were 111816 observations read from the data set WORK._2009N. NOTE: There were 88561 observations read from the data set WORK._2010N. NOTE: There were 7514 observations read from the data set WORK._2011N. NOTE: The data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS has 1737520 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.62 seconds cpu time 0.49 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS.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. MPRINT(LOOP): proc sort data=out.hosp_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; NOTE: Data file OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS.DATA is in a format that is native to another host, or the file encoding does 17 The SAS System 17:37 Monday, April 15, 2019 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 1737520 observations read from the data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 1508556 observations with duplicate key values were deleted. NOTE: The data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS has 228964 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.50 seconds cpu time 0.83 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.hosp_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS.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. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hosp_nmrc_wksht_clmn_line_combos.sas7bdat hosp_nmrc_wksht_clmn_line_combos.csv -y -o"; SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hosp_nmrc_wksht_clmn_line_combos.sas7bdat hosp_nmrc_wksht_clmn_line_combos.dta -y -o"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 36 *%loop(provider=rnl,type=alpha,type4=alph,type1=a); 37 *%loop(provider=rnl,type=nmrc,type4=nmrc,type1=n); 38 *%loop(provider=snf,type=alpha,type4=alph,type1=a); 39 *%loop(provider=snf,type=nmrc,type4=nmrc,type1=n); NOTE: The PROCEDURE CONTENTS printed page 2. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.74 seconds cpu time 0.01 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 1:23.86 cpu time 2:14.28