1 The SAS System 17:32 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.06 seconds cpu time 0.02 seconds 1 options nocenter; 2 options notes mlogic mprint symbolgen; 3 ** by Jean Roth, jroth@nber.org , 2010-12-15 ; 4 5 libname out "."; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2552-10 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=2552_10; 9 %let DASH=2552-10; 10 *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./&DASH."; 11 libname in "."; 12 13 %do year=2010 %to 2018; 14 15 *hosp_rpt2552_10_; 16 %let ds=&provider._&type.&form._&year._long; 17 *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) 17 ! nodupkey; 2 The SAS System 17:32 Monday, April 15, 2019 18 proc sort data=in.&ds. out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 19 by wksht_cd clmn_num line_num; 20 %end; 21 22 data out.&provider._&type4._wksht_clmn_line_combos; 23 set 24 _2010&type1. _2011&type1. _2012&type1. _2013&type1. _2014&type1. 25 _2015&type1. _2016&type1. _2017&type1. _2018&type1. 26 ; 27 28 proc sort data=out.&provider._&type4._wksht_clmn_line_combos nodupkey; 29 by wksht_cd line_num clmn_num ; 30 31 data out.&provider._&type4._wksht_clmn_line_combos; 32 retain wksht_cd line_num clmn_num; 33 set out.&provider._&type4._wksht_clmn_line_combos; 34 35 proc contents data=out.&provider._&type4._wksht_clmn_line_combos; 36 37 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.csv -o -y"; 38 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.dta -o -y"; 39 *x "echo 'combo done' | mail jroth"; 40 %mend loop; 41 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 42 *%loop(provider=hha,type=nmrc,type4=nmrc,type1=n); 43 %loop(provider=hosp,form=2552_10,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hosp MLOGIC(LOOP): Parameter FORM has value 2552_10 MLOGIC(LOOP): Parameter TYPE has value alpha MLOGIC(LOOP): Parameter TYPE4 has value alph MLOGIC(LOOP): Parameter TYPE1 has value a MLOGIC(LOOP): %LET (variable name is UNDERSCORE) MLOGIC(LOOP): %LET (variable name is DASH) MPRINT(LOOP): *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./&DASH."; MPRINT(LOOP): libname in "."; NOTE: Libref IN refers to the same physical library as OUT. NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2552-10 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 2010; stop value is 2018; by value is 1. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2010 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2010_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_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. 3 The SAS System 17:32 Monday, April 15, 2019 MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2011 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1351125 observations read from the data set IN.HOSP_ALPHA2552_10_2010_LONG. NOTE: 1331337 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 19788 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.64 seconds cpu time 1.02 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2011_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2011 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_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 iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2012 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3541657 observations read from the data set IN.HOSP_ALPHA2552_10_2011_LONG. NOTE: 3515073 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 26584 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.96 seconds cpu time 2.79 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2012_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2012 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2012_long out=_2012a (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 2013; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2013 4 The SAS System 17:32 Monday, April 15, 2019 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3603699 observations read from the data set IN.HOSP_ALPHA2552_10_2012_LONG. NOTE: 3577852 observations with duplicate key values were deleted. NOTE: The data set WORK._2012A has 25847 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.75 seconds cpu time 2.76 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2013_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2013 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2013_long out=_2013a (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 2014; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2014 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3672822 observations read from the data set IN.HOSP_ALPHA2552_10_2013_LONG. NOTE: 3646991 observations with duplicate key values were deleted. NOTE: The data set WORK._2013A has 25831 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.79 seconds cpu time 2.83 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2014_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2014 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2014_long out=_2014a (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 2015; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2015 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3681620 observations read from the data set IN.HOSP_ALPHA2552_10_2014_LONG. NOTE: 3655314 observations with duplicate key values were deleted. NOTE: The data set WORK._2014A has 26306 observations and 3 variables. 5 The SAS System 17:32 Monday, April 15, 2019 NOTE: PROCEDURE SORT used (Total process time): real time 1.81 seconds cpu time 2.85 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2015_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2015_long out=_2015a (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 2016; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2016 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3680230 observations read from the data set IN.HOSP_ALPHA2552_10_2015_LONG. NOTE: 3653951 observations with duplicate key values were deleted. NOTE: The data set WORK._2015A has 26279 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.97 seconds cpu time 2.99 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2016_long NOTE: Data file IN.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. SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2016_long out=_2016a (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 2017; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2017 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3673063 observations read from the data set IN.HOSP_ALPHA2552_10_2016_LONG. NOTE: 3646469 observations with duplicate key values were deleted. NOTE: The data set WORK._2016A has 26594 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.74 seconds cpu time 2.82 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2017_long 6 The SAS System 17:32 Monday, April 15, 2019 SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2017_long out=_2017a (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 2018; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2018 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 3645078 observations read from the data set IN.HOSP_ALPHA2552_10_2017_LONG. NOTE: 3619774 observations with duplicate key values were deleted. NOTE: The data set WORK._2017A has 25304 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.90 seconds cpu time 1.55 seconds SYMBOLGEN: Macro variable DS resolves to hosp_alpha2552_10_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hosp_alpha2552_10_2018_long out=_2018a (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 2019; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 591757 observations read from the data set IN.HOSP_ALPHA2552_10_2018_LONG. NOTE: 579152 observations with duplicate key values were deleted. NOTE: The data set WORK._2018A has 12605 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.23 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 MPRINT(LOOP): set _2010a _2011a _2012a _2013a _2014a _2015a _2016a _2017a _2018a ; 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 19788 observations read from the data set WORK._2010A. NOTE: There were 26584 observations read from the data set WORK._2011A. NOTE: There were 25847 observations read from the data set WORK._2012A. NOTE: There were 25831 observations read from the data set WORK._2013A. 7 The SAS System 17:32 Monday, April 15, 2019 NOTE: There were 26306 observations read from the data set WORK._2014A. NOTE: There were 26279 observations read from the data set WORK._2015A. NOTE: There were 26594 observations read from the data set WORK._2016A. NOTE: There were 25304 observations read from the data set WORK._2017A. NOTE: There were 12605 observations read from the data set WORK._2018A. NOTE: The data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS has 215138 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.06 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 line_num clmn_num ; 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. NOTE: There were 215138 observations read from the data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 176336 observations with duplicate key values were deleted. NOTE: The data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS has 38802 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.10 seconds cpu time 0.11 seconds MPRINT(LOOP): data out.hosp_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set 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. 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 38802 observations read from the data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HOSP_ALPH_WKSHT_CLMN_LINE_COMBOS has 38802 observations and 3 variables. NOTE: DATA statement 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 8 The SAS System 17:32 Monday, April 15, 2019 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 -o -y"; 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 -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 44 %loop(provider=hosp,form=2552_10,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hosp MLOGIC(LOOP): Parameter FORM has value 2552_10 MLOGIC(LOOP): Parameter TYPE has value nmrc MLOGIC(LOOP): Parameter TYPE4 has value nmrc MLOGIC(LOOP): Parameter TYPE1 has value n MLOGIC(LOOP): %LET (variable name is UNDERSCORE) MLOGIC(LOOP): %LET (variable name is DASH) MPRINT(LOOP): *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./&DASH."; MPRINT(LOOP): libname in "."; NOTE: Libref IN refers to the same physical library as OUT. NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2552-10 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 2010; stop value is 2018; by value is 1. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2010 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.36 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2010_long NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_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. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2011 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 9 The SAS System 17:32 Monday, April 15, 2019 NOTE: There were 7405679 observations read from the data set IN.HOSP_NMRC2552_10_2010_LONG. NOTE: 7239491 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 166188 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.13 seconds cpu time 5.32 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2011_long NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2011 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_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 iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2012 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19350678 observations read from the data set IN.HOSP_NMRC2552_10_2011_LONG. NOTE: 19116253 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 234425 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 8.51 seconds cpu time 13.45 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2012_long NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2012 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2012_long out=_2012n (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 2013; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2013 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19693332 observations read from the data set IN.HOSP_NMRC2552_10_2012_LONG. NOTE: 19458413 observations with duplicate key values were deleted. NOTE: The data set WORK._2012N has 234919 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 7.58 seconds 10 The SAS System 17:32 Monday, April 15, 2019 cpu time 12.69 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2013_long NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2013 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2013_long out=_2013n (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 2014; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2014 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19917241 observations read from the data set IN.HOSP_NMRC2552_10_2013_LONG. NOTE: 19685184 observations with duplicate key values were deleted. NOTE: The data set WORK._2013N has 232057 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 7.20 seconds cpu time 11.86 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2014_long NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2014 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2014_long out=_2014n (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 2015; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2015 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19840746 observations read from the data set IN.HOSP_NMRC2552_10_2014_LONG. NOTE: 19604920 observations with duplicate key values were deleted. NOTE: The data set WORK._2014N has 235826 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 9.38 seconds cpu time 14.93 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2015_long NOTE: Data file IN.HOSP_NMRC2552_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 11 The SAS System 17:32 Monday, April 15, 2019 might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2015_long out=_2015n (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 2016; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2016 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19713742 observations read from the data set IN.HOSP_NMRC2552_10_2015_LONG. NOTE: 19475259 observations with duplicate key values were deleted. NOTE: The data set WORK._2015N has 238483 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 8.03 seconds cpu time 13.17 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2016_long NOTE: Data file IN.HOSP_NMRC2552_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. SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2016_long out=_2016n (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 2017; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2017 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19518961 observations read from the data set IN.HOSP_NMRC2552_10_2016_LONG. NOTE: 19281791 observations with duplicate key values were deleted. NOTE: The data set WORK._2016N has 237170 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 8.56 seconds cpu time 13.91 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2017_long out=_2017n (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 2018; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_10_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hosp 12 The SAS System 17:32 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2552_10 SYMBOLGEN: Macro variable YEAR resolves to 2018 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 19264045 observations read from the data set IN.HOSP_NMRC2552_10_2017_LONG. NOTE: 19028635 observations with duplicate key values were deleted. NOTE: The data set WORK._2017N has 235410 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.66 seconds cpu time 7.61 seconds SYMBOLGEN: Macro variable DS resolves to hosp_nmrc2552_10_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hosp_nmrc2552_10_2018_long out=_2018n (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 2019; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 3309037 observations read from the data set IN.HOSP_NMRC2552_10_2018_LONG. NOTE: 3202703 observations with duplicate key values were deleted. NOTE: The data set WORK._2018N has 106334 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.68 seconds cpu time 1.24 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 MPRINT(LOOP): set _2010n _2011n _2012n _2013n _2014n _2015n _2016n _2017n _2018n ; 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 166188 observations read from the data set WORK._2010N. NOTE: There were 234425 observations read from the data set WORK._2011N. NOTE: There were 234919 observations read from the data set WORK._2012N. NOTE: There were 232057 observations read from the data set WORK._2013N. NOTE: There were 235826 observations read from the data set WORK._2014N. NOTE: There were 238483 observations read from the data set WORK._2015N. NOTE: There were 237170 observations read from the data set WORK._2016N. NOTE: There were 235410 observations read from the data set WORK._2017N. NOTE: There were 106334 observations read from the data set WORK._2018N. NOTE: The data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS has 1920812 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.75 seconds 13 The SAS System 17:32 Monday, April 15, 2019 cpu time 0.51 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 line_num clmn_num ; 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. NOTE: There were 1920812 observations read from the data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 1588137 observations with duplicate key values were deleted. NOTE: The data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS has 332675 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.09 seconds cpu time 1.21 seconds MPRINT(LOOP): data out.hosp_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to hosp SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set 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. 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 332675 observations read from the data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HOSP_NMRC_WKSHT_CLMN_LINE_COMBOS has 332675 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.16 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 -o -y"; 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 -o -y"; 14 The SAS System 17:32 Monday, April 15, 2019 MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 45 *%loop(provider=rnl,type=alpha,type4=alph,type1=a); 46 *%loop(provider=rnl,type=nmrc,type4=nmrc,type1=n); 47 *%loop(provider=snf,type=alpha,type4=alph,type1=a); 48 *%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.92 seconds cpu time 0.00 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 1:14.29 cpu time 1:56.15