1 The SAS System 12:35 Wednesday, October 24, 2018 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 2.6.32-696.18.7.el6.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.1 NOTE: Additional host information: Linux LIN X64 2.6.32-696.18.7.el6.x86_64 #1 SMP Wed Jan 3 19:31:16 CST 2018 x86_64 Scientific Linux release 6.9 (Carbon) 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.09 seconds cpu time 0.00 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/1984-99 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=1984_99; 9 %let DASH=1984-99; 10 ** SAS has a limit of 32-characters to a dataset name, so making a shorter name ; 11 %let prov=%substr(&provider.,1,3); 12 libname in "."; 13 14 %do year=1999 %to 2014; 15 16 %let ds=&provider._&type.&form._&year._long; 17 proc sort data=in.&ds. out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 18 by wksht_cd clmn_num line_num; 2 The SAS System 12:35 Wednesday, October 24, 2018 19 %end; 20 21 data out.hos_&type4._wksht_clmn_line_combos; 22 set 23 _1999&type1. 24 _2000&type1. _2001&type1. _2002&type1. _2003&type1. _2004&type1. 25 _2005&type1. _2006&type1. _2007&type1. _2008&type1. _2009&type1. 26 _2010&type1. _2011&type1. _2012&type1. _2013&type1. _2014&type1. 27 ; 28 29 proc sort data=out.&prov._&type4._wksht_clmn_line_combos nodupkey; 30 by wksht_cd line_num clmn_num ; 31 32 data out.&prov._&type4._wksht_clmn_line_combos; 33 retain wksht_cd line_num clmn_num; 34 set out.&prov._&type4._wksht_clmn_line_combos; 35 36 proc contents data=out.&prov._&type4._wksht_clmn_line_combos; 37 38 x "st &prov._&type4._wksht_clmn_line_combos.sas7bdat &prov._&type4._wksht_clmn_line_combos.csv -o -y"; 39 x "st &prov._&type4._wksht_clmn_line_combos.sas7bdat &prov._&type4._wksht_clmn_line_combos.dta -o -y"; 40 *x "echo 'combo done' | mail jroth"; 41 %mend loop; 42 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 43 *%loop(provider=hha,type=nmrc,type4=nmrc,type1=n); 44 *%loop(provider=hosp,form=2552_10,type=alpha,type4=alph,type1=a); 45 *%loop(provider=hosp,form=2552_10,type=nmrc,type4=nmrc,type1=n); 46 %loop(provider=hospc,form=1984_99,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hospc MLOGIC(LOOP): Parameter FORM has value 1984_99 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): ** SAS has a limit of 32-characters to a dataset name, so making a shorter name ; MLOGIC(LOOP): %LET (variable name is PROV) SYMBOLGEN: Macro variable PROVIDER resolves to hospc 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/1984-99 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1999; stop value is 2014; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_1999_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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 MPRINT(LOOP): proc sort data=in.hospc_alpha1984_99_1999_long out=_1999a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; 3 The SAS System 12:35 Wednesday, October 24, 2018 MLOGIC(LOOP): %DO loop index variable YEAR is now 2000; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: There were 4656 observations read from the data set IN.HOSPC_ALPHA1984_99_1999_LONG. NOTE: 4394 observations with duplicate key values were deleted. NOTE: The data set WORK._1999A has 262 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.05 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2000_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: There were 22921 observations read from the data set IN.HOSPC_ALPHA1984_99_2000_LONG. NOTE: 22530 observations with duplicate key values were deleted. NOTE: The data set WORK._2000A has 391 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2001_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: There were 21812 observations read from the data set IN.HOSPC_ALPHA1984_99_2001_LONG. NOTE: 21396 observations with duplicate key values were deleted. NOTE: The data set WORK._2001A has 416 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds 4 The SAS System 12:35 Wednesday, October 24, 2018 cpu time 0.02 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2002_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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 a MPRINT(LOOP): proc sort data=in.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: There were 25133 observations read from the data set IN.HOSPC_ALPHA1984_99_2002_LONG. NOTE: 24808 observations with duplicate key values were deleted. NOTE: The data set WORK._2002A has 325 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2003_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: There were 29234 observations read from the data set IN.HOSPC_ALPHA1984_99_2003_LONG. NOTE: 28793 observations with duplicate key values were deleted. NOTE: The data set WORK._2003A has 441 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2004_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. 5 The SAS System 12:35 Wednesday, October 24, 2018 MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: There were 122289 observations read from the data set IN.HOSPC_ALPHA1984_99_2004_LONG. NOTE: 121554 observations with duplicate key values were deleted. NOTE: The data set WORK._2004A has 735 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.07 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2005_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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 a MPRINT(LOOP): proc sort data=in.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: There were 163886 observations read from the data set IN.HOSPC_ALPHA1984_99_2005_LONG. NOTE: 163217 observations with duplicate key values were deleted. NOTE: The data set WORK._2005A has 669 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.09 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2006_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: There were 194039 observations read from the data set IN.HOSPC_ALPHA1984_99_2006_LONG. NOTE: 193320 observations with duplicate key values were deleted. NOTE: The data set WORK._2006A has 719 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.11 seconds cpu time 0.11 seconds 6 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2007_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: There were 220700 observations read from the data set IN.HOSPC_ALPHA1984_99_2007_LONG. NOTE: 219975 observations with duplicate key values were deleted. NOTE: The data set WORK._2007A has 725 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.12 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2008_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: There were 249031 observations read from the data set IN.HOSPC_ALPHA1984_99_2008_LONG. NOTE: 248218 observations with duplicate key values were deleted. NOTE: The data set WORK._2008A has 813 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.14 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2009_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) 7 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: There were 261917 observations read from the data set IN.HOSPC_ALPHA1984_99_2009_LONG. NOTE: 261153 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 764 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.15 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2010_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 269888 observations read from the data set IN.HOSPC_ALPHA1984_99_2010_LONG. NOTE: 269058 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 830 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.16 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2011_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2012 NOTE: There were 279669 observations read from the data set IN.HOSPC_ALPHA1984_99_2011_LONG. NOTE: 278907 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 762 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.13 seconds cpu time 0.16 seconds 8 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2012_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2013 NOTE: There were 297263 observations read from the data set IN.HOSPC_ALPHA1984_99_2012_LONG. NOTE: 296327 observations with duplicate key values were deleted. NOTE: The data set WORK._2012A has 936 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.18 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2013_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2014 NOTE: There were 316521 observations read from the data set IN.HOSPC_ALPHA1984_99_2013_LONG. NOTE: 315433 observations with duplicate key values were deleted. NOTE: The data set WORK._2013A has 1088 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.19 seconds SYMBOLGEN: Macro variable DS resolves to hospc_alpha1984_99_2014_long NOTE: Data file IN.HOSPC_ALPHA1984_99_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.hospc_alpha1984_99_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 not iterate again. SYMBOLGEN: Macro variable TYPE4 resolves to alph 9 The SAS System 12:35 Wednesday, October 24, 2018 NOTE: There were 330260 observations read from the data set IN.HOSPC_ALPHA1984_99_2014_LONG. NOTE: 329238 observations with duplicate key values were deleted. NOTE: The data set WORK._2014A has 1022 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.62 seconds cpu time 0.19 seconds MPRINT(LOOP): data out.hos_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 MPRINT(LOOP): set _1999a _2000a _2001a _2002a _2003a _2004a _2005a _2006a _2007a _2008a _2009a _2010a _2011a _2012a _2013a _2014a ; NOTE: Data file OUT.HOS_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 262 observations read from the data set WORK._1999A. NOTE: There were 391 observations read from the data set WORK._2000A. NOTE: There were 416 observations read from the data set WORK._2001A. NOTE: There were 325 observations read from the data set WORK._2002A. NOTE: There were 441 observations read from the data set WORK._2003A. NOTE: There were 735 observations read from the data set WORK._2004A. NOTE: There were 669 observations read from the data set WORK._2005A. NOTE: There were 719 observations read from the data set WORK._2006A. NOTE: There were 725 observations read from the data set WORK._2007A. NOTE: There were 813 observations read from the data set WORK._2008A. NOTE: There were 764 observations read from the data set WORK._2009A. NOTE: There were 830 observations read from the data set WORK._2010A. NOTE: There were 762 observations read from the data set WORK._2011A. NOTE: There were 936 observations read from the data set WORK._2012A. NOTE: There were 1088 observations read from the data set WORK._2013A. NOTE: There were 1022 observations read from the data set WORK._2014A. NOTE: The data set OUT.HOS_ALPH_WKSHT_CLMN_LINE_COMBOS has 10898 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HOS_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. 10 The SAS System 12:35 Wednesday, October 24, 2018 MPRINT(LOOP): proc sort data=out.hos_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HOS_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 10898 observations read from the data set OUT.HOS_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 9379 observations with duplicate key values were deleted. NOTE: The data set OUT.HOS_ALPH_WKSHT_CLMN_LINE_COMBOS has 1519 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.hos_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set out.hos_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HOS_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.HOS_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 1519 observations read from the data set OUT.HOS_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HOS_ALPH_WKSHT_CLMN_LINE_COMBOS has 1519 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.hos_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HOS_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 PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hos_alph_wksht_clmn_line_combos.sas7bdat hos_alph_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hos_alph_wksht_clmn_line_combos.sas7bdat hos_alph_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 47 %loop(provider=hospc,form=1984_99,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hospc MLOGIC(LOOP): Parameter FORM has value 1984_99 MLOGIC(LOOP): Parameter TYPE has value nmrc MLOGIC(LOOP): Parameter TYPE4 has value nmrc 11 The SAS System 12:35 Wednesday, October 24, 2018 MLOGIC(LOOP): Parameter TYPE1 has value n MLOGIC(LOOP): %LET (variable name is UNDERSCORE) MLOGIC(LOOP): %LET (variable name is DASH) MPRINT(LOOP): ** SAS has a limit of 32-characters to a dataset name, so making a shorter name ; MLOGIC(LOOP): %LET (variable name is PROV) SYMBOLGEN: Macro variable PROVIDER resolves to hospc 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/1984-99 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1999; stop value is 2014; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 1999 NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 1.84 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_1999_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: There were 47756 observations read from the data set IN.HOSPC_NMRC1984_99_1999_LONG. NOTE: 46053 observations with duplicate key values were deleted. NOTE: The data set WORK._1999N has 1703 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2000_long NOTE: Data file IN.HOSPC_NMRC1984_99_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 n MPRINT(LOOP): proc sort data=in.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc 12 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: There were 254827 observations read from the data set IN.HOSPC_NMRC1984_99_2000_LONG. NOTE: 252487 observations with duplicate key values were deleted. NOTE: The data set WORK._2000N has 2340 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.12 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2001_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: There were 256415 observations read from the data set IN.HOSPC_NMRC1984_99_2001_LONG. NOTE: 254204 observations with duplicate key values were deleted. NOTE: The data set WORK._2001N has 2211 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.13 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2002_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: There were 294843 observations read from the data set IN.HOSPC_NMRC1984_99_2002_LONG. NOTE: 292564 observations with duplicate key values were deleted. NOTE: The data set WORK._2002N has 2279 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.17 seconds cpu time 0.16 seconds 13 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2003_long NOTE: Data file IN.HOSPC_NMRC1984_99_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 n MPRINT(LOOP): proc sort data=in.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: There were 335404 observations read from the data set IN.HOSPC_NMRC1984_99_2003_LONG. NOTE: 333027 observations with duplicate key values were deleted. NOTE: The data set WORK._2003N has 2377 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.18 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2004_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: There were 506606 observations read from the data set IN.HOSPC_NMRC1984_99_2004_LONG. NOTE: 503310 observations with duplicate key values were deleted. NOTE: The data set WORK._2004N has 3296 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.16 seconds cpu time 0.27 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2005_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc 14 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: There were 616682 observations read from the data set IN.HOSPC_NMRC1984_99_2005_LONG. NOTE: 613255 observations with duplicate key values were deleted. NOTE: The data set WORK._2005N has 3427 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.22 seconds cpu time 0.33 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2006_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: There were 719781 observations read from the data set IN.HOSPC_NMRC1984_99_2006_LONG. NOTE: 716113 observations with duplicate key values were deleted. NOTE: The data set WORK._2006N has 3668 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.24 seconds cpu time 0.39 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2007_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: There were 791093 observations read from the data set IN.HOSPC_NMRC1984_99_2007_LONG. NOTE: 787323 observations with duplicate key values were deleted. NOTE: The data set WORK._2007N has 3770 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.26 seconds cpu time 0.42 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2008_long 15 The SAS System 12:35 Wednesday, October 24, 2018 NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: There were 869563 observations read from the data set IN.HOSPC_NMRC1984_99_2008_LONG. NOTE: 865511 observations with duplicate key values were deleted. NOTE: The data set WORK._2008N has 4052 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.27 seconds cpu time 0.47 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2009_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: There were 907305 observations read from the data set IN.HOSPC_NMRC1984_99_2009_LONG. NOTE: 903176 observations with duplicate key values were deleted. NOTE: The data set WORK._2009N has 4129 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.29 seconds cpu time 0.47 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2010_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 16 The SAS System 12:35 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 933238 observations read from the data set IN.HOSPC_NMRC1984_99_2010_LONG. NOTE: 929074 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 4164 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.48 seconds cpu time 0.51 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2011_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2012 NOTE: There were 960869 observations read from the data set IN.HOSPC_NMRC1984_99_2011_LONG. NOTE: 956599 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 4270 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.62 seconds cpu time 0.51 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2012_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2013 NOTE: There were 1014281 observations read from the data set IN.HOSPC_NMRC1984_99_2012_LONG. NOTE: 1009928 observations with duplicate key values were deleted. NOTE: The data set WORK._2012N has 4353 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.32 seconds cpu time 0.55 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2013_long NOTE: Data file IN.HOSPC_NMRC1984_99_2013_LONG.DATA is in a format that is native to another host, or the file encoding does not 17 The SAS System 12:35 Wednesday, October 24, 2018 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.hospc_nmrc1984_99_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hospc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1984_99 SYMBOLGEN: Macro variable YEAR resolves to 2014 NOTE: There were 1061885 observations read from the data set IN.HOSPC_NMRC1984_99_2013_LONG. NOTE: 1057331 observations with duplicate key values were deleted. NOTE: The data set WORK._2013N has 4554 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.37 seconds cpu time 0.57 seconds SYMBOLGEN: Macro variable DS resolves to hospc_nmrc1984_99_2014_long NOTE: Data file IN.HOSPC_NMRC1984_99_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.hospc_nmrc1984_99_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 not iterate again. SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 1084872 observations read from the data set IN.HOSPC_NMRC1984_99_2014_LONG. NOTE: 1080324 observations with duplicate key values were deleted. NOTE: The data set WORK._2014N has 4548 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.59 seconds cpu time 0.59 seconds MPRINT(LOOP): data out.hos_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 MPRINT(LOOP): set _1999n _2000n _2001n _2002n _2003n _2004n _2005n _2006n _2007n _2008n _2009n _2010n _2011n _2012n _2013n _2014n 18 The SAS System 12:35 Wednesday, October 24, 2018 ; NOTE: Data file OUT.HOS_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 1703 observations read from the data set WORK._1999N. NOTE: There were 2340 observations read from the data set WORK._2000N. NOTE: There were 2211 observations read from the data set WORK._2001N. NOTE: There were 2279 observations read from the data set WORK._2002N. NOTE: There were 2377 observations read from the data set WORK._2003N. NOTE: There were 3296 observations read from the data set WORK._2004N. NOTE: There were 3427 observations read from the data set WORK._2005N. NOTE: There were 3668 observations read from the data set WORK._2006N. NOTE: There were 3770 observations read from the data set WORK._2007N. NOTE: There were 4052 observations read from the data set WORK._2008N. NOTE: There were 4129 observations read from the data set WORK._2009N. NOTE: There were 4164 observations read from the data set WORK._2010N. NOTE: There were 4270 observations read from the data set WORK._2011N. NOTE: There were 4353 observations read from the data set WORK._2012N. NOTE: There were 4554 observations read from the data set WORK._2013N. NOTE: There were 4548 observations read from the data set WORK._2014N. NOTE: The data set OUT.HOS_NMRC_WKSHT_CLMN_LINE_COMBOS has 55141 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.HOS_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.hos_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.HOS_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 55141 observations read from the data set OUT.HOS_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 48831 observations with duplicate key values were deleted. NOTE: The data set OUT.HOS_NMRC_WKSHT_CLMN_LINE_COMBOS has 6310 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.06 seconds cpu time 0.03 seconds MPRINT(LOOP): data out.hos_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set out.hos_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HOS_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.HOS_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 19 The SAS System 12:35 Wednesday, October 24, 2018 might reduce performance. NOTE: There were 6310 observations read from the data set OUT.HOS_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HOS_NMRC_WKSHT_CLMN_LINE_COMBOS has 6310 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.hos_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HOS_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 PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hos_nmrc_wksht_clmn_line_combos.sas7bdat hos_nmrc_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROV resolves to hos SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hos_nmrc_wksht_clmn_line_combos.sas7bdat hos_nmrc_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 48 *%loop(provider=snf,form=2540_10,type=alpha,type4=alph,type1=a); 49 *%loop(provider=snf,form=2540_10,type=nmrc,type4=nmrc,type1=n); NOTE: The PROCEDURE CONTENTS printed page 2. NOTE: PROCEDURE CONTENTS used (Total process time): real time 1.37 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 11.30 seconds cpu time 7.45 seconds