1 The SAS System 12:48 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 1.72 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/265-94 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=265_94; 9 %let DASH=265-94; 10 libname in "."; 11 12 %do year=1994 %to 2011; 13 14 %let ds=&provider._&type.&form._&year._long; 15 proc sort data=in.&ds. out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 16 by wksht_cd clmn_num line_num; 17 %end; 18 2 The SAS System 12:48 Wednesday, October 24, 2018 19 data out.&provider._&type4._wksht_clmn_line_combos; 20 set 21 _1994&type1. 22 _1995&type1. _1996&type1. _1997&type1. _1998&type1. _1999&type1. 23 _2000&type1. _2001&type1. _2002&type1. _2003&type1. _2004&type1. 24 _2005&type1. _2006&type1. _2007&type1. _2008&type1. _2009&type1. 25 _2010&type1. _2011&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); 44 *%loop(provider=hosp,form=2552_10,type=nmrc,type4=nmrc,type1=n); 45 %loop(provider=rnl,form=265_94,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value rnl MLOGIC(LOOP): Parameter FORM has value 265_94 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 "."; 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/265-94 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1994; stop value is 2011; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1994 SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_1994_long NOTE: Data file IN.RNL_ALPHA265_94_1994_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 1994 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_1994_long out=_1994a (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 1995; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha 3 The SAS System 12:48 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1995 NOTE: There were 48715 observations read from the data set IN.RNL_ALPHA265_94_1994_LONG. NOTE: 48448 observations with duplicate key values were deleted. NOTE: The data set WORK._1994A has 267 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.05 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_1995_long NOTE: Data file IN.RNL_ALPHA265_94_1995_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_1995_long out=_1995a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1996; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1996 NOTE: There were 61052 observations read from the data set IN.RNL_ALPHA265_94_1995_LONG. NOTE: 60844 observations with duplicate key values were deleted. NOTE: The data set WORK._1995A has 208 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_1996_long NOTE: Data file IN.RNL_ALPHA265_94_1996_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_1996_long out=_1996a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1997; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1997 NOTE: There were 71406 observations read from the data set IN.RNL_ALPHA265_94_1996_LONG. NOTE: 71186 observations with duplicate key values were deleted. NOTE: The data set WORK._1996A has 220 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_1997_long 4 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: Data file IN.RNL_ALPHA265_94_1997_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_1997_long out=_1997a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1998; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1998 NOTE: There were 67892 observations read from the data set IN.RNL_ALPHA265_94_1997_LONG. NOTE: 67694 observations with duplicate key values were deleted. NOTE: The data set WORK._1997A has 198 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.05 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_1998_long NOTE: Data file IN.RNL_ALPHA265_94_1998_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_1998_long out=_1998a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1999; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1999 NOTE: There were 74877 observations read from the data set IN.RNL_ALPHA265_94_1998_LONG. NOTE: 74718 observations with duplicate key values were deleted. NOTE: The data set WORK._1998A has 159 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_1999_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_1999_long out=_1999a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2000; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 5 The SAS System 12:48 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: There were 80341 observations read from the data set IN.RNL_ALPHA265_94_1999_LONG. NOTE: 80096 observations with duplicate key values were deleted. NOTE: The data set WORK._1999A has 245 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2000_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: There were 87072 observations read from the data set IN.RNL_ALPHA265_94_2000_LONG. NOTE: 86809 observations with duplicate key values were deleted. NOTE: The data set WORK._2000A has 263 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.05 seconds cpu time 0.05 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2001_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: There were 113915 observations read from the data set IN.RNL_ALPHA265_94_2001_LONG. NOTE: 113573 observations with duplicate key values were deleted. NOTE: The data set WORK._2001A has 342 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.06 seconds cpu time 0.06 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2002_long NOTE: Data file IN.RNL_ALPHA265_94_2002_LONG.DATA is in a format that is native to another host, or the file encoding does not 6 The SAS System 12:48 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 2002 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: There were 102050 observations read from the data set IN.RNL_ALPHA265_94_2002_LONG. NOTE: 101703 observations with duplicate key values were deleted. NOTE: The data set WORK._2002A has 347 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.05 seconds cpu time 0.05 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2003_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: There were 126230 observations read from the data set IN.RNL_ALPHA265_94_2003_LONG. NOTE: 125880 observations with duplicate key values were deleted. NOTE: The data set WORK._2003A has 350 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.08 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2004_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2005 7 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: There were 481294 observations read from the data set IN.RNL_ALPHA265_94_2004_LONG. NOTE: 480836 observations with duplicate key values were deleted. NOTE: The data set WORK._2004A has 458 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.28 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2005_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: There were 519624 observations read from the data set IN.RNL_ALPHA265_94_2005_LONG. NOTE: 519144 observations with duplicate key values were deleted. NOTE: The data set WORK._2005A has 480 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.61 seconds cpu time 0.30 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2006_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: There were 548822 observations read from the data set IN.RNL_ALPHA265_94_2006_LONG. NOTE: 548373 observations with duplicate key values were deleted. NOTE: The data set WORK._2006A has 449 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.20 seconds cpu time 0.32 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2007_long NOTE: Data file IN.RNL_ALPHA265_94_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 8 The SAS System 12:48 Wednesday, October 24, 2018 might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: There were 596544 observations read from the data set IN.RNL_ALPHA265_94_2007_LONG. NOTE: 595997 observations with duplicate key values were deleted. NOTE: The data set WORK._2007A has 547 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.22 seconds cpu time 0.35 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2008_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: There were 650380 observations read from the data set IN.RNL_ALPHA265_94_2008_LONG. NOTE: 649844 observations with duplicate key values were deleted. NOTE: The data set WORK._2008A has 536 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.26 seconds cpu time 0.38 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2009_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2010 9 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: There were 683492 observations read from the data set IN.RNL_ALPHA265_94_2009_LONG. NOTE: 682902 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 590 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.25 seconds cpu time 0.40 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2010_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 702113 observations read from the data set IN.RNL_ALPHA265_94_2010_LONG. NOTE: 701558 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 555 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.26 seconds cpu time 0.41 seconds SYMBOLGEN: Macro variable DS resolves to rnl_alpha265_94_2011_long NOTE: Data file IN.RNL_ALPHA265_94_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.rnl_alpha265_94_2011_long out=_2011a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 2091 observations read from the data set IN.RNL_ALPHA265_94_2011_LONG. NOTE: 1845 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 246 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.35 seconds cpu time 0.00 seconds MPRINT(LOOP): data out.rnl_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 10 The SAS System 12:48 Wednesday, October 24, 2018 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 _1994a _1995a _1996a _1997a _1998a _1999a _2000a _2001a _2002a _2003a _2004a _2005a _2006a _2007a _2008a _2009a _2010a _2011a ; NOTE: Data file OUT.RNL_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 267 observations read from the data set WORK._1994A. NOTE: There were 208 observations read from the data set WORK._1995A. NOTE: There were 220 observations read from the data set WORK._1996A. NOTE: There were 198 observations read from the data set WORK._1997A. NOTE: There were 159 observations read from the data set WORK._1998A. NOTE: There were 245 observations read from the data set WORK._1999A. NOTE: There were 263 observations read from the data set WORK._2000A. NOTE: There were 342 observations read from the data set WORK._2001A. NOTE: There were 347 observations read from the data set WORK._2002A. NOTE: There were 350 observations read from the data set WORK._2003A. NOTE: There were 458 observations read from the data set WORK._2004A. NOTE: There were 480 observations read from the data set WORK._2005A. NOTE: There were 449 observations read from the data set WORK._2006A. NOTE: There were 547 observations read from the data set WORK._2007A. NOTE: There were 536 observations read from the data set WORK._2008A. NOTE: There were 590 observations read from the data set WORK._2009A. NOTE: There were 555 observations read from the data set WORK._2010A. NOTE: There were 246 observations read from the data set WORK._2011A. NOTE: The data set OUT.RNL_ALPH_WKSHT_CLMN_LINE_COMBOS has 6460 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.RNL_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.rnl_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.RNL_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 6460 observations read from the data set OUT.RNL_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 5702 observations with duplicate key values were deleted. NOTE: The data set OUT.RNL_ALPH_WKSHT_CLMN_LINE_COMBOS has 758 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): 11 The SAS System 12:48 Wednesday, October 24, 2018 real time 0.02 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.rnl_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set out.rnl_alph_wksht_clmn_line_combos; NOTE: Data file OUT.RNL_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.RNL_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 758 observations read from the data set OUT.RNL_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.RNL_ALPH_WKSHT_CLMN_LINE_COMBOS has 758 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.rnl_alph_wksht_clmn_line_combos; NOTE: Data file OUT.RNL_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 rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st rnl_alph_wksht_clmn_line_combos.sas7bdat rnl_alph_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st rnl_alph_wksht_clmn_line_combos.sas7bdat rnl_alph_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 46 %loop(provider=rnl,form=265_94,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value rnl MLOGIC(LOOP): Parameter FORM has value 265_94 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 "."; 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/265-94 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1994; stop value is 2011; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl 12 The SAS System 12:48 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1994 NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.57 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_1994_long NOTE: Data file IN.RNL_NMRC265_94_1994_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 1994 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_1994_long out=_1994n (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 1995; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1995 NOTE: There were 253922 observations read from the data set IN.RNL_NMRC265_94_1994_LONG. NOTE: 253026 observations with duplicate key values were deleted. NOTE: The data set WORK._1994N has 896 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.13 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_1995_long NOTE: Data file IN.RNL_NMRC265_94_1995_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_1995_long out=_1995n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1996; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1996 NOTE: There were 319834 observations read from the data set IN.RNL_NMRC265_94_1995_LONG. NOTE: 319066 observations with duplicate key values were deleted. NOTE: The data set WORK._1995N has 768 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.85 seconds cpu time 0.17 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_1996_long NOTE: Data file IN.RNL_NMRC265_94_1996_LONG.DATA is in a format that is native to another host, or the file encoding does not match 13 The SAS System 12:48 Wednesday, October 24, 2018 the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_1996_long out=_1996n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1997; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1997 NOTE: There were 363761 observations read from the data set IN.RNL_NMRC265_94_1996_LONG. NOTE: 362972 observations with duplicate key values were deleted. NOTE: The data set WORK._1996N has 789 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.28 seconds cpu time 0.19 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_1997_long NOTE: Data file IN.RNL_NMRC265_94_1997_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_1997_long out=_1997n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1998; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1998 NOTE: There were 348253 observations read from the data set IN.RNL_NMRC265_94_1997_LONG. NOTE: 347488 observations with duplicate key values were deleted. NOTE: The data set WORK._1997N has 765 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.14 seconds cpu time 0.18 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_1998_long NOTE: Data file IN.RNL_NMRC265_94_1998_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_1998_long out=_1998n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1999; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 1999 14 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: There were 407860 observations read from the data set IN.RNL_NMRC265_94_1998_LONG. NOTE: 407138 observations with duplicate key values were deleted. NOTE: The data set WORK._1998N has 722 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.13 seconds cpu time 0.22 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_1999_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: There were 441831 observations read from the data set IN.RNL_NMRC265_94_1999_LONG. NOTE: 440957 observations with duplicate key values were deleted. NOTE: The data set WORK._1999N has 874 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.24 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2000_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: There were 470328 observations read from the data set IN.RNL_NMRC265_94_2000_LONG. NOTE: 469346 observations with duplicate key values were deleted. NOTE: The data set WORK._2000N has 982 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.16 seconds cpu time 0.25 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2001_long NOTE: Data file IN.RNL_NMRC265_94_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 15 The SAS System 12:48 Wednesday, October 24, 2018 reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: There were 568220 observations read from the data set IN.RNL_NMRC265_94_2001_LONG. NOTE: 567096 observations with duplicate key values were deleted. NOTE: The data set WORK._2001N has 1124 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.30 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2002_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: There were 497885 observations read from the data set IN.RNL_NMRC265_94_2002_LONG. NOTE: 496831 observations with duplicate key values were deleted. NOTE: The data set WORK._2002N has 1054 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 rnl_nmrc265_94_2003_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2004 16 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: There were 594774 observations read from the data set IN.RNL_NMRC265_94_2003_LONG. NOTE: 593704 observations with duplicate key values were deleted. NOTE: The data set WORK._2003N has 1070 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.78 seconds cpu time 0.31 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2004_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: There were 1112397 observations read from the data set IN.RNL_NMRC265_94_2004_LONG. NOTE: 1111221 observations with duplicate key values were deleted. NOTE: The data set WORK._2004N has 1176 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.55 seconds cpu time 0.59 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2005_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: There were 1215582 observations read from the data set IN.RNL_NMRC265_94_2005_LONG. NOTE: 1214262 observations with duplicate key values were deleted. NOTE: The data set WORK._2005N has 1320 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.39 seconds cpu time 0.66 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2006_long NOTE: Data file IN.RNL_NMRC265_94_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. 17 The SAS System 12:48 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: There were 1255717 observations read from the data set IN.RNL_NMRC265_94_2006_LONG. NOTE: 1254496 observations with duplicate key values were deleted. NOTE: The data set WORK._2006N has 1221 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.71 seconds cpu time 0.67 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2007_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: There were 1313546 observations read from the data set IN.RNL_NMRC265_94_2007_LONG. NOTE: 1312265 observations with duplicate key values were deleted. NOTE: The data set WORK._2007N has 1281 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.99 seconds cpu time 0.70 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2008_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: There were 1424226 observations read from the data set IN.RNL_NMRC265_94_2008_LONG. 18 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: 1422959 observations with duplicate key values were deleted. NOTE: The data set WORK._2008N has 1267 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.45 seconds cpu time 0.75 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2009_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: There were 1496289 observations read from the data set IN.RNL_NMRC265_94_2009_LONG. NOTE: 1494979 observations with duplicate key values were deleted. NOTE: The data set WORK._2009N has 1310 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.50 seconds cpu time 0.83 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2010_long NOTE: Data file IN.RNL_NMRC265_94_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.rnl_nmrc265_94_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 rnl SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 265_94 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 1568063 observations read from the data set IN.RNL_NMRC265_94_2010_LONG. NOTE: 1566790 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 1273 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.84 seconds SYMBOLGEN: Macro variable DS resolves to rnl_nmrc265_94_2011_long NOTE: Data file IN.RNL_NMRC265_94_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 19 The SAS System 12:48 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.rnl_nmrc265_94_2011_long out=_2011n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 4541 observations read from the data set IN.RNL_NMRC265_94_2011_LONG. NOTE: 3886 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 655 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.25 seconds cpu time 0.00 seconds MPRINT(LOOP): data out.rnl_nmrc_wksht_clmn_line_combos; SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): set _1994n _1995n _1996n _1997n _1998n _1999n _2000n _2001n _2002n _2003n _2004n _2005n _2006n _2007n _2008n _2009n _2010n _2011n ; NOTE: Data file OUT.RNL_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 896 observations read from the data set WORK._1994N. NOTE: There were 768 observations read from the data set WORK._1995N. NOTE: There were 789 observations read from the data set WORK._1996N. NOTE: There were 765 observations read from the data set WORK._1997N. NOTE: There were 722 observations read from the data set WORK._1998N. NOTE: There were 874 observations read from the data set WORK._1999N. NOTE: There were 982 observations read from the data set WORK._2000N. NOTE: There were 1124 observations read from the data set WORK._2001N. NOTE: There were 1054 observations read from the data set WORK._2002N. NOTE: There were 1070 observations read from the data set WORK._2003N. NOTE: There were 1176 observations read from the data set WORK._2004N. NOTE: There were 1320 observations read from the data set WORK._2005N. NOTE: There were 1221 observations read from the data set WORK._2006N. NOTE: There were 1281 observations read from the data set WORK._2007N. NOTE: There were 1267 observations read from the data set WORK._2008N. NOTE: There were 1310 observations read from the data set WORK._2009N. NOTE: There were 1273 observations read from the data set WORK._2010N. NOTE: There were 655 observations read from the data set WORK._2011N. 20 The SAS System 12:48 Wednesday, October 24, 2018 NOTE: The data set OUT.RNL_NMRC_WKSHT_CLMN_LINE_COMBOS has 18547 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.81 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.RNL_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.rnl_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.RNL_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 18547 observations read from the data set OUT.RNL_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 16778 observations with duplicate key values were deleted. NOTE: The data set OUT.RNL_NMRC_WKSHT_CLMN_LINE_COMBOS has 1769 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.rnl_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set out.rnl_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.RNL_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.RNL_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 1769 observations read from the data set OUT.RNL_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.RNL_NMRC_WKSHT_CLMN_LINE_COMBOS has 1769 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.rnl_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.RNL_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 rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st rnl_nmrc_wksht_clmn_line_combos.sas7bdat rnl_nmrc_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc 21 The SAS System 12:48 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable PROVIDER resolves to rnl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st rnl_nmrc_wksht_clmn_line_combos.sas7bdat rnl_nmrc_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 47 *%loop(provider=snf,form=2540_10,type=alpha,type4=alph,type1=a); 48 *%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 2.67 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 21.60 seconds cpu time 10.29 seconds