1 The SAS System 16:01 Thursday, December 16, 2010 NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1 (TS1M3) Licensed to HARVARD UNIV - SCHOOL OF PUBLIC HEALTH - T&R, Site 0001177014. NOTE: This session is executing on the SunOS 5.10 platform. NOTE: SAS 9.1.3 Service Pack 3 ----------------------------------------------------------------------- NBER NOTE: sas now defaults to sas9. sas8 or sas6 will invoke sas version 8 or 6 respectively. - 2005/10/21 ----------------------------------------------------------------------- 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.71 seconds cpu time 0.07 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/nber10/SCCS/hcris/snf 6 7 %macro loop(provider=,type=,type4=,type1=); 8 libname in "/homes/nber/jroth/bulk/cost-reports/&provider./"; 9 10 %do year=1995 %to 2010; 11 proc sort data=in.&provider._&type.&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 12 by wksht_cd clmn_num line_num; 13 %end; 14 15 data out.&provider._&type4._wksht_clmn_line_combos; 16 set _1995&type1. _1996&type1. _1997&type1. _1998&type1. _1999&type1. 17 _2000&type1. _2001&type1. _2002&type1. _2003&type1. _2004&type1. 18 _2005&type1. _2006&type1. _2007&type1. _2008&type1. _2009&type1. 19 _2010&type1. 20 ; 2 The SAS System 16:01 Thursday, December 16, 2010 21 22 proc sort data=out.&provider._&type4._wksht_clmn_line_combos nodupkey; 23 by wksht_cd clmn_num line_num; 24 25 proc contents data=out.&provider._&type4._wksht_clmn_line_combos; 26 27 x "st -y &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.csv"; 28 x "echo 'combo done' | mail jroth"; 29 %mend loop; 30 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 31 *%loop(provider=hha,type=nmrc_rpt,type4=nmrc,type1=n); 32 *%loop(provider=hosp,type=alpha,type4=alph,type1=a); 33 *%loop(provider=hosp,type=nmrc_rpt,type4=nmrc,type1=n); 34 *%loop(provider=rnl,type=alpha,type4=alph,type1=a); 35 *%loop(provider=rnl,type=nmrc_rpt,type4=nmrc,type1=n); 36 %loop(provider=snf,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value snf MLOGIC(LOOP): Parameter TYPE has value alpha MLOGIC(LOOP): Parameter TYPE4 has value alph MLOGIC(LOOP): Parameter TYPE1 has value a SYMBOLGEN: Macro variable PROVIDER resolves to snf MPRINT(LOOP): libname in "/homes/nber/jroth/bulk/cost-reports/snf/"; NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /homes/nber/jroth/bulk/cost-reports/snf MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1995; stop value is 2010; by value is 1. SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha1995_long out=_1995a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1996; loop will iterate again. NOTE: There were 88886 observations read from the data set IN.SNF_ALPHA1995_LONG. NOTE: 88445 observations with duplicate key values were deleted. NOTE: The data set WORK._1995A has 441 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.01 seconds cpu time 0.12 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha1996_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. NOTE: There were 754506 observations read from the data set IN.SNF_ALPHA1996_LONG. NOTE: 753715 observations with duplicate key values were deleted. NOTE: The data set WORK._1996A has 791 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 23.27 seconds 3 The SAS System 16:01 Thursday, December 16, 2010 cpu time 1.08 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha1997_long out=_1997a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1998; loop will iterate again. NOTE: There were 998583 observations read from the data set IN.SNF_ALPHA1997_LONG. NOTE: 997785 observations with duplicate key values were deleted. NOTE: The data set WORK._1997A has 798 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 42.83 seconds cpu time 1.44 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha1998_long out=_1998a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1999; loop will iterate again. NOTE: There were 1115183 observations read from the data set IN.SNF_ALPHA1998_LONG. NOTE: 1114200 observations with duplicate key values were deleted. NOTE: The data set WORK._1998A has 983 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1:06.58 cpu time 1.54 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha1999_long out=_1999a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2000; loop will iterate again. NOTE: There were 1051638 observations read from the data set IN.SNF_ALPHA1999_LONG. NOTE: 1050668 observations with duplicate key values were deleted. NOTE: The data set WORK._1999A has 970 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 20.60 seconds cpu time 1.36 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2000 SYMBOLGEN: Macro variable YEAR resolves to 2000 4 The SAS System 16:01 Thursday, December 16, 2010 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2000_long out=_2000a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2001; loop will iterate again. NOTE: There were 1197841 observations read from the data set IN.SNF_ALPHA2000_LONG. NOTE: 1196840 observations with duplicate key values were deleted. NOTE: The data set WORK._2000A has 1001 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 15.20 seconds cpu time 1.43 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2001_long out=_2001a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2002; loop will iterate again. NOTE: There were 1288288 observations read from the data set IN.SNF_ALPHA2001_LONG. NOTE: 1287387 observations with duplicate key values were deleted. NOTE: The data set WORK._2001A has 901 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 16.01 seconds cpu time 1.68 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2002 SYMBOLGEN: Macro variable YEAR resolves to 2002 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2002_long out=_2002a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2003; loop will iterate again. NOTE: There were 1315385 observations read from the data set IN.SNF_ALPHA2002_LONG. NOTE: 1314503 observations with duplicate key values were deleted. NOTE: The data set WORK._2002A has 882 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 10.40 seconds cpu time 1.66 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2003 SYMBOLGEN: Macro variable YEAR resolves to 2003 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2003_long out=_2003a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2004; loop will iterate again. NOTE: There were 1357782 observations read from the data set IN.SNF_ALPHA2003_LONG. NOTE: 1356791 observations with duplicate key values were deleted. 5 The SAS System 16:01 Thursday, December 16, 2010 NOTE: The data set WORK._2003A has 991 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 9.95 seconds cpu time 1.71 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2004 SYMBOLGEN: Macro variable YEAR resolves to 2004 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2004_long out=_2004a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2005; loop will iterate again. NOTE: There were 1391671 observations read from the data set IN.SNF_ALPHA2004_LONG. NOTE: 1390778 observations with duplicate key values were deleted. NOTE: The data set WORK._2004A has 893 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 7.33 seconds cpu time 1.88 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2005 SYMBOLGEN: Macro variable YEAR resolves to 2005 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2005_long out=_2005a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2006; loop will iterate again. NOTE: There were 1408079 observations read from the data set IN.SNF_ALPHA2005_LONG. NOTE: 1407169 observations with duplicate key values were deleted. NOTE: The data set WORK._2005A has 910 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.83 seconds cpu time 1.74 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2006_long out=_2006a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2007; loop will iterate again. NOTE: There were 1441037 observations read from the data set IN.SNF_ALPHA2006_LONG. NOTE: 1440095 observations with duplicate key values were deleted. NOTE: The data set WORK._2006A has 942 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.58 seconds cpu time 1.64 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf 6 The SAS System 16:01 Thursday, December 16, 2010 SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2007_long out=_2007a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2008; loop will iterate again. NOTE: There were 1455231 observations read from the data set IN.SNF_ALPHA2007_LONG. NOTE: 1454334 observations with duplicate key values were deleted. NOTE: The data set WORK._2007A has 897 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.62 seconds cpu time 1.57 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2008 SYMBOLGEN: Macro variable YEAR resolves to 2008 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2008_long out=_2008a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2009; loop will iterate again. NOTE: There were 1642963 observations read from the data set IN.SNF_ALPHA2008_LONG. NOTE: 1642090 observations with duplicate key values were deleted. NOTE: The data set WORK._2008A has 873 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.05 seconds cpu time 1.63 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2009_long out=_2009a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2010; loop will iterate again. NOTE: There were 1381357 observations read from the data set IN.SNF_ALPHA2009_LONG. NOTE: 1380556 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 801 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.92 seconds cpu time 1.46 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2010_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 not iterate again. 7 The SAS System 16:01 Thursday, December 16, 2010 SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 11525 observations read from the data set IN.SNF_ALPHA2010_LONG. NOTE: 11252 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 273 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.06 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.snf_alph_wksht_clmn_line_combos; SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): set _1995a _1996a _1997a _1998a _1999a _2000a _2001a _2002a _2003a _2004a _2005a _2006a _2007a _2008a _2009a _2010a ; NOTE: There were 441 observations read from the data set WORK._1995A. NOTE: There were 791 observations read from the data set WORK._1996A. NOTE: There were 798 observations read from the data set WORK._1997A. NOTE: There were 983 observations read from the data set WORK._1998A. NOTE: There were 970 observations read from the data set WORK._1999A. NOTE: There were 1001 observations read from the data set WORK._2000A. NOTE: There were 901 observations read from the data set WORK._2001A. NOTE: There were 882 observations read from the data set WORK._2002A. NOTE: There were 991 observations read from the data set WORK._2003A. NOTE: There were 893 observations read from the data set WORK._2004A. NOTE: There were 910 observations read from the data set WORK._2005A. NOTE: There were 942 observations read from the data set WORK._2006A. NOTE: There were 897 observations read from the data set WORK._2007A. NOTE: There were 873 observations read from the data set WORK._2008A. NOTE: There were 801 observations read from the data set WORK._2009A. NOTE: There were 273 observations read from the data set WORK._2010A. NOTE: The data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS has 13347 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc sort data=out.snf_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; NOTE: There were 13347 observations read from the data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS. 8 The SAS System 16:01 Thursday, December 16, 2010 NOTE: 11694 observations with duplicate key values were deleted. NOTE: The data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS has 1653 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.snf_alph_wksht_clmn_line_combos; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st -y snf_alph_wksht_clmn_line_combos.sas7bdat snf_alph_wksht_clmn_line_combos.csv"; MPRINT(LOOP): x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 37 %loop(provider=snf,type=nmrc_rpt,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value snf MLOGIC(LOOP): Parameter TYPE has value nmrc_rpt MLOGIC(LOOP): Parameter TYPE4 has value nmrc MLOGIC(LOOP): Parameter TYPE1 has value n SYMBOLGEN: Macro variable PROVIDER resolves to snf MPRINT(LOOP): libname in "/homes/nber/jroth/bulk/cost-reports/snf/"; NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /homes/nber/jroth/bulk/cost-reports/snf MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1995; stop value is 2010; by value is 1. NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.85 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt1995_long out=_1995n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1996; loop will iterate again. NOTE: There were 811717 observations read from the data set IN.SNF_NMRC_RPT1995_LONG. NOTE: 806166 observations with duplicate key values were deleted. NOTE: The data set WORK._1995N has 5551 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.61 seconds cpu time 0.80 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable YEAR resolves to 1996 SYMBOLGEN: Macro variable TYPE1 resolves to n 9 The SAS System 16:01 Thursday, December 16, 2010 MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt1996_long out=_1996n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1997; loop will iterate again. NOTE: There were 6710843 observations read from the data set IN.SNF_NMRC_RPT1996_LONG. NOTE: 6699313 observations with duplicate key values were deleted. NOTE: The data set WORK._1996N has 11530 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 8.99 seconds cpu time 6.10 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable YEAR resolves to 1997 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt1997_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. NOTE: There were 8663930 observations read from the data set IN.SNF_NMRC_RPT1997_LONG. NOTE: 8651579 observations with duplicate key values were deleted. NOTE: The data set WORK._1997N has 12351 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 8.22 seconds cpu time 8.09 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable YEAR resolves to 1998 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt1998_long out=_1998n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 1999; loop will iterate again. NOTE: There were 10224662 observations read from the data set IN.SNF_NMRC_RPT1998_LONG. NOTE: 10211167 observations with duplicate key values were deleted. NOTE: The data set WORK._1998N has 13495 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 7.47 seconds cpu time 9.71 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable YEAR resolves to 1999 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt1999_long out=_1999n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2000; loop will iterate again. NOTE: There were 9701877 observations read from the data set IN.SNF_NMRC_RPT1999_LONG. NOTE: 9689466 observations with duplicate key values were deleted. NOTE: The data set WORK._1999N has 12411 observations and 3 variables. 10 The SAS System 16:01 Thursday, December 16, 2010 NOTE: PROCEDURE SORT used (Total process time): real time 10.86 seconds cpu time 9.11 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2000 SYMBOLGEN: Macro variable YEAR resolves to 2000 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2000_long out=_2000n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2001; loop will iterate again. NOTE: There were 9466144 observations read from the data set IN.SNF_NMRC_RPT2000_LONG. NOTE: 9452433 observations with duplicate key values were deleted. NOTE: The data set WORK._2000N has 13711 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 10.66 seconds cpu time 8.89 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2001_long out=_2001n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2002; loop will iterate again. NOTE: There were 568012 observations read from the data set IN.SNF_NMRC_RPT2001_LONG. NOTE: 566902 observations with duplicate key values were deleted. NOTE: The data set WORK._2001N has 1110 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.60 seconds cpu time 0.55 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2002 SYMBOLGEN: Macro variable YEAR resolves to 2002 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2002_long out=_2002n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2003; loop will iterate again. NOTE: There were 8186137 observations read from the data set IN.SNF_NMRC_RPT2002_LONG. NOTE: 8173416 observations with duplicate key values were deleted. NOTE: The data set WORK._2002N has 12721 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 7.49 seconds cpu time 7.75 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt 11 The SAS System 16:01 Thursday, December 16, 2010 SYMBOLGEN: Macro variable YEAR resolves to 2003 SYMBOLGEN: Macro variable YEAR resolves to 2003 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2003_long out=_2003n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2004; loop will iterate again. NOTE: There were 8297952 observations read from the data set IN.SNF_NMRC_RPT2003_LONG. NOTE: 8286040 observations with duplicate key values were deleted. NOTE: The data set WORK._2003N has 11912 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 11.80 seconds cpu time 7.65 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2004 SYMBOLGEN: Macro variable YEAR resolves to 2004 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2004_long out=_2004n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2005; loop will iterate again. NOTE: There were 8045722 observations read from the data set IN.SNF_NMRC_RPT2004_LONG. NOTE: 8034056 observations with duplicate key values were deleted. NOTE: The data set WORK._2004N has 11666 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 8.92 seconds cpu time 7.48 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2005 SYMBOLGEN: Macro variable YEAR resolves to 2005 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2005_long out=_2005n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2006; loop will iterate again. NOTE: There were 8097691 observations read from the data set IN.SNF_NMRC_RPT2005_LONG. NOTE: 8086168 observations with duplicate key values were deleted. NOTE: The data set WORK._2005N has 11523 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 10.96 seconds cpu time 7.42 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable YEAR resolves to 2006 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2006_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. 12 The SAS System 16:01 Thursday, December 16, 2010 NOTE: There were 8273136 observations read from the data set IN.SNF_NMRC_RPT2006_LONG. NOTE: 8261309 observations with duplicate key values were deleted. NOTE: The data set WORK._2006N has 11827 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 10.29 seconds cpu time 7.62 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2007_long out=_2007n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2008; loop will iterate again. NOTE: There were 1312833 observations read from the data set IN.SNF_NMRC_RPT2007_LONG. NOTE: 1311552 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 1.08 seconds cpu time 1.31 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2008 SYMBOLGEN: Macro variable YEAR resolves to 2008 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2008_long out=_2008n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2009; loop will iterate again. NOTE: There were 9016617 observations read from the data set IN.SNF_NMRC_RPT2008_LONG. NOTE: 9005825 observations with duplicate key values were deleted. NOTE: The data set WORK._2008N has 10792 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 10.88 seconds cpu time 8.37 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2009_long out=_2009n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2010; loop will iterate again. NOTE: There were 7374079 observations read from the data set IN.SNF_NMRC_RPT2009_LONG. NOTE: 7364717 observations with duplicate key values were deleted. NOTE: The data set WORK._2009N has 9362 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 6.20 seconds cpu time 6.96 seconds 13 The SAS System 16:01 Thursday, December 16, 2010 SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc_rpt SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable YEAR resolves to 2010 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc_rpt2010_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 not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 56061 observations read from the data set IN.SNF_NMRC_RPT2010_LONG. NOTE: 54178 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 1883 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.11 seconds cpu time 0.04 seconds MPRINT(LOOP): data out.snf_nmrc_wksht_clmn_line_combos; SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): set _1995n _1996n _1997n _1998n _1999n _2000n _2001n _2002n _2003n _2004n _2005n _2006n _2007n _2008n _2009n _2010n ; NOTE: There were 5551 observations read from the data set WORK._1995N. NOTE: There were 11530 observations read from the data set WORK._1996N. NOTE: There were 12351 observations read from the data set WORK._1997N. NOTE: There were 13495 observations read from the data set WORK._1998N. NOTE: There were 12411 observations read from the data set WORK._1999N. NOTE: There were 13711 observations read from the data set WORK._2000N. NOTE: There were 1110 observations read from the data set WORK._2001N. NOTE: There were 12721 observations read from the data set WORK._2002N. NOTE: There were 11912 observations read from the data set WORK._2003N. NOTE: There were 11666 observations read from the data set WORK._2004N. NOTE: There were 11523 observations read from the data set WORK._2005N. NOTE: There were 11827 observations read from the data set WORK._2006N. NOTE: There were 1281 observations read from the data set WORK._2007N. NOTE: There were 10792 observations read from the data set WORK._2008N. NOTE: There were 9362 observations read from the data set WORK._2009N. NOTE: There were 1883 observations read from the data set WORK._2010N. NOTE: The data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS has 153126 observations and 3 variables. NOTE: DATA statement used (Total process time): 14 The SAS System 16:01 Thursday, December 16, 2010 real time 0.05 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc sort data=out.snf_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; NOTE: There were 153126 observations read from the data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 125688 observations with duplicate key values were deleted. NOTE: The data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS has 27438 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.08 seconds cpu time 0.15 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.snf_nmrc_wksht_clmn_line_combos; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st -y snf_nmrc_wksht_clmn_line_combos.sas7bdat snf_nmrc_wksht_clmn_line_combos.csv"; MPRINT(LOOP): x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. NOTE: The PROCEDURE CONTENTS printed page 2. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.53 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 5:49.20 cpu time 2:00.21