1 The SAS System 18:09 Monday, April 15, 2019 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3 MBCS3170) Licensed to NATIONAL BUREAU OF ECONOMIC RESEARCH, Site 70111350. NOTE: This session is executing on the Linux 3.10.0-957.1.3.el7.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.1 NOTE: Additional host information: Linux LIN X64 3.10.0-957.1.3.el7.x86_64 #1 SMP Mon Nov 26 12:36:06 CST 2018 x86_64 Scientific Linux release 7.6 (Nitrogen) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS initialization used: real time 0.07 seconds cpu time 0.03 seconds 1 options nocenter; 2 options notes mlogic mprint symbolgen; 3 ** by Jean Roth, jroth@nber.org , 2010-12-15 ; 4 5 libname out "."; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/222-92 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=222_92; 9 %let DASH=222-92; 10 ** SAS has a limit of 32-characters to a dataset name, so making a shorter name ; 11 %let prov=%substr(&provider.,1,3); 12 libname in "."; 13 14 %do year=2009 %to 2018; 15 16 %let ds=&provider._&type.&form._&year._long; 17 proc sort data=in.&ds. out=_&year.&type1. (keep=wksht_cd clmn_num line_num) nodupkey; 18 by wksht_cd clmn_num line_num; 2 The SAS System 18:09 Monday, April 15, 2019 19 %end; 20 21 data out.&prov._&type4._wksht_clmn_line_combos; 22 set 23 _2009&type1. 24 _2010&type1. _2011&type1. _2012&type1. _2013&type1. _2014&type1. 25 _2015&type1. _2016&type1. _2017&type1. _2018&type1. 26 ; 27 28 proc sort data=out.&prov._&type4._wksht_clmn_line_combos nodupkey; 29 by wksht_cd line_num clmn_num ; 30 31 data out.&prov._&type4._wksht_clmn_line_combos; 32 retain wksht_cd line_num clmn_num; 33 set out.&prov._&type4._wksht_clmn_line_combos; 34 35 proc contents data=out.&prov._&type4._wksht_clmn_line_combos; 36 37 x "st &prov._&type4._wksht_clmn_line_combos.sas7bdat &prov._&type4._wksht_clmn_line_combos.csv -o -y"; 38 x "st &prov._&type4._wksht_clmn_line_combos.sas7bdat &prov._&type4._wksht_clmn_line_combos.dta -o -y"; 39 *x "echo 'combo done' | mail jroth"; 40 %mend loop; 41 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 42 *%loop(provider=hha,type=nmrc,type4=nmrc,type1=n); 43 *%loop(provider=hosp,form=2552_10,type=alpha,type4=alph,type1=a); 44 *%loop(provider=hosp,form=2552_10,type=nmrc,type4=nmrc,type1=n); 45 %loop(provider=hclinic,form=222_92,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hclinic MLOGIC(LOOP): Parameter FORM has value 222_92 MLOGIC(LOOP): Parameter TYPE has value alpha MLOGIC(LOOP): Parameter TYPE4 has value alph MLOGIC(LOOP): Parameter TYPE1 has value a MLOGIC(LOOP): %LET (variable name is UNDERSCORE) MLOGIC(LOOP): %LET (variable name is DASH) MPRINT(LOOP): ** SAS has a limit of 32-characters to a dataset name, so making a shorter name ; MLOGIC(LOOP): %LET (variable name is PROV) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic 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/222-92 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 2009; stop value is 2018; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2009 SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2009_long NOTE: Data file IN.HCLINIC_ALPHA222_92_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.hclinic_alpha222_92_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. 3 The SAS System 18:09 Monday, April 15, 2019 MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: There were 126418 observations read from the data set IN.HCLINIC_ALPHA222_92_2009_LONG. NOTE: 124583 observations with duplicate key values were deleted. NOTE: The data set WORK._2009A has 1835 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.09 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2010_long NOTE: Data file IN.HCLINIC_ALPHA222_92_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.hclinic_alpha222_92_2010_long out=_2010a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2011; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 370341 observations read from the data set IN.HCLINIC_ALPHA222_92_2010_LONG. NOTE: 368548 observations with duplicate key values were deleted. NOTE: The data set WORK._2010A has 1793 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.19 seconds cpu time 0.31 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2011_long NOTE: Data file IN.HCLINIC_ALPHA222_92_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.hclinic_alpha222_92_2011_long out=_2011a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2012 NOTE: There were 375547 observations read from the data set IN.HCLINIC_ALPHA222_92_2011_LONG. NOTE: 373818 observations with duplicate key values were deleted. NOTE: The data set WORK._2011A has 1729 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.19 seconds cpu time 0.32 seconds 4 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2012_long NOTE: Data file IN.HCLINIC_ALPHA222_92_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.hclinic_alpha222_92_2012_long out=_2012a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2013; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2013 NOTE: There were 387325 observations read from the data set IN.HCLINIC_ALPHA222_92_2012_LONG. NOTE: 385630 observations with duplicate key values were deleted. NOTE: The data set WORK._2012A has 1695 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.20 seconds cpu time 0.34 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2013_long NOTE: Data file IN.HCLINIC_ALPHA222_92_2013_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2013 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hclinic_alpha222_92_2013_long out=_2013a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2014; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2014 NOTE: There were 401717 observations read from the data set IN.HCLINIC_ALPHA222_92_2013_LONG. NOTE: 400025 observations with duplicate key values were deleted. NOTE: The data set WORK._2013A has 1692 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.21 seconds cpu time 0.34 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2014_long NOTE: Data file IN.HCLINIC_ALPHA222_92_2014_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2014 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hclinic_alpha222_92_2014_long out=_2014a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2015; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) 5 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2015 NOTE: There were 418647 observations read from the data set IN.HCLINIC_ALPHA222_92_2014_LONG. NOTE: 416948 observations with duplicate key values were deleted. NOTE: The data set WORK._2014A has 1699 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.22 seconds cpu time 0.36 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2015_long NOTE: Data file IN.HCLINIC_ALPHA222_92_2015_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hclinic_alpha222_92_2015_long out=_2015a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2016; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2016 NOTE: There were 148057 observations read from the data set IN.HCLINIC_ALPHA222_92_2015_LONG. NOTE: 147127 observations with duplicate key values were deleted. NOTE: The data set WORK._2015A has 930 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.09 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2016_long NOTE: Data file IN.HCLINIC_ALPHA222_92_2016_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hclinic_alpha222_92_2016_long out=_2016a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2017; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2017 NOTE: There were 126155 observations read from the data set IN.HCLINIC_ALPHA222_92_2016_LONG. NOTE: 125320 observations with duplicate key values were deleted. NOTE: The data set WORK._2016A has 835 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.08 seconds cpu time 0.08 seconds 6 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hclinic_alpha222_92_2017_long out=_2017a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 118239 observations read from the data set IN.HCLINIC_ALPHA222_92_2017_LONG. NOTE: 117429 observations with duplicate key values were deleted. NOTE: The data set WORK._2017A has 810 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_alpha222_92_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.hclinic_alpha222_92_2018_long out=_2018a (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2019; loop will not iterate again. SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 2499 observations read from the data set IN.HCLINIC_ALPHA222_92_2018_LONG. NOTE: 2241 observations with duplicate key values were deleted. NOTE: The data set WORK._2018A has 258 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.hcl_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 MPRINT(LOOP): set _2009a _2010a _2011a _2012a _2013a _2014a _2015a _2016a _2017a _2018a ; NOTE: Data file OUT.HCL_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 1835 observations read from the data set WORK._2009A. NOTE: There were 1793 observations read from the data set WORK._2010A. NOTE: There were 1729 observations read from the data set WORK._2011A. NOTE: There were 1695 observations read from the data set WORK._2012A. 7 The SAS System 18:09 Monday, April 15, 2019 NOTE: There were 1692 observations read from the data set WORK._2013A. NOTE: There were 1699 observations read from the data set WORK._2014A. NOTE: There were 930 observations read from the data set WORK._2015A. NOTE: There were 835 observations read from the data set WORK._2016A. NOTE: There were 810 observations read from the data set WORK._2017A. NOTE: There were 258 observations read from the data set WORK._2018A. NOTE: The data set OUT.HCL_ALPH_WKSHT_CLMN_LINE_COMBOS has 13276 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.33 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HCL_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.hcl_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: Data file OUT.HCL_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 13276 observations read from the data set OUT.HCL_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 11201 observations with duplicate key values were deleted. NOTE: The data set OUT.HCL_ALPH_WKSHT_CLMN_LINE_COMBOS has 2075 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(LOOP): data out.hcl_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set out.hcl_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HCL_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.HCL_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 2075 observations read from the data set OUT.HCL_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HCL_ALPH_WKSHT_CLMN_LINE_COMBOS has 2075 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.hcl_alph_wksht_clmn_line_combos; NOTE: Data file OUT.HCL_ALPH_WKSHT_CLMN_LINE_COMBOS.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable PROV resolves to hcl 8 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hcl_alph_wksht_clmn_line_combos.sas7bdat hcl_alph_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st hcl_alph_wksht_clmn_line_combos.sas7bdat hcl_alph_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 46 %loop(provider=hclinic,form=222_92,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value hclinic MLOGIC(LOOP): Parameter FORM has value 222_92 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): ** SAS has a limit of 32-characters to a dataset name, so making a shorter name ; MLOGIC(LOOP): %LET (variable name is PROV) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic 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/222-92 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 2009; stop value is 2018; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2009 NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.28 seconds cpu time 0.05 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2009_long NOTE: Data file IN.HCLINIC_NMRC222_92_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.hclinic_nmrc222_92_2009_long out=_2009n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2010; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2010 NOTE: There were 286755 observations read from the data set IN.HCLINIC_NMRC222_92_2009_LONG. NOTE: 284088 observations with duplicate key values were deleted. 9 The SAS System 18:09 Monday, April 15, 2019 NOTE: The data set WORK._2009N has 2667 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.12 seconds cpu time 0.22 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2010_long NOTE: Data file IN.HCLINIC_NMRC222_92_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.hclinic_nmrc222_92_2010_long out=_2010n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2011; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2011 NOTE: There were 843422 observations read from the data set IN.HCLINIC_NMRC222_92_2010_LONG. NOTE: 840419 observations with duplicate key values were deleted. NOTE: The data set WORK._2010N has 3003 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.38 seconds cpu time 0.66 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2011_long NOTE: Data file IN.HCLINIC_NMRC222_92_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.hclinic_nmrc222_92_2011_long out=_2011n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2012; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2012 NOTE: There were 865204 observations read from the data set IN.HCLINIC_NMRC222_92_2011_LONG. NOTE: 862292 observations with duplicate key values were deleted. NOTE: The data set WORK._2011N has 2912 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.38 seconds cpu time 0.67 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2012_long NOTE: Data file IN.HCLINIC_NMRC222_92_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 10 The SAS System 18:09 Monday, April 15, 2019 MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2012_long out=_2012n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2013; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2013 NOTE: There were 889417 observations read from the data set IN.HCLINIC_NMRC222_92_2012_LONG. NOTE: 886394 observations with duplicate key values were deleted. NOTE: The data set WORK._2012N has 3023 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.40 seconds cpu time 0.72 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2013_long NOTE: Data file IN.HCLINIC_NMRC222_92_2013_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2013 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2013_long out=_2013n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2014; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2014 NOTE: There were 904652 observations read from the data set IN.HCLINIC_NMRC222_92_2013_LONG. NOTE: 901559 observations with duplicate key values were deleted. NOTE: The data set WORK._2013N has 3093 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.41 seconds cpu time 0.70 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2014_long NOTE: Data file IN.HCLINIC_NMRC222_92_2014_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2014 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2014_long out=_2014n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2015; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2015 NOTE: There were 931175 observations read from the data set IN.HCLINIC_NMRC222_92_2014_LONG. NOTE: 928019 observations with duplicate key values were deleted. NOTE: The data set WORK._2014N has 3156 observations and 3 variables. 11 The SAS System 18:09 Monday, April 15, 2019 NOTE: PROCEDURE SORT used (Total process time): real time 0.42 seconds cpu time 0.74 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2015_long NOTE: Data file IN.HCLINIC_NMRC222_92_2015_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2015_long out=_2015n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2016; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2016 NOTE: There were 354367 observations read from the data set IN.HCLINIC_NMRC222_92_2015_LONG. NOTE: 352308 observations with duplicate key values were deleted. NOTE: The data set WORK._2015N has 2059 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.27 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2016_long NOTE: Data file IN.HCLINIC_NMRC222_92_2016_LONG.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2016_long out=_2016n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2017; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2017 NOTE: There were 320824 observations read from the data set IN.HCLINIC_NMRC222_92_2016_LONG. NOTE: 318816 observations with duplicate key values were deleted. NOTE: The data set WORK._2016N has 2008 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.25 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2017_long out=_2017n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) 12 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable PROVIDER resolves to hclinic SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 222_92 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 305862 observations read from the data set IN.HCLINIC_NMRC222_92_2017_LONG. NOTE: 303899 observations with duplicate key values were deleted. NOTE: The data set WORK._2017N has 1963 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.07 seconds cpu time 0.13 seconds SYMBOLGEN: Macro variable DS resolves to hclinic_nmrc222_92_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.hclinic_nmrc222_92_2018_long out=_2018n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2019; loop will not iterate again. SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 5405 observations read from the data set IN.HCLINIC_NMRC222_92_2018_LONG. NOTE: 4717 observations with duplicate key values were deleted. NOTE: The data set WORK._2018N has 688 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.hcl_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 MPRINT(LOOP): set _2009n _2010n _2011n _2012n _2013n _2014n _2015n _2016n _2017n _2018n ; NOTE: Data file OUT.HCL_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 2667 observations read from the data set WORK._2009N. NOTE: There were 3003 observations read from the data set WORK._2010N. NOTE: There were 2912 observations read from the data set WORK._2011N. NOTE: There were 3023 observations read from the data set WORK._2012N. NOTE: There were 3093 observations read from the data set WORK._2013N. NOTE: There were 3156 observations read from the data set WORK._2014N. NOTE: There were 2059 observations read from the data set WORK._2015N. NOTE: There were 2008 observations read from the data set WORK._2016N. NOTE: There were 1963 observations read from the data set WORK._2017N. NOTE: There were 688 observations read from the data set WORK._2018N. NOTE: The data set OUT.HCL_NMRC_WKSHT_CLMN_LINE_COMBOS has 24572 observations and 3 variables. NOTE: DATA statement used (Total process time): 13 The SAS System 18:09 Monday, April 15, 2019 real time 0.39 seconds cpu time 0.02 seconds SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.HCL_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.hcl_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: Data file OUT.HCL_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 24572 observations read from the data set OUT.HCL_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 20925 observations with duplicate key values were deleted. NOTE: The data set OUT.HCL_NMRC_WKSHT_CLMN_LINE_COMBOS has 3647 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds MPRINT(LOOP): data out.hcl_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set out.hcl_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HCL_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.HCL_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 3647 observations read from the data set OUT.HCL_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.HCL_NMRC_WKSHT_CLMN_LINE_COMBOS has 3647 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.hcl_nmrc_wksht_clmn_line_combos; NOTE: Data file OUT.HCL_NMRC_WKSHT_CLMN_LINE_COMBOS.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st hcl_nmrc_wksht_clmn_line_combos.sas7bdat hcl_nmrc_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROV resolves to hcl SYMBOLGEN: Macro variable TYPE4 resolves to nmrc 14 The SAS System 18:09 Monday, April 15, 2019 MPRINT(LOOP): x "st hcl_nmrc_wksht_clmn_line_combos.sas7bdat hcl_nmrc_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 47 *%loop(provider=snf,form=2540_10,type=alpha,type4=alph,type1=a); 48 *%loop(provider=snf,form=2540_10,type=nmrc,type4=nmrc,type1=n); NOTE: The PROCEDURE CONTENTS printed page 2. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.23 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.31 seconds cpu time 6.53 seconds