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.05 seconds cpu time 0.02 seconds 1 options nocenter; 2 options notes mlogic mprint symbolgen; 3 ** by Jean Roth, jroth@nber.org , 2010-12-15 ; 4 5 libname out "."; NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /disk/data3/hcris/224-14 6 7 %macro loop(provider=,form=,type=,type4=,type1=); 8 %let UNDERSCORE=224_14; 9 %let DASH=224-14; 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=2015 %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 _2015&type1. _2016&type1. _2017&type1. _2018&type1. 24 ; 25 26 proc sort data=out.&prov._&type4._wksht_clmn_line_combos nodupkey; 27 by wksht_cd line_num clmn_num ; 28 29 data out.&prov._&type4._wksht_clmn_line_combos; 30 retain wksht_cd line_num clmn_num; 31 set out.&prov._&type4._wksht_clmn_line_combos; 32 33 proc contents data=out.&prov._&type4._wksht_clmn_line_combos; 34 35 x "st &prov._&type4._wksht_clmn_line_combos.sas7bdat &prov._&type4._wksht_clmn_line_combos.csv -o -y"; 36 x "st &prov._&type4._wksht_clmn_line_combos.sas7bdat &prov._&type4._wksht_clmn_line_combos.dta -o -y"; 37 *x "echo 'combo done' | mail jroth"; 38 %mend loop; 39 *%loop(provider=hha,type=alpha,type4=alph,type1=a); 40 *%loop(provider=hha,type=nmrc,type4=nmrc,type1=n); 41 *%loop(provider=hosp,form=2552_10,type=alpha,type4=alph,type1=a); 42 *%loop(provider=hosp,form=2552_10,type=nmrc,type4=nmrc,type1=n); 43 %loop(provider=fqhc,form=224_14,type=alpha,type4=alph,type1=a); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value fqhc MLOGIC(LOOP): Parameter FORM has value 224_14 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 fqhc 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/224-14 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 2015; stop value is 2018; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to fqhc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable DS resolves to fqhc_alpha224_14_2015_long SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.fqhc_alpha224_14_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 fqhc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2016 3 The SAS System 18:09 Monday, April 15, 2019 NOTE: There were 407697 observations read from the data set IN.FQHC_ALPHA224_14_2015_LONG. NOTE: 404527 observations with duplicate key values were deleted. NOTE: The data set WORK._2015A has 3170 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.10 seconds cpu time 0.18 seconds SYMBOLGEN: Macro variable DS resolves to fqhc_alpha224_14_2016_long SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.fqhc_alpha224_14_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 fqhc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2017 NOTE: There were 449394 observations read from the data set IN.FQHC_ALPHA224_14_2016_LONG. NOTE: 445879 observations with duplicate key values were deleted. NOTE: The data set WORK._2016A has 3515 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.10 seconds cpu time 0.22 seconds SYMBOLGEN: Macro variable DS resolves to fqhc_alpha224_14_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.fqhc_alpha224_14_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 fqhc SYMBOLGEN: Macro variable TYPE resolves to alpha SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 267000 observations read from the data set IN.FQHC_ALPHA224_14_2017_LONG. NOTE: 264127 observations with duplicate key values were deleted. NOTE: The data set WORK._2017A has 2873 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.06 seconds cpu time 0.11 seconds SYMBOLGEN: Macro variable DS resolves to fqhc_alpha224_14_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to a MPRINT(LOOP): proc sort data=in.fqhc_alpha224_14_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 fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph 4 The SAS System 18:09 Monday, April 15, 2019 NOTE: There were 2819 observations read from the data set IN.FQHC_ALPHA224_14_2018_LONG. NOTE: 2451 observations with duplicate key values were deleted. NOTE: The data set WORK._2018A has 368 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.fqh_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 MPRINT(LOOP): set _2015a _2016a _2017a _2018a ; NOTE: There were 3170 observations read from the data set WORK._2015A. NOTE: There were 3515 observations read from the data set WORK._2016A. NOTE: There were 2873 observations read from the data set WORK._2017A. NOTE: There were 368 observations read from the data set WORK._2018A. NOTE: The data set OUT.FQH_ALPH_WKSHT_CLMN_LINE_COMBOS has 9926 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc sort data=out.fqh_alph_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph NOTE: There were 9926 observations read from the data set OUT.FQH_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: 6046 observations with duplicate key values were deleted. NOTE: The data set OUT.FQH_ALPH_WKSHT_CLMN_LINE_COMBOS has 3880 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.fqh_alph_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): set out.fqh_alph_wksht_clmn_line_combos; NOTE: There were 3880 observations read from the data set OUT.FQH_ALPH_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.FQH_ALPH_WKSHT_CLMN_LINE_COMBOS has 3880 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): proc contents data=out.fqh_alph_wksht_clmn_line_combos; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROV resolves to fqh 5 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st fqh_alph_wksht_clmn_line_combos.sas7bdat fqh_alph_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to alph MPRINT(LOOP): x "st fqh_alph_wksht_clmn_line_combos.sas7bdat fqh_alph_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; MLOGIC(LOOP): Ending execution. 44 %loop(provider=fqhc,form=224_14,type=nmrc,type4=nmrc,type1=n); MLOGIC(LOOP): Beginning execution. MLOGIC(LOOP): Parameter PROVIDER has value fqhc MLOGIC(LOOP): Parameter FORM has value 224_14 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 fqhc 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/224-14 MLOGIC(LOOP): %DO loop beginning; index variable YEAR; start value is 2015; stop value is 2018; by value is 1. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to fqhc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2015 NOTE: The PROCEDURE CONTENTS printed page 1. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.30 seconds cpu time 0.04 seconds SYMBOLGEN: Macro variable DS resolves to fqhc_nmrc224_14_2015_long SYMBOLGEN: Macro variable YEAR resolves to 2015 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.fqhc_nmrc224_14_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 fqhc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2016 NOTE: There were 555411 observations read from the data set IN.FQHC_NMRC224_14_2015_LONG. NOTE: 551713 observations with duplicate key values were deleted. NOTE: The data set WORK._2015N has 3698 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.25 seconds 6 The SAS System 18:09 Monday, April 15, 2019 SYMBOLGEN: Macro variable DS resolves to fqhc_nmrc224_14_2016_long SYMBOLGEN: Macro variable YEAR resolves to 2016 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.fqhc_nmrc224_14_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 fqhc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2017 NOTE: There were 615332 observations read from the data set IN.FQHC_NMRC224_14_2016_LONG. NOTE: 611685 observations with duplicate key values were deleted. NOTE: The data set WORK._2016N has 3647 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.14 seconds cpu time 0.24 seconds SYMBOLGEN: Macro variable DS resolves to fqhc_nmrc224_14_2017_long SYMBOLGEN: Macro variable YEAR resolves to 2017 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.fqhc_nmrc224_14_2017_long out=_2017n (keep=wksht_cd clmn_num line_num) nodupkey; MPRINT(LOOP): by wksht_cd clmn_num line_num; MLOGIC(LOOP): %DO loop index variable YEAR is now 2018; loop will iterate again. MLOGIC(LOOP): %LET (variable name is DS) SYMBOLGEN: Macro variable PROVIDER resolves to fqhc SYMBOLGEN: Macro variable TYPE resolves to nmrc SYMBOLGEN: Macro variable FORM resolves to 224_14 SYMBOLGEN: Macro variable YEAR resolves to 2018 NOTE: There were 362466 observations read from the data set IN.FQHC_NMRC224_14_2017_LONG. NOTE: 359486 observations with duplicate key values were deleted. NOTE: The data set WORK._2017N has 2980 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.08 seconds cpu time 0.15 seconds SYMBOLGEN: Macro variable DS resolves to fqhc_nmrc224_14_2018_long SYMBOLGEN: Macro variable YEAR resolves to 2018 SYMBOLGEN: Macro variable TYPE1 resolves to n MPRINT(LOOP): proc sort data=in.fqhc_nmrc224_14_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 fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 3830 observations read from the data set IN.FQHC_NMRC224_14_2018_LONG. NOTE: 3033 observations with duplicate key values were deleted. NOTE: The data set WORK._2018N has 797 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 7 The SAS System 18:09 Monday, April 15, 2019 MPRINT(LOOP): data out.fqh_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 MPRINT(LOOP): set _2015n _2016n _2017n _2018n ; NOTE: There were 3698 observations read from the data set WORK._2015N. NOTE: There were 3647 observations read from the data set WORK._2016N. NOTE: There were 2980 observations read from the data set WORK._2017N. NOTE: There were 797 observations read from the data set WORK._2018N. NOTE: The data set OUT.FQH_NMRC_WKSHT_CLMN_LINE_COMBOS has 11122 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc sort data=out.fqh_nmrc_wksht_clmn_line_combos nodupkey; MPRINT(LOOP): by wksht_cd line_num clmn_num ; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc NOTE: There were 11122 observations read from the data set OUT.FQH_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: 6832 observations with duplicate key values were deleted. NOTE: The data set OUT.FQH_NMRC_WKSHT_CLMN_LINE_COMBOS has 4290 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.fqh_nmrc_wksht_clmn_line_combos; MPRINT(LOOP): retain wksht_cd line_num clmn_num; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): set out.fqh_nmrc_wksht_clmn_line_combos; NOTE: There were 4290 observations read from the data set OUT.FQH_NMRC_WKSHT_CLMN_LINE_COMBOS. NOTE: The data set OUT.FQH_NMRC_WKSHT_CLMN_LINE_COMBOS has 4290 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): proc contents data=out.fqh_nmrc_wksht_clmn_line_combos; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st fqh_nmrc_wksht_clmn_line_combos.sas7bdat fqh_nmrc_wksht_clmn_line_combos.csv -o -y"; SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc SYMBOLGEN: Macro variable PROV resolves to fqh SYMBOLGEN: Macro variable TYPE4 resolves to nmrc MPRINT(LOOP): x "st fqh_nmrc_wksht_clmn_line_combos.sas7bdat fqh_nmrc_wksht_clmn_line_combos.dta -o -y"; MPRINT(LOOP): *x "echo 'combo done' | mail jroth"; 8 The SAS System 18:09 Monday, April 15, 2019 MLOGIC(LOOP): Ending execution. 45 *%loop(provider=snf,form=2540_10,type=alpha,type4=alph,type1=a); 46 *%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.25 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.44 seconds cpu time 1.27 seconds