1 The SAS System 18:27 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.16 seconds cpu time 0.05 seconds 1 options nocenter; 2 *options obs=6; 3 *libname library "~/bulk/cost-reports/hosp/"; 4 libname library "/homes/data/hcris/2552-96"; NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V9 Physical Name: /homes/data/hcris/2552-96 5 6 * by Jean Roth, 2003-12-19 ; 7 * Please report any problems or errors to jroth@nber.org 8 * NOTE: This program is distributed under the GNU GPL. 9 * See http://www.gnu.org/licenses/ for details. ; 10 * Copyright 2004 shared by the National Bureau of Economic Research and Jean Roth ; 11 12 %let user=; 13 %macro loop(fyear=,lyear=); 14 %do year=&fyear. %to &lyear.; 15 16 proc sort data=library.alpha&year.&user. out=xx; 17 by rpt_rec_num; 18 2 The SAS System 18:27 Monday, April 15, 2019 19 proc print data=xx (obs=6); 20 21 proc transpose data=xx out=library.alpha&year.&user.t (drop = _NAME_); 22 by rpt_rec_num; 23 var alphnmrc_itm_txt; 24 id varname; 25 run; 26 27 proc print data=library.alpha&year.&user.t (obs=6); 28 run; 29 30 %end; 31 %mend; 32 %loop(fyear=1995,lyear=2011); NOTE: Data file LIBRARY.ALPHA1995.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 118 observations read from the data set LIBRARY.ALPHA1995. NOTE: The data set WORK.XX has 118 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.02 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.07 seconds cpu time 0.04 seconds NOTE: Data file LIBRARY.ALPHA1995T.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. WARNING: 101 observations omitted due to missing ID values. NOTE: There were 118 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA1995T has 2 observations and 10 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.12 seconds cpu time 0.03 seconds NOTE: Data file LIBRARY.ALPHA1995T.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 2 observations read from the data set LIBRARY.ALPHA1995T. NOTE: The PROCEDURE PRINT printed page 2. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA1996.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 536785 observations read from the data set LIBRARY.ALPHA1996. 3 The SAS System 18:27 Monday, April 15, 2019 NOTE: The data set WORK.XX has 536785 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.34 seconds cpu time 0.39 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 3. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA1996T.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. WARNING: 481563 observations omitted due to missing ID values. NOTE: There were 536785 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA1996T has 6016 observations and 23 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.37 seconds cpu time 0.18 seconds NOTE: Data file LIBRARY.ALPHA1996T.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 6 observations read from the data set LIBRARY.ALPHA1996T. NOTE: The PROCEDURE PRINT printed page 4. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: Data file LIBRARY.ALPHA1997.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 589004 observations read from the data set LIBRARY.ALPHA1997. NOTE: The data set WORK.XX has 589004 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.51 seconds cpu time 0.45 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 5. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA1997T.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. WARNING: 529105 observations omitted due to missing ID values. 4 The SAS System 18:27 Monday, April 15, 2019 NOTE: There were 589004 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA1997T has 6309 observations and 28 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.26 seconds cpu time 0.21 seconds NOTE: Data file LIBRARY.ALPHA1997T.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 6 observations read from the data set LIBRARY.ALPHA1997T. NOTE: The PROCEDURE PRINT printed page 6. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA1998.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 610913 observations read from the data set LIBRARY.ALPHA1998. NOTE: The data set WORK.XX has 610913 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.43 seconds cpu time 0.45 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 7. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA1998T.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. WARNING: 550191 observations omitted due to missing ID values. NOTE: There were 610913 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA1998T has 6228 observations and 27 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.22 seconds cpu time 0.17 seconds NOTE: Data file LIBRARY.ALPHA1998T.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 6 observations read from the data set LIBRARY.ALPHA1998T. NOTE: The PROCEDURE PRINT printed page 8. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 5 The SAS System 18:27 Monday, April 15, 2019 NOTE: Data file LIBRARY.ALPHA1999.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 633495 observations read from the data set LIBRARY.ALPHA1999. NOTE: The data set WORK.XX has 633495 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.49 seconds cpu time 0.51 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 9. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA1999T.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. WARNING: 571960 observations omitted due to missing ID values. NOTE: There were 633495 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA1999T has 6107 observations and 27 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.25 seconds cpu time 0.20 seconds NOTE: Data file LIBRARY.ALPHA1999T.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 6 observations read from the data set LIBRARY.ALPHA1999T. NOTE: The PROCEDURE PRINT printed page 10. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: Data file LIBRARY.ALPHA2000.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 679891 observations read from the data set LIBRARY.ALPHA2000. NOTE: The data set WORK.XX has 679891 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.52 seconds cpu time 0.54 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 11. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2000T.DATA is in a format that is native to another host, or the file encoding does not match the 6 The SAS System 18:27 Monday, April 15, 2019 session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. WARNING: 614494 observations omitted due to missing ID values. NOTE: There were 679891 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2000T has 6146 observations and 32 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.29 seconds cpu time 0.23 seconds NOTE: Data file LIBRARY.ALPHA2000T.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 6 observations read from the data set LIBRARY.ALPHA2000T. NOTE: The PROCEDURE PRINT printed page 12. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2001.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 765667 observations read from the data set LIBRARY.ALPHA2001. NOTE: The data set WORK.XX has 765667 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.41 seconds cpu time 0.52 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 13. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2001T.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. WARNING: 694334 observations omitted due to missing ID values. NOTE: There were 765667 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2001T has 6162 observations and 34 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.39 seconds cpu time 0.22 seconds NOTE: Data file LIBRARY.ALPHA2001T.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 6 observations read from the data set LIBRARY.ALPHA2001T. NOTE: The PROCEDURE PRINT printed page 14. NOTE: PROCEDURE PRINT used (Total process time): 7 The SAS System 18:27 Monday, April 15, 2019 real time 0.01 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2002.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 798512 observations read from the data set LIBRARY.ALPHA2002. NOTE: The data set WORK.XX has 798512 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.72 seconds cpu time 0.59 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 15. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2002T.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. WARNING: 724377 observations omitted due to missing ID values. NOTE: There were 798512 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2002T has 6197 observations and 36 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.29 seconds cpu time 0.24 seconds NOTE: Data file LIBRARY.ALPHA2002T.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 6 observations read from the data set LIBRARY.ALPHA2002T. NOTE: The PROCEDURE PRINT printed page 16. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.02 seconds NOTE: Data file LIBRARY.ALPHA2003.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 805356 observations read from the data set LIBRARY.ALPHA2003. NOTE: The data set WORK.XX has 805356 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.65 seconds cpu time 0.61 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 17. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds 8 The SAS System 18:27 Monday, April 15, 2019 cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2003T.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. WARNING: 731620 observations omitted due to missing ID values. NOTE: There were 805356 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2003T has 6193 observations and 34 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.27 seconds cpu time 0.23 seconds NOTE: Data file LIBRARY.ALPHA2003T.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 6 observations read from the data set LIBRARY.ALPHA2003T. NOTE: The PROCEDURE PRINT printed page 18. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: Data file LIBRARY.ALPHA2004.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 821245 observations read from the data set LIBRARY.ALPHA2004. NOTE: The data set WORK.XX has 821245 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.42 seconds cpu time 0.54 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 19. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2004T.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. WARNING: 748603 observations omitted due to missing ID values. NOTE: There were 821245 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2004T has 6265 observations and 32 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.28 seconds cpu time 0.22 seconds NOTE: Data file LIBRARY.ALPHA2004T.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. 9 The SAS System 18:27 Monday, April 15, 2019 NOTE: There were 6 observations read from the data set LIBRARY.ALPHA2004T. NOTE: The PROCEDURE PRINT printed page 20. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2005.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 846715 observations read from the data set LIBRARY.ALPHA2005. NOTE: The data set WORK.XX has 846715 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.46 seconds cpu time 0.58 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 21. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2005T.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. WARNING: 772615 observations omitted due to missing ID values. NOTE: There were 846715 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2005T has 6248 observations and 30 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.26 seconds cpu time 0.23 seconds NOTE: Data file LIBRARY.ALPHA2005T.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 6 observations read from the data set LIBRARY.ALPHA2005T. NOTE: The PROCEDURE PRINT printed page 22. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2006.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 856350 observations read from the data set LIBRARY.ALPHA2006. NOTE: The data set WORK.XX has 856350 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.55 seconds cpu time 0.60 seconds 10 The SAS System 18:27 Monday, April 15, 2019 NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 23. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2006T.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. WARNING: 775535 observations omitted due to missing ID values. NOTE: There were 856350 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2006T has 6233 observations and 32 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.28 seconds cpu time 0.24 seconds NOTE: Data file LIBRARY.ALPHA2006T.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 6 observations read from the data set LIBRARY.ALPHA2006T. NOTE: The PROCEDURE PRINT printed page 24. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2007.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 851980 observations read from the data set LIBRARY.ALPHA2007. NOTE: The data set WORK.XX has 851980 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.44 seconds cpu time 0.53 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 25. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2007T.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. WARNING: 770157 observations omitted due to missing ID values. NOTE: There were 851980 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2007T has 6180 observations and 30 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.29 seconds cpu time 0.24 seconds 11 The SAS System 18:27 Monday, April 15, 2019 NOTE: Data file LIBRARY.ALPHA2007T.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 6 observations read from the data set LIBRARY.ALPHA2007T. NOTE: The PROCEDURE PRINT printed page 26. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2008.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 868106 observations read from the data set LIBRARY.ALPHA2008. NOTE: The data set WORK.XX has 868106 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.59 seconds cpu time 0.69 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 27. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2008T.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. WARNING: 784080 observations omitted due to missing ID values. NOTE: There were 868106 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2008T has 6208 observations and 32 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.80 seconds cpu time 0.26 seconds NOTE: Data file LIBRARY.ALPHA2008T.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 6 observations read from the data set LIBRARY.ALPHA2008T. NOTE: The PROCEDURE PRINT printed page 28. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2009.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 874529 observations read from the data set LIBRARY.ALPHA2009. NOTE: The data set WORK.XX has 874529 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): 12 The SAS System 18:27 Monday, April 15, 2019 real time 0.50 seconds cpu time 0.61 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 29. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2009T.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. WARNING: 789472 observations omitted due to missing ID values. NOTE: There were 874529 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2009T has 6202 observations and 30 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.30 seconds cpu time 0.24 seconds NOTE: Data file LIBRARY.ALPHA2009T.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 6 observations read from the data set LIBRARY.ALPHA2009T. NOTE: The PROCEDURE PRINT printed page 30. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2010.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 547738 observations read from the data set LIBRARY.ALPHA2010. NOTE: The data set WORK.XX has 547738 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.36 seconds cpu time 0.39 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 31. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2010T.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. WARNING: 493238 observations omitted due to missing ID values. NOTE: There were 547738 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2010T has 3851 observations and 31 variables. 13 The SAS System 18:27 Monday, April 15, 2019 NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.19 seconds cpu time 0.16 seconds NOTE: Data file LIBRARY.ALPHA2010T.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 6 observations read from the data set LIBRARY.ALPHA2010T. NOTE: The PROCEDURE PRINT printed page 32. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Data file LIBRARY.ALPHA2011.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 3671 observations read from the data set LIBRARY.ALPHA2011. NOTE: The data set WORK.XX has 3671 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds NOTE: There were 6 observations read from the data set WORK.XX. NOTE: The PROCEDURE PRINT printed page 33. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Data file LIBRARY.ALPHA2011T.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. WARNING: 3219 observations omitted due to missing ID values. NOTE: There were 3671 observations read from the data set WORK.XX. NOTE: The data set LIBRARY.ALPHA2011T has 34 observations and 24 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.05 seconds cpu time 0.02 seconds NOTE: Data file LIBRARY.ALPHA2011T.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 6 observations read from the data set LIBRARY.ALPHA2011T. NOTE: The PROCEDURE PRINT printed page 34. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 33 *%loop(fyear=1997,lyear=1997); 34 *%loop(fyear=1996,lyear=2004); 14 The SAS System 18:27 Monday, April 15, 2019 35 *%loop(fyear=1995,lyear=1995); 36 *%loop(fyear=2005,lyear=2011); NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 13.17 seconds cpu time 11.68 seconds