1 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3 MBCS3170) Licensed to NATIONAL BUREAU OF ECONOMIC RESEARCH, Site 70111350. NOTE: This session is executing on the Linux 2.6.32-696.18.7.el6.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.1 NOTE: Additional host information: Linux LIN X64 2.6.32-696.18.7.el6.x86_64 #1 SMP Wed Jan 3 19:31:16 CST 2018 x86_64 Scientific Linux release 6.9 (Carbon) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS initialization used: real time 0.06 seconds cpu time 0.00 seconds 1 options nocenter; 2 options notes mlogic mprint symbolgen; 3 ** by Jean Roth, jroth@nber.org , 2096-12-15 ; 4 5 libname out "."; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2540-96 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=2540_96; 9 %let DASH=2540-96; 10 *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./&DASH."; 11 libname in "."; 12 13 %do year=1995 %to 2012; 14 15 *hosp_rpt2552_96_; 16 %let ds=&provider._&type.&form._&year._long; 17 *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) 17 ! nodupkey; 2 The SAS System 12:43 Wednesday, October 24, 2018 18 proc sort data=in.&ds. out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 19 by wksht_cd clmn_num line_num; 20 %end; 21 22 data out.&provider._&type4._wksht_clmn_line_combos; 23 set 24 _2012&type1. _2011&type1. _2010&type1. 25 _2009&type1. _2008&type1. _2007&type1. _2006&type1. _2005&type1. 26 _2004&type1. _2003&type1. _2002&type1. _2001&type1. _2000&type1. 27 _1999&type1. _1998&type1. _1997&type1. _1996&type1. _1995&type1. 28 ; 29 30 proc sort data=out.&provider._&type4._wksht_clmn_line_combos nodupkey; 31 by wksht_cd line_num clmn_num ; 32 33 data out.&provider._&type4._wksht_clmn_line_combos; 34 retain wksht_cd line_num clmn_num; 35 set out.&provider._&type4._wksht_clmn_line_combos; 36 37 proc contents data=out.&provider._&type4._wksht_clmn_line_combos; 38 39 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.csv -o -y"; 40 x "st &provider._&type4._wksht_clmn_line_combos.sas7bdat &provider._&type4._wksht_clmn_line_combos.dta -o -y"; 41 *x "echo 'combo done' | mail jroth"; 42 %mend loop; 43 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 44 *%loop(provider=hha,type=nmrc,type4=nmrc,type1=n); 45 *%loop(provider=hosp,form=2552_96,type=alpha,type4=alph,type1=a); 46 *%loop(provider=hosp,form=2552_96,type=nmrc,type4=nmrc,type1=n); 47 *%loop(provider=rnl,type=alpha,type4=alph,type1=a); 48 *%loop(provider=rnl,type=nmrc,type4=nmrc,type1=n); 49 %loop(provider=snf,form=2540_96,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value snf MLOGIC(LOOP): Parameter FORM has value 2540_96 MLOGIC(LOOP): Parameter TYPE has value alpha MLOGIC(LOOP): Parameter TYPE4 has value alph MLOGIC(LOOP): Parameter TYPE1 has value a MLOGIC(LOOP): %LET (variable name is UNDERSCORE) MLOGIC(LOOP): %LET (variable name is DASH) MPRINT(LOOP): *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./&DASH."; MPRINT(LOOP): libname in "."; NOTE: Libref IN refers to the same physical library as OUT. NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2540-96 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1995; stop value is 2012; by value is 1. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1995 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_1995_long NOTE: Data file IN.SNF_ALPHA2540_96_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 3 The SAS System 12:43 Wednesday, October 24, 2018 might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 1995 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1996 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 88886 observations read from the data set IN.SNF_ALPHA2540_96_1995_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 0.06 seconds cpu time 0.06 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_1996_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1997 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 754584 observations read from the data set IN.SNF_ALPHA2540_96_1996_LONG. NOTE: 753792 observations with duplicate key values were deleted. NOTE: The data set WORK._1996A has 792 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 snf_alpha2540_96_1997_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. 4 The SAS System 12:43 Wednesday, October 24, 2018 MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1998 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 998716 observations read from the data set IN.SNF_ALPHA2540_96_1997_LONG. NOTE: 997917 observations with duplicate key values were deleted. NOTE: The data set WORK._1997A has 799 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.37 seconds cpu time 0.58 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_1998_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1999 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1115317 observations read from the data set IN.SNF_ALPHA2540_96_1998_LONG. NOTE: 1114330 observations with duplicate key values were deleted. NOTE: The data set WORK._1998A has 987 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.47 seconds cpu time 0.64 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_1999_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2000 5 The SAS System 12:43 Wednesday, October 24, 2018 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1051982 observations read from the data set IN.SNF_ALPHA2540_96_1999_LONG. NOTE: 1051011 observations with duplicate key values were deleted. NOTE: The data set WORK._1999A has 971 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.19 seconds cpu time 0.60 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2000_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2001 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1198052 observations read from the data set IN.SNF_ALPHA2540_96_2000_LONG. NOTE: 1197050 observations with duplicate key values were deleted. NOTE: The data set WORK._2000A has 1002 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.24 seconds cpu time 0.70 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2001_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2002 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1288562 observations read from the data set IN.SNF_ALPHA2540_96_2001_LONG. NOTE: 1287658 observations with duplicate key values were deleted. NOTE: The data set WORK._2001A has 904 observations and 3 variables. 6 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: PROCEDURE SORT used (Total process time): real time 0.63 seconds cpu time 0.75 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2002_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2003 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1315391 observations read from the data set IN.SNF_ALPHA2540_96_2002_LONG. NOTE: 1314509 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 2.11 seconds cpu time 0.78 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2003_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2004 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1357928 observations read from the data set IN.SNF_ALPHA2540_96_2003_LONG. NOTE: 1356936 observations with duplicate key values were deleted. NOTE: The data set WORK._2003A has 992 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.65 seconds cpu time 0.79 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2004_long 7 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2005 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1391632 observations read from the data set IN.SNF_ALPHA2540_96_2004_LONG. NOTE: 1390738 observations with duplicate key values were deleted. NOTE: The data set WORK._2004A has 894 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.32 seconds cpu time 0.82 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2005_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2006 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1408087 observations read from the data set IN.SNF_ALPHA2540_96_2005_LONG. NOTE: 1407176 observations with duplicate key values were deleted. NOTE: The data set WORK._2005A has 911 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.56 seconds cpu time 0.83 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2006_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_2006_long out=_2006a (keep=wksht_cd clmn_num line_num) nodupkey; 8 The SAS System 12:43 Wednesday, October 24, 2018 MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2007; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2007 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1441557 observations read from the data set IN.SNF_ALPHA2540_96_2006_LONG. NOTE: 1440604 observations with duplicate key values were deleted. NOTE: The data set WORK._2006A has 953 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.75 seconds cpu time 0.84 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2007_long NOTE: Data file IN.SNF_ALPHA2540_96_2007_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2007 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2008 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1456035 observations read from the data set IN.SNF_ALPHA2540_96_2007_LONG. NOTE: 1455128 observations with duplicate key values were deleted. NOTE: The data set WORK._2007A has 907 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.53 seconds cpu time 0.86 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2008_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha 9 The SAS System 12:43 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2009 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1646882 observations read from the data set IN.SNF_ALPHA2540_96_2008_LONG. NOTE: 1645999 observations with duplicate key values were deleted. NOTE: The data set WORK._2008A has 883 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.60 seconds cpu time 0.97 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2009_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2010 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1674412 observations read from the data set IN.SNF_ALPHA2540_96_2009_LONG. NOTE: 1673504 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 908 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.61 seconds cpu time 0.99 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2010_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2011 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1700107 observations read from the data set IN.SNF_ALPHA2540_96_2010_LONG. 10 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: 1699172 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 935 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.11 seconds cpu time 1.01 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2011_long NOTE: Data file IN.SNF_ALPHA2540_96_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.snf_alpha2540_96_2011_long out=_2011a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2012 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 237474 observations read from the data set IN.SNF_ALPHA2540_96_2011_LONG. NOTE: 236880 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 594 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.16 seconds cpu time 0.13 seconds SYMBOLGEN: Macro variable DS resolves to snf_alpha2540_96_2012_long NOTE: Data file IN.SNF_ALPHA2540_96_2012_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2012 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.snf_alpha2540_96_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 not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 114 observations read from the data set IN.SNF_ALPHA2540_96_2012_LONG. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK._2012A has 114 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 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 11 The SAS System 12:43 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): set _2012a _2011a _2010a _2009a _2008a _2007a _2006a _2005a _2004a _2003a _2002a _2001a _2000a _1999a _1998a _1997a _1996a _1995a ; NOTE: Data file OUT.SNF_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 114 observations read from the data set WORK._2012A. NOTE: There were 594 observations read from the data set WORK._2011A. NOTE: There were 935 observations read from the data set WORK._2010A. NOTE: There were 908 observations read from the data set WORK._2009A. NOTE: There were 883 observations read from the data set WORK._2008A. NOTE: There were 907 observations read from the data set WORK._2007A. NOTE: There were 953 observations read from the data set WORK._2006A. NOTE: There were 911 observations read from the data set WORK._2005A. NOTE: There were 894 observations read from the data set WORK._2004A. NOTE: There were 992 observations read from the data set WORK._2003A. NOTE: There were 882 observations read from the data set WORK._2002A. NOTE: There were 904 observations read from the data set WORK._2001A. NOTE: There were 1002 observations read from the data set WORK._2000A. NOTE: There were 971 observations read from the data set WORK._1999A. NOTE: There were 987 observations read from the data set WORK._1998A. NOTE: There were 799 observations read from the data set WORK._1997A. NOTE: There were 792 observations read from the data set WORK._1996A. NOTE: There were 441 observations read from the data set WORK._1995A. NOTE: The data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS has 14869 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.SNF_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.snf_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.SNF_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 14869 observations read from the data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 13163 observations with duplicate key values were deleted. 12 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: The data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS has 1706 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.snf_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set out.snf_alph_wksht_clmn_line_combos; NOTE: Data file OUT.SNF_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.SNF_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 1706 observations read from the data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.SNF_ALPH_WKSHT_CLMN_LINE_COMBOS has 1706 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.snf_alph_wksht_clmn_line_combos; NOTE: Data file OUT.SNF_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 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 snf_alph_wksht_clmn_line_combos.sas7bdat snf_alph_wksht_clmn_line_combos.csv -o -y"; 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 snf_alph_wksht_clmn_line_combos.sas7bdat snf_alph_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 50 %loop(provider=snf,form=2540_96,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value snf MLOGIC(LOOP): Parameter FORM has value 2540_96 MLOGIC(LOOP): Parameter TYPE has value nmrc MLOGIC(LOOP): Parameter TYPE4 has value nmrc MLOGIC(LOOP): Parameter TYPE1 has value n MLOGIC(LOOP): %LET (variable name is UNDERSCORE) MLOGIC(LOOP): %LET (variable name is DASH) MPRINT(LOOP): *libname in "/homes/nber/jroth/bulk/cost-reports/&provider./&DASH."; MPRINT(LOOP): libname in "."; NOTE: Libref IN refers to the same physical library as OUT. NOTE: Libref IN was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/2540-96 13 The SAS System 12:43 Wednesday, October 24, 2018 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 1995; stop value is 2012; by value is 1. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1995 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 1.82 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_1995_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1996 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 811717 observations read from the data set IN.SNF_NMRC2540_96_1995_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.24 seconds cpu time 0.42 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_1996_long NOTE: Data file IN.SNF_NMRC2540_96_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 n MPRINT(LOOP): proc sort data=in.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1997 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) 14 The SAS System 12:43 Wednesday, October 24, 2018 nodupkey; NOTE: There were 6710855 observations read from the data set IN.SNF_NMRC2540_96_1996_LONG. NOTE: 6699306 observations with duplicate key values were deleted. NOTE: The data set WORK._1996N has 11549 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.25 seconds cpu time 3.74 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_1997_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1998 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8664038 observations read from the data set IN.SNF_NMRC2540_96_1997_LONG. NOTE: 8651655 observations with duplicate key values were deleted. NOTE: The data set WORK._1997N has 12383 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.76 seconds cpu time 4.67 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_1998_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 1999 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 10223087 observations read from the data set IN.SNF_NMRC2540_96_1998_LONG. NOTE: 10209609 observations with duplicate key values were deleted. NOTE: The data set WORK._1998N has 13478 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): 15 The SAS System 12:43 Wednesday, October 24, 2018 real time 9.01 seconds cpu time 5.58 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_1999_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2000 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 9716599 observations read from the data set IN.SNF_NMRC2540_96_1999_LONG. NOTE: 9704177 observations with duplicate key values were deleted. NOTE: The data set WORK._1999N has 12422 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.31 seconds cpu time 5.28 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2000_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2001 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 9467180 observations read from the data set IN.SNF_NMRC2540_96_2000_LONG. NOTE: 9453460 observations with duplicate key values were deleted. NOTE: The data set WORK._2000N has 13720 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.92 seconds cpu time 5.12 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2001_long NOTE: Data file IN.SNF_NMRC2540_96_2001_LONG.DATA is in a format that is native to another host, or the file encoding does not 16 The SAS System 12:43 Wednesday, October 24, 2018 match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2001 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2002 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8484905 observations read from the data set IN.SNF_NMRC2540_96_2001_LONG. NOTE: 8471790 observations with duplicate key values were deleted. NOTE: The data set WORK._2001N has 13115 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.05 seconds cpu time 4.62 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2002_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2003 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8186141 observations read from the data set IN.SNF_NMRC2540_96_2002_LONG. NOTE: 8173420 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 3.55 seconds cpu time 4.46 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2003_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_2003_long out=_2003n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; 17 The SAS System 12:43 Wednesday, October 24, 2018 MLOGIC(LOOP): %DO loop index variable YEAR is now 2004; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2004 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8298604 observations read from the data set IN.SNF_NMRC2540_96_2003_LONG. NOTE: 8286688 observations with duplicate key values were deleted. NOTE: The data set WORK._2003N has 11916 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.08 seconds cpu time 4.64 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2004_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2005 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8045845 observations read from the data set IN.SNF_NMRC2540_96_2004_LONG. NOTE: 8034172 observations with duplicate key values were deleted. NOTE: The data set WORK._2004N has 11673 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.11 seconds cpu time 4.39 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2005_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 18 The SAS System 12:43 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable YEAR resolves to 2006 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8097681 observations read from the data set IN.SNF_NMRC2540_96_2005_LONG. NOTE: 8086153 observations with duplicate key values were deleted. NOTE: The data set WORK._2005N has 11528 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.60 seconds cpu time 4.43 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2006_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_2006_long out=_2006n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2007; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2007 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8275142 observations read from the data set IN.SNF_NMRC2540_96_2006_LONG. NOTE: 8263276 observations with duplicate key values were deleted. NOTE: The data set WORK._2006N has 11866 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.65 seconds cpu time 4.50 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2007_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2008 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8147597 observations read from the data set IN.SNF_NMRC2540_96_2007_LONG. NOTE: 8136395 observations with duplicate key values were deleted. 19 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: The data set WORK._2007N has 11202 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.48 seconds cpu time 4.57 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2008_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2009 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 9030137 observations read from the data set IN.SNF_NMRC2540_96_2008_LONG. NOTE: 9019319 observations with duplicate key values were deleted. NOTE: The data set WORK._2008N has 10818 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.88 seconds cpu time 4.91 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2009_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_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. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2010 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 8927517 observations read from the data set IN.SNF_NMRC2540_96_2009_LONG. NOTE: 8917247 observations with duplicate key values were deleted. NOTE: The data set WORK._2009N has 10270 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.88 seconds cpu time 4.85 seconds 20 The SAS System 12:43 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2010_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_2010_long out=_2010n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2011; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2011 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 9077974 observations read from the data set IN.SNF_NMRC2540_96_2010_LONG. NOTE: 9067807 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 10167 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 2.92 seconds cpu time 4.95 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2011_long NOTE: Data file IN.SNF_NMRC2540_96_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.snf_nmrc2540_96_2011_long out=_2011n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will iterate again. MPRINT(LOOP): *hosp_rpt2552_96_; MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 2540_96 SYMBOLGEN: Macro variable YEAR resolves to 2012 MPRINT(LOOP): *proc sort data=in.&provider._&type.&UNDERSCORE._&year._long out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; NOTE: There were 1167621 observations read from the data set IN.SNF_NMRC2540_96_2011_LONG. NOTE: 1162261 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 5360 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.35 seconds cpu time 0.62 seconds SYMBOLGEN: Macro variable DS resolves to snf_nmrc2540_96_2012_long NOTE: Data file IN.SNF_NMRC2540_96_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 21 The SAS System 12:43 Wednesday, October 24, 2018 MPRINT(LOOP): proc sort data=in.snf_nmrc2540_96_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 not iterate again. SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 721 observations read from the data set IN.SNF_NMRC2540_96_2012_LONG. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK._2012N has 721 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.00 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 SYMBOLGEN: Macro variable TYPE1 resolves to n SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): set _2012n _2011n _2010n _2009n _2008n _2007n _2006n _2005n _2004n _2003n _2002n _2001n _2000n _1999n _1998n _1997n _1996n _1995n ; NOTE: Data file OUT.SNF_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 721 observations read from the data set WORK._2012N. NOTE: There were 5360 observations read from the data set WORK._2011N. NOTE: There were 10167 observations read from the data set WORK._2010N. NOTE: There were 10270 observations read from the data set WORK._2009N. NOTE: There were 10818 observations read from the data set WORK._2008N. NOTE: There were 11202 observations read from the data set WORK._2007N. NOTE: There were 11866 observations read from the data set WORK._2006N. NOTE: There were 11528 observations read from the data set WORK._2005N. NOTE: There were 11673 observations read from the data set WORK._2004N. NOTE: There were 11916 observations read from the data set WORK._2003N. NOTE: There were 12721 observations read from the data set WORK._2002N. NOTE: There were 13115 observations read from the data set WORK._2001N. NOTE: There were 13720 observations read from the data set WORK._2000N. NOTE: There were 12422 observations read from the data set WORK._1999N. NOTE: There were 13478 observations read from the data set WORK._1998N. NOTE: There were 12383 observations read from the data set WORK._1997N. NOTE: There were 11549 observations read from the data set WORK._1996N. NOTE: There were 5551 observations read from the data set WORK._1995N. NOTE: The data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS has 190460 observations and 3 variables. 22 The SAS System 12:43 Wednesday, October 24, 2018 NOTE: DATA statement used (Total process time): real time 0.18 seconds cpu time 0.05 seconds SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.SNF_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.snf_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.SNF_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 190460 observations read from the data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 163581 observations with duplicate key values were deleted. NOTE: The data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS has 26879 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.20 seconds cpu time 0.11 seconds MPRINT(LOOP): data out.snf_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set out.snf_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.SNF_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.SNF_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 26879 observations read from the data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.SNF_NMRC_WKSHT_CLMN_LINE_COMBOS has 26879 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.02 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; NOTE: Data file OUT.SNF_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 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 snf_nmrc_wksht_clmn_line_combos.sas7bdat snf_nmrc_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROVIDER resolves to snf SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROVIDER resolves to snf 23 The SAS System 12:43 Wednesday, October 24, 2018 SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st snf_nmrc_wksht_clmn_line_combos.sas7bdat snf_nmrc_wksht_clmn_line_combos.dta -o -y"; 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.93 seconds cpu time 0.00 seconds NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 1:10.40 cpu time 1:23.79