1 The SAS System 18:05 Monday, April 15, 2019 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3 MBCS3170) Licensed to NATIONAL BUREAU OF ECONOMIC RESEARCH, Site 70111350. NOTE: This session is executing on the Linux 3.10.0-957.1.3.el7.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.1 NOTE: Additional host information: Linux LIN X64 3.10.0-957.1.3.el7.x86_64 #1 SMP Mon Nov 26 12:36:06 CST 2018 x86_64 Scientific Linux release 7.6 (Nitrogen) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS initialization used: real time 0.09 seconds cpu time 0.02 seconds 1 options nocenter; 2 options notes mlogic mprint symbolgen; 3 ** by Jean Roth, jroth@nber.org , 2010-12-15 ; 4 5 libname out "."; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/1728-94 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=1728_94; 9 %let DASH=1728-94; 10 libname in "."; 11 12 %do year=1994 %to 2018; 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 18:05 Monday, April 15, 2019 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. _2012&type1. _2013&type1. _2014&type1. 26 _2015&type1. _2016&type1. _2017&type1. _2018&type1. 27 ; 28 29 proc sort data=out.&provider._&type4._wksht_clmn_line_combos nodupkey; 30 by wksht_cd line_num clmn_num ; 31 32 data out.&provider._&type4._wksht_clmn_line_combos; 33 retain wksht_cd line_num clmn_num; 34 set out.&provider._&type4._wksht_clmn_line_combos; 35 36 proc contents data=out.&provider._&type4._wksht_clmn_line_combos; 37 38 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.csv -o -y"; 39 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&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=hha,form=1728_94,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hha MLOGIC(LOOP): Parameter FORM has value 1728_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/1728-94 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1994; stop value is 2018; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1994 SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_1994_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha 3 The SAS System 18:05 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1995 NOTE: There were 170283 observations read from the data set IN.HHA_ALPHA1728_94_1994_LONG. NOTE: 169837 observations with duplicate key values were deleted. NOTE: The data set WORK._1994A has 446 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 hha_alpha1728_94_1995_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1996 NOTE: There were 234530 observations read from the data set IN.HHA_ALPHA1728_94_1995_LONG. NOTE: 234028 observations with duplicate key values were deleted. NOTE: The data set WORK._1995A has 502 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.16 seconds cpu time 0.16 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_1996_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1997 NOTE: There were 248996 observations read from the data set IN.HHA_ALPHA1728_94_1996_LONG. NOTE: 248474 observations with duplicate key values were deleted. NOTE: The data set WORK._1996A has 522 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.19 seconds 4 The SAS System 18:05 Monday, April 15, 2019 SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_1997_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1998 NOTE: There were 276691 observations read from the data set IN.HHA_ALPHA1728_94_1997_LONG. NOTE: 276184 observations with duplicate key values were deleted. NOTE: The data set WORK._1997A has 507 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.19 seconds cpu time 0.26 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_1998_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1999 NOTE: There were 255076 observations read from the data set IN.HHA_ALPHA1728_94_1998_LONG. NOTE: 254425 observations with duplicate key values were deleted. NOTE: The data set WORK._1998A has 651 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.17 seconds cpu time 0.17 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_1999_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha 5 The SAS System 18:05 Monday, April 15, 2019 SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: There were 220955 observations read from the data set IN.HHA_ALPHA1728_94_1999_LONG. NOTE: 220340 observations with duplicate key values were deleted. NOTE: The data set WORK._1999A has 615 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 hha_alpha1728_94_2000_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: There were 224495 observations read from the data set IN.HHA_ALPHA1728_94_2000_LONG. NOTE: 223844 observations with duplicate key values were deleted. NOTE: The data set WORK._2000A has 651 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 hha_alpha1728_94_2001_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: There were 223711 observations read from the data set IN.HHA_ALPHA1728_94_2001_LONG. NOTE: 223029 observations with duplicate key values were deleted. NOTE: The data set WORK._2001A has 682 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.16 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2002_long 6 The SAS System 18:05 Monday, April 15, 2019 NOTE: Data file IN.HHA_ALPHA1728_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 a MPRINT(LOOP): proc sort data=in.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: There were 231848 observations read from the data set IN.HHA_ALPHA1728_94_2002_LONG. NOTE: 231148 observations with duplicate key values were deleted. NOTE: The data set WORK._2002A has 700 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 hha_alpha1728_94_2003_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: There were 274013 observations read from the data set IN.HHA_ALPHA1728_94_2003_LONG. NOTE: 273297 observations with duplicate key values were deleted. NOTE: The data set WORK._2003A has 716 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 hha_alpha1728_94_2004_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 7 The SAS System 18:05 Monday, April 15, 2019 SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: There were 311901 observations read from the data set IN.HHA_ALPHA1728_94_2004_LONG. NOTE: 311207 observations with duplicate key values were deleted. NOTE: The data set WORK._2004A has 694 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.17 seconds cpu time 0.30 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2005_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: There were 333300 observations read from the data set IN.HHA_ALPHA1728_94_2005_LONG. NOTE: 332572 observations with duplicate key values were deleted. NOTE: The data set WORK._2005A has 728 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.18 seconds cpu time 0.31 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2006_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: There were 393232 observations read from the data set IN.HHA_ALPHA1728_94_2006_LONG. NOTE: 392537 observations with duplicate key values were deleted. NOTE: The data set WORK._2006A has 695 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.31 seconds cpu time 0.37 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2007_long NOTE: Data file IN.HHA_ALPHA1728_94_2007_LONG.DATA is in a format that is native to another host, or the file encoding does not 8 The SAS System 18:05 Monday, April 15, 2019 match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: There were 441088 observations read from the data set IN.HHA_ALPHA1728_94_2007_LONG. NOTE: 440415 observations with duplicate key values were deleted. NOTE: The data set WORK._2007A has 673 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.26 seconds cpu time 0.44 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2008_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: There were 463943 observations read from the data set IN.HHA_ALPHA1728_94_2008_LONG. NOTE: 463270 observations with duplicate key values were deleted. NOTE: The data set WORK._2008A has 673 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.27 seconds cpu time 0.44 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2009_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2010 9 The SAS System 18:05 Monday, April 15, 2019 NOTE: There were 513866 observations read from the data set IN.HHA_ALPHA1728_94_2009_LONG. NOTE: 513177 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 689 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.35 seconds cpu time 0.53 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2010_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 542426 observations read from the data set IN.HHA_ALPHA1728_94_2010_LONG. NOTE: 541895 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 531 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.58 seconds cpu time 0.52 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2011_long NOTE: Data file IN.HHA_ALPHA1728_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.hha_alpha1728_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 iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2012 NOTE: There were 570313 observations read from the data set IN.HHA_ALPHA1728_94_2011_LONG. NOTE: 569761 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 552 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 hha_alpha1728_94_2012_long NOTE: Data file IN.HHA_ALPHA1728_94_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 10 The SAS System 18:05 Monday, April 15, 2019 might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2012 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hha_alpha1728_94_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2013 NOTE: There were 582065 observations read from the data set IN.HHA_ALPHA1728_94_2012_LONG. NOTE: 581509 observations with duplicate key values were deleted. NOTE: The data set WORK._2012A has 556 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.32 seconds cpu time 0.56 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2013_long NOTE: Data file IN.HHA_ALPHA1728_94_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.hha_alpha1728_94_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 hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2014 NOTE: There were 595948 observations read from the data set IN.HHA_ALPHA1728_94_2013_LONG. NOTE: 595383 observations with duplicate key values were deleted. NOTE: The data set WORK._2013A has 565 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.35 seconds cpu time 0.59 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2014_long NOTE: Data file IN.HHA_ALPHA1728_94_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.hha_alpha1728_94_2014_long out=_2014a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2015; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2015 11 The SAS System 18:05 Monday, April 15, 2019 NOTE: There were 602919 observations read from the data set IN.HHA_ALPHA1728_94_2014_LONG. NOTE: 602232 observations with duplicate key values were deleted. NOTE: The data set WORK._2014A has 687 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.34 seconds cpu time 0.56 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2015_long NOTE: Data file IN.HHA_ALPHA1728_94_2015_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hha_alpha1728_94_2015_long out=_2015a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2016; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2016 NOTE: There were 584664 observations read from the data set IN.HHA_ALPHA1728_94_2015_LONG. NOTE: 583672 observations with duplicate key values were deleted. NOTE: The data set WORK._2015A has 992 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.34 seconds cpu time 0.54 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2016_long NOTE: Data file IN.HHA_ALPHA1728_94_2016_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hha_alpha1728_94_2016_long out=_2016a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2017; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2017 NOTE: There were 1053576 observations read from the data set IN.HHA_ALPHA1728_94_2016_LONG. NOTE: 1052074 observations with duplicate key values were deleted. NOTE: The data set WORK._2016A has 1502 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.58 seconds cpu time 0.91 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hha_alpha1728_94_2017_long out=_2017a (keep=wksht_cd clmn_num line_num) nodupkey; 12 The SAS System 18:05 Monday, April 15, 2019 MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 1038917 observations read from the data set IN.HHA_ALPHA1728_94_2017_LONG. NOTE: 1037495 observations with duplicate key values were deleted. NOTE: The data set WORK._2017A has 1422 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.34 seconds cpu time 0.56 seconds SYMBOLGEN: Macro variable DS resolves to hha_alpha1728_94_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hha_alpha1728_94_2018_long out=_2018a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2019; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 8718 observations read from the data set IN.HHA_ALPHA1728_94_2018_LONG. NOTE: 8261 observations with duplicate key values were deleted. NOTE: The data set WORK._2018A has 457 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.hha_alph_wksht_clmn_line_combos; SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a 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 13 The SAS System 18:05 Monday, April 15, 2019 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 _2012a _2013a _2014a _2015a _2016a _2017a _2018a ; NOTE: Data file OUT.HHA_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 446 observations read from the data set WORK._1994A. NOTE: There were 502 observations read from the data set WORK._1995A. NOTE: There were 522 observations read from the data set WORK._1996A. NOTE: There were 507 observations read from the data set WORK._1997A. NOTE: There were 651 observations read from the data set WORK._1998A. NOTE: There were 615 observations read from the data set WORK._1999A. NOTE: There were 651 observations read from the data set WORK._2000A. NOTE: There were 682 observations read from the data set WORK._2001A. NOTE: There were 700 observations read from the data set WORK._2002A. NOTE: There were 716 observations read from the data set WORK._2003A. NOTE: There were 694 observations read from the data set WORK._2004A. NOTE: There were 728 observations read from the data set WORK._2005A. NOTE: There were 695 observations read from the data set WORK._2006A. NOTE: There were 673 observations read from the data set WORK._2007A. NOTE: There were 673 observations read from the data set WORK._2008A. NOTE: There were 689 observations read from the data set WORK._2009A. NOTE: There were 531 observations read from the data set WORK._2010A. NOTE: There were 552 observations read from the data set WORK._2011A. NOTE: There were 556 observations read from the data set WORK._2012A. NOTE: There were 565 observations read from the data set WORK._2013A. NOTE: There were 687 observations read from the data set WORK._2014A. NOTE: There were 992 observations read from the data set WORK._2015A. NOTE: There were 1502 observations read from the data set WORK._2016A. NOTE: There were 1422 observations read from the data set WORK._2017A. NOTE: There were 457 observations read from the data set WORK._2018A. NOTE: The data set OUT.HHA_ALPH_WKSHT_CLMN_LINE_COMBOS has 17408 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HHA_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.hha_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HHA_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 17408 observations read from the data set OUT.HHA_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 15185 observations with duplicate key values were deleted. NOTE: The data set OUT.HHA_ALPH_WKSHT_CLMN_LINE_COMBOS has 2223 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 14 The SAS System 18:05 Monday, April 15, 2019 MPRINT(LOOP): data out.hha_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set out.hha_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HHA_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.HHA_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 2223 observations read from the data set OUT.HHA_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HHA_ALPH_WKSHT_CLMN_LINE_COMBOS has 2223 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.hha_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HHA_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 hha SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hha_alph_wksht_clmn_line_combos.sas7bdat hha_alph_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hha_alph_wksht_clmn_line_combos.sas7bdat hha_alph_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 47 %loop(provider=hha,form=1728_94,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hha MLOGIC(LOOP): Parameter FORM has value 1728_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/1728-94 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1994; stop value is 2018; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1994 15 The SAS System 18:05 Monday, April 15, 2019 NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.32 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_1994_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1995 NOTE: There were 1153303 observations read from the data set IN.HHA_NMRC1728_94_1994_LONG. NOTE: 1148035 observations with duplicate key values were deleted. NOTE: The data set WORK._1994N has 5268 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.58 seconds cpu time 0.88 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_1995_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1996 NOTE: There were 1612556 observations read from the data set IN.HHA_NMRC1728_94_1995_LONG. NOTE: 1606327 observations with duplicate key values were deleted. NOTE: The data set WORK._1995N has 6229 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.80 seconds cpu time 1.30 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_1996_long NOTE: Data file IN.HHA_NMRC1728_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 16 The SAS System 18:05 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1997 NOTE: There were 1761033 observations read from the data set IN.HHA_NMRC1728_94_1996_LONG. NOTE: 1754422 observations with duplicate key values were deleted. NOTE: The data set WORK._1996N has 6611 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.72 seconds cpu time 1.28 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_1997_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1998 NOTE: There were 2000480 observations read from the data set IN.HHA_NMRC1728_94_1997_LONG. NOTE: 1994098 observations with duplicate key values were deleted. NOTE: The data set WORK._1997N has 6382 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.88 seconds cpu time 1.51 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_1998_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 1999 NOTE: There were 1993594 observations read from the data set IN.HHA_NMRC1728_94_1998_LONG. NOTE: 1986045 observations with duplicate key values were deleted. 17 The SAS System 18:05 Monday, April 15, 2019 NOTE: The data set WORK._1998N has 7549 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.83 seconds cpu time 1.37 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_1999_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2000 NOTE: There were 1640207 observations read from the data set IN.HHA_NMRC1728_94_1999_LONG. NOTE: 1632906 observations with duplicate key values were deleted. NOTE: The data set WORK._1999N has 7301 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.68 seconds cpu time 1.12 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2000_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2001 NOTE: There were 1765223 observations read from the data set IN.HHA_NMRC1728_94_2000_LONG. NOTE: 1756237 observations with duplicate key values were deleted. NOTE: The data set WORK._2000N has 8986 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.73 seconds cpu time 1.22 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2001_long NOTE: Data file IN.HHA_NMRC1728_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 n 18 The SAS System 18:05 Monday, April 15, 2019 MPRINT(LOOP): proc sort data=in.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2002 NOTE: There were 1267389 observations read from the data set IN.HHA_NMRC1728_94_2001_LONG. NOTE: 1260195 observations with duplicate key values were deleted. NOTE: The data set WORK._2001N has 7194 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.63 seconds cpu time 1.02 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2002_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2003 NOTE: There were 1317731 observations read from the data set IN.HHA_NMRC1728_94_2002_LONG. NOTE: 1310659 observations with duplicate key values were deleted. NOTE: The data set WORK._2002N has 7072 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.59 seconds cpu time 1.07 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2003_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2004 NOTE: There were 1461087 observations read from the data set IN.HHA_NMRC1728_94_2003_LONG. NOTE: 1454386 observations with duplicate key values were deleted. NOTE: The data set WORK._2003N has 6701 observations and 3 variables. 19 The SAS System 18:05 Monday, April 15, 2019 NOTE: PROCEDURE SORT used (Total process time): real time 0.68 seconds cpu time 1.22 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2004_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2005 NOTE: There were 1604351 observations read from the data set IN.HHA_NMRC1728_94_2004_LONG. NOTE: 1597759 observations with duplicate key values were deleted. NOTE: The data set WORK._2004N has 6592 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.74 seconds cpu time 1.39 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2005_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2006 NOTE: There were 1817703 observations read from the data set IN.HHA_NMRC1728_94_2005_LONG. NOTE: 1810816 observations with duplicate key values were deleted. NOTE: The data set WORK._2005N has 6887 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.81 seconds cpu time 1.50 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2006_long NOTE: Data file IN.HHA_NMRC1728_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 n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_2006_long out=_2006n (keep=wksht_cd clmn_num line_num) nodupkey; 20 The SAS System 18:05 Monday, April 15, 2019 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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2007 NOTE: There were 2131020 observations read from the data set IN.HHA_NMRC1728_94_2006_LONG. NOTE: 2123679 observations with duplicate key values were deleted. NOTE: The data set WORK._2006N has 7341 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.95 seconds cpu time 1.70 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2007_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2008 NOTE: There were 2047512 observations read from the data set IN.HHA_NMRC1728_94_2007_LONG. NOTE: 2040831 observations with duplicate key values were deleted. NOTE: The data set WORK._2007N has 6681 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.90 seconds cpu time 1.69 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2008_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: There were 2118260 observations read from the data set IN.HHA_NMRC1728_94_2008_LONG. NOTE: 2111541 observations with duplicate key values were deleted. NOTE: The data set WORK._2008N has 6719 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): 21 The SAS System 18:05 Monday, April 15, 2019 real time 0.91 seconds cpu time 1.62 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2009_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: There were 2314265 observations read from the data set IN.HHA_NMRC1728_94_2009_LONG. NOTE: 2307365 observations with duplicate key values were deleted. NOTE: The data set WORK._2009N has 6900 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.07 seconds cpu time 1.80 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2010_long NOTE: Data file IN.HHA_NMRC1728_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.hha_nmrc1728_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 2443956 observations read from the data set IN.HHA_NMRC1728_94_2010_LONG. NOTE: 2438160 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 5796 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.08 seconds cpu time 1.85 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2011_long NOTE: Data file IN.HHA_NMRC1728_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 n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_2011_long out=_2011n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; 22 The SAS System 18:05 Monday, April 15, 2019 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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2012 NOTE: There were 2539680 observations read from the data set IN.HHA_NMRC1728_94_2011_LONG. NOTE: 2533262 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 6418 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.20 seconds cpu time 1.94 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2012_long NOTE: Data file IN.HHA_NMRC1728_94_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.hha_nmrc1728_94_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2013 NOTE: There were 2585432 observations read from the data set IN.HHA_NMRC1728_94_2012_LONG. NOTE: 2578969 observations with duplicate key values were deleted. NOTE: The data set WORK._2012N has 6463 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.23 seconds cpu time 2.15 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2013_long NOTE: Data file IN.HHA_NMRC1728_94_2013_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2013 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_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 hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2014 NOTE: There were 2664387 observations read from the data set IN.HHA_NMRC1728_94_2013_LONG. NOTE: 2658080 observations with duplicate key values were deleted. NOTE: The data set WORK._2013N has 6307 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.27 seconds 23 The SAS System 18:05 Monday, April 15, 2019 cpu time 2.04 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2014_long NOTE: Data file IN.HHA_NMRC1728_94_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.hha_nmrc1728_94_2014_long out=_2014n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2015; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2015 NOTE: There were 2397090 observations read from the data set IN.HHA_NMRC1728_94_2014_LONG. NOTE: 2390527 observations with duplicate key values were deleted. NOTE: The data set WORK._2014N has 6563 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.05 seconds cpu time 1.69 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2015_long NOTE: Data file IN.HHA_NMRC1728_94_2015_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_2015_long out=_2015n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2016; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2016 NOTE: There were 2385432 observations read from the data set IN.HHA_NMRC1728_94_2015_LONG. NOTE: 2377933 observations with duplicate key values were deleted. NOTE: The data set WORK._2015N has 7499 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.15 seconds cpu time 1.90 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2016_long NOTE: Data file IN.HHA_NMRC1728_94_2016_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_2016_long out=_2016n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2017; loop will iterate again. 24 The SAS System 18:05 Monday, April 15, 2019 MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2017 NOTE: There were 3584846 observations read from the data set IN.HHA_NMRC1728_94_2016_LONG. NOTE: 3575896 observations with duplicate key values were deleted. NOTE: The data set WORK._2016N has 8950 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.83 seconds cpu time 2.98 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_2017_long out=_2017n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 1728_94 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 3510058 observations read from the data set IN.HHA_NMRC1728_94_2017_LONG. NOTE: 3502354 observations with duplicate key values were deleted. NOTE: The data set WORK._2017N has 7704 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.03 seconds cpu time 1.61 seconds SYMBOLGEN: Macro variable DS resolves to hha_nmrc1728_94_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hha_nmrc1728_94_2018_long out=_2018n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2019; loop will not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 31769 observations read from the data set IN.HHA_NMRC1728_94_2018_LONG. NOTE: 29261 observations with duplicate key values were deleted. NOTE: The data set WORK._2018N has 2508 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.hha_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 25 The SAS System 18:05 Monday, April 15, 2019 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 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 _2012n _2013n _2014n _2015n _2016n _2017n _2018n ; NOTE: Data file OUT.HHA_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 5268 observations read from the data set WORK._1994N. NOTE: There were 6229 observations read from the data set WORK._1995N. NOTE: There were 6611 observations read from the data set WORK._1996N. NOTE: There were 6382 observations read from the data set WORK._1997N. NOTE: There were 7549 observations read from the data set WORK._1998N. NOTE: There were 7301 observations read from the data set WORK._1999N. NOTE: There were 8986 observations read from the data set WORK._2000N. NOTE: There were 7194 observations read from the data set WORK._2001N. NOTE: There were 7072 observations read from the data set WORK._2002N. NOTE: There were 6701 observations read from the data set WORK._2003N. NOTE: There were 6592 observations read from the data set WORK._2004N. NOTE: There were 6887 observations read from the data set WORK._2005N. NOTE: There were 7341 observations read from the data set WORK._2006N. NOTE: There were 6681 observations read from the data set WORK._2007N. NOTE: There were 6719 observations read from the data set WORK._2008N. NOTE: There were 6900 observations read from the data set WORK._2009N. NOTE: There were 5796 observations read from the data set WORK._2010N. NOTE: There were 6418 observations read from the data set WORK._2011N. NOTE: There were 6463 observations read from the data set WORK._2012N. NOTE: There were 6307 observations read from the data set WORK._2013N. NOTE: There were 6563 observations read from the data set WORK._2014N. NOTE: There were 7499 observations read from the data set WORK._2015N. NOTE: There were 8950 observations read from the data set WORK._2016N. NOTE: There were 7704 observations read from the data set WORK._2017N. NOTE: There were 2508 observations read from the data set WORK._2018N. NOTE: The data set OUT.HHA_NMRC_WKSHT_CLMN_LINE_COMBOS has 168621 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.25 seconds cpu time 0.06 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc 26 The SAS System 18:05 Monday, April 15, 2019 NOTE: Data file OUT.HHA_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.hha_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.HHA_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 168621 observations read from the data set OUT.HHA_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 143840 observations with duplicate key values were deleted. NOTE: The data set OUT.HHA_NMRC_WKSHT_CLMN_LINE_COMBOS has 24781 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.14 seconds MPRINT(LOOP): data out.hha_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set out.hha_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HHA_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.HHA_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 24781 observations read from the data set OUT.HHA_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HHA_NMRC_WKSHT_CLMN_LINE_COMBOS has 24781 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.hha_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HHA_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 hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hha_nmrc_wksht_clmn_line_combos.sas7bdat hha_nmrc_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to hha SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hha_nmrc_wksht_clmn_line_combos.sas7bdat hha_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); 27 The SAS System 18:05 Monday, April 15, 2019 NOTE: The PROCEDURE CONTENTS printed page 2. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.39 seconds cpu time 0.01 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 30.46 seconds cpu time 47.21 seconds