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.05 seconds cpu time 0.03 seconds 1 options nocenter; 2 ** To use all available memory, run using ; 3 ** sas -memsize 0m -maxmemquery 0m transpose_nmrc.sas ; 4 *options obs=6; 5 *libname library "~/bulk/cost-reports/hosp/"; 6 libname library "/homes/data/hcris/2552-96"; NOTE: Libref LIBRARY was successfully assigned as follows: Engine: V9 Physical Name: /homes/data/hcris/2552-96 7 options user=library; ** re-assign where WORK. datasets go ; 8 %let t_0 = %sysfunc (datetime()); 9 10 * by Jean Roth, 2003-12-19 ; 11 * Please report any problems or errors to jroth@nber.org 12 * NOTE: This program is distributed under the GNU GPL. 13 * See http://www.gnu.org/licenses/ for details. ; 14 * Copyright 2004 shared by the National Bureau of Economic Research and Jean Roth ; 15 16 %let user=; 17 %macro loop(fyear=,lyear=); 18 %do year=&fyear. %to &lyear.; 2 The SAS System 18:27 Monday, April 15, 2019 19 20 proc sort data=library.nmrc&year.&user. out=WORK.nmrc&year.; 21 by rpt_rec_num; 22 23 *proc print data=WORK.nmrc&year. (obs=6); 24 25 proc transpose data=WORK.nmrc&year. out=library.nmrc&year.&user.t (drop = _NAME_); 26 by rpt_rec_num; 27 var itm_val_num; 28 id varname; 29 run; 30 31 %let t_1 = %sysfunc (datetime()); 32 %let elapsed = %sysevalf(%sysevalf (&t_1 - &t_0)/60); 33 title3 "Elapsed time: &elapsed. minutes"; 34 *proc print data=library.nmrc&year.&user.t (obs=6); 35 run; 36 37 %end; 38 %mend; 39 %loop(fyear=1995,lyear=2011); NOTE: Data file LIBRARY.NMRC1995.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 489 observations read from the data set LIBRARY.NMRC1995. NOTE: The data set WORK.NMRC1995 has 489 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds NOTE: Data file LIBRARY.NMRC1995T.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: 312 observations omitted due to missing ID values. NOTE: There were 489 observations read from the data set WORK.NMRC1995. NOTE: The data set LIBRARY.NMRC1995T has 2 observations and 110 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.04 seconds cpu time 0.03 seconds NOTE: Data file LIBRARY.NMRC1996.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 1739841 observations read from the data set LIBRARY.NMRC1996. NOTE: The data set WORK.NMRC1996 has 1739841 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.71 seconds cpu time 0.92 seconds NOTE: Data file LIBRARY.NMRC1996T.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: 1144466 observations omitted due to missing ID values. 3 The SAS System 18:27 Monday, April 15, 2019 NOTE: There were 1739841 observations read from the data set WORK.NMRC1996. NOTE: The data set LIBRARY.NMRC1996T has 6033 observations and 1652 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.76 seconds cpu time 1.43 seconds NOTE: Data file LIBRARY.NMRC1997.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 1847093 observations read from the data set LIBRARY.NMRC1997. NOTE: The data set WORK.NMRC1997 has 1847093 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.75 seconds cpu time 0.95 seconds NOTE: Data file LIBRARY.NMRC1997T.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: 1218722 observations omitted due to missing ID values. NOTE: There were 1847093 observations read from the data set WORK.NMRC1997. NOTE: The data set LIBRARY.NMRC1997T has 6333 observations and 1745 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.83 seconds cpu time 1.47 seconds NOTE: Data file LIBRARY.NMRC1998.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 1851136 observations read from the data set LIBRARY.NMRC1998. NOTE: The data set WORK.NMRC1998 has 1851136 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.94 seconds cpu time 1.04 seconds NOTE: Data file LIBRARY.NMRC1998T.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: 1218653 observations omitted due to missing ID values. NOTE: There were 1851136 observations read from the data set WORK.NMRC1998. NOTE: The data set LIBRARY.NMRC1998T has 6287 observations and 1721 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 2.14 seconds cpu time 1.47 seconds NOTE: Data file LIBRARY.NMRC1999.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 1824420 observations read from the data set LIBRARY.NMRC1999. NOTE: The data set WORK.NMRC1999 has 1824420 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.82 seconds 4 The SAS System 18:27 Monday, April 15, 2019 cpu time 0.99 seconds NOTE: Data file LIBRARY.NMRC1999T.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: 1199370 observations omitted due to missing ID values. NOTE: There were 1824420 observations read from the data set WORK.NMRC1999. NOTE: The data set LIBRARY.NMRC1999T has 6172 observations and 1764 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.81 seconds cpu time 1.47 seconds NOTE: Data file LIBRARY.NMRC2000.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 1839718 observations read from the data set LIBRARY.NMRC2000. NOTE: The data set WORK.NMRC2000 has 1839718 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.55 seconds cpu time 1.30 seconds NOTE: Data file LIBRARY.NMRC2000T.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: 1222920 observations omitted due to missing ID values. NOTE: There were 1839718 observations read from the data set WORK.NMRC2000. NOTE: The data set LIBRARY.NMRC2000T has 6180 observations and 1729 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.75 seconds cpu time 1.44 seconds NOTE: Data file LIBRARY.NMRC2001.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 1821896 observations read from the data set LIBRARY.NMRC2001. NOTE: The data set WORK.NMRC2001 has 1821896 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.71 seconds cpu time 0.95 seconds NOTE: Data file LIBRARY.NMRC2001T.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: 1213104 observations omitted due to missing ID values. NOTE: There were 1821896 observations read from the data set WORK.NMRC2001. NOTE: The data set LIBRARY.NMRC2001T has 6170 observations and 1731 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.74 seconds cpu time 1.41 seconds 5 The SAS System 18:27 Monday, April 15, 2019 NOTE: Data file LIBRARY.NMRC2002.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 1826449 observations read from the data set LIBRARY.NMRC2002. NOTE: The data set WORK.NMRC2002 has 1826449 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.74 seconds cpu time 0.96 seconds NOTE: Data file LIBRARY.NMRC2002T.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: 1216587 observations omitted due to missing ID values. NOTE: There were 1826449 observations read from the data set WORK.NMRC2002. NOTE: The data set LIBRARY.NMRC2002T has 6198 observations and 1757 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.82 seconds cpu time 1.47 seconds NOTE: Data file LIBRARY.NMRC2003.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 1811104 observations read from the data set LIBRARY.NMRC2003. NOTE: The data set WORK.NMRC2003 has 1811104 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.73 seconds cpu time 0.97 seconds NOTE: Data file LIBRARY.NMRC2003T.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: 1204469 observations omitted due to missing ID values. NOTE: There were 1811104 observations read from the data set WORK.NMRC2003. NOTE: The data set LIBRARY.NMRC2003T has 6193 observations and 1719 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.77 seconds cpu time 1.44 seconds NOTE: Data file LIBRARY.NMRC2004.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 1810358 observations read from the data set LIBRARY.NMRC2004. NOTE: The data set WORK.NMRC2004 has 1810358 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 1.28 seconds cpu time 1.02 seconds NOTE: Data file LIBRARY.NMRC2004T.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. 6 The SAS System 18:27 Monday, April 15, 2019 WARNING: 1199757 observations omitted due to missing ID values. NOTE: There were 1810358 observations read from the data set WORK.NMRC2004. NOTE: The data set LIBRARY.NMRC2004T has 6265 observations and 1680 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.73 seconds cpu time 1.42 seconds NOTE: Data file LIBRARY.NMRC2005.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 1815397 observations read from the data set LIBRARY.NMRC2005. NOTE: The data set WORK.NMRC2005 has 1815397 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.69 seconds cpu time 0.97 seconds NOTE: Data file LIBRARY.NMRC2005T.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: 1206995 observations omitted due to missing ID values. NOTE: There were 1815397 observations read from the data set WORK.NMRC2005. NOTE: The data set LIBRARY.NMRC2005T has 6248 observations and 1668 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 2.15 seconds cpu time 1.39 seconds NOTE: Data file LIBRARY.NMRC2006.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 1807657 observations read from the data set LIBRARY.NMRC2006. NOTE: The data set WORK.NMRC2006 has 1807657 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.74 seconds cpu time 1.04 seconds NOTE: Data file LIBRARY.NMRC2006T.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: 1202074 observations omitted due to missing ID values. NOTE: There were 1807657 observations read from the data set WORK.NMRC2006. NOTE: The data set LIBRARY.NMRC2006T has 6233 observations and 1671 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.71 seconds cpu time 1.40 seconds NOTE: Data file LIBRARY.NMRC2007.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 1793798 observations read from the data set LIBRARY.NMRC2007. NOTE: The data set WORK.NMRC2007 has 1793798 observations and 6 variables. 7 The SAS System 18:27 Monday, April 15, 2019 NOTE: PROCEDURE SORT used (Total process time): real time 0.70 seconds cpu time 0.97 seconds NOTE: Data file LIBRARY.NMRC2007T.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: 1193091 observations omitted due to missing ID values. NOTE: There were 1793798 observations read from the data set WORK.NMRC2007. NOTE: The data set LIBRARY.NMRC2007T has 6180 observations and 1692 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.71 seconds cpu time 1.38 seconds NOTE: Data file LIBRARY.NMRC2008.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 1804405 observations read from the data set LIBRARY.NMRC2008. NOTE: The data set WORK.NMRC2008 has 1804405 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.67 seconds cpu time 0.95 seconds NOTE: Data file LIBRARY.NMRC2008T.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: 1197039 observations omitted due to missing ID values. NOTE: There were 1804405 observations read from the data set WORK.NMRC2008. NOTE: The data set LIBRARY.NMRC2008T has 6208 observations and 1693 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.76 seconds cpu time 1.45 seconds NOTE: Data file LIBRARY.NMRC2009.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 1797967 observations read from the data set LIBRARY.NMRC2009. NOTE: The data set WORK.NMRC2009 has 1797967 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.67 seconds cpu time 0.93 seconds NOTE: Data file LIBRARY.NMRC2009T.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: 1192932 observations omitted due to missing ID values. NOTE: There were 1797967 observations read from the data set WORK.NMRC2009. NOTE: The data set LIBRARY.NMRC2009T has 6202 observations and 1722 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.86 seconds 8 The SAS System 18:27 Monday, April 15, 2019 cpu time 1.45 seconds NOTE: Data file LIBRARY.NMRC2010.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 1114193 observations read from the data set LIBRARY.NMRC2010. NOTE: The data set WORK.NMRC2010 has 1114193 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.42 seconds cpu time 0.57 seconds NOTE: Data file LIBRARY.NMRC2010T.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: 736817 observations omitted due to missing ID values. NOTE: There were 1114193 observations read from the data set WORK.NMRC2010. NOTE: The data set LIBRARY.NMRC2010T has 3851 observations and 1478 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.07 seconds cpu time 0.90 seconds NOTE: Data file LIBRARY.NMRC2011.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 6537 observations read from the data set LIBRARY.NMRC2011. NOTE: The data set WORK.NMRC2011 has 6537 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.04 seconds NOTE: Data file LIBRARY.NMRC2011T.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: 4120 observations omitted due to missing ID values. NOTE: There were 6537 observations read from the data set WORK.NMRC2011. NOTE: The data set LIBRARY.NMRC2011T has 34 observations and 302 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.08 seconds cpu time 0.02 seconds 40 *%loop(fyear=1996,lyear=2011); 41 *%loop(fyear=1995,lyear=2004); 42 *%loop(fyear=1996,lyear=2010); 43 *%loop(fyear=1995,lyear=1999); 44 *%loop(fyear=2000,lyear=2003); 45 *%loop(fyear=2004,lyear=2007); 46 *%loop(fyear=2008,lyear=2011); 47 *%loop(fyear=2010,lyear=2011); 48 *%loop(fyear=2000,lyear=2003); 49 *%loop(fyear=1997,lyear=1997); 50 *%loop(fyear=1995,lyear=1995); 9 The SAS System 18:27 Monday, April 15, 2019 51 *%loop(fyear=1996,lyear=1996); 52 *%loop(fyear=1998,lyear=1998); 53 *%loop(fyear=1999,lyear=1999); 54 *%loop(fyear=2000,lyear=2000); 55 *%loop(fyear=2001,lyear=2001); 56 *%loop(fyear=2002,lyear=2002); 57 *%loop(fyear=2003,lyear=2003); 58 *%loop(fyear=2004,lyear=2004); 59 *%loop(fyear=2005,lyear=2005); 60 *%loop(fyear=2006,lyear=2006); 61 *%loop(fyear=2007,lyear=2007); 62 *%loop(fyear=2008,lyear=2008); 63 *%loop(fyear=2009,lyear=2009); 64 *%loop(fyear=2010,lyear=2010); 65 *%loop(fyear=2011,lyear=2011); 66 *%loop(fyear=1996,lyear=2004); 67 *%loop(fyear=2005,lyear=2011); 68 *%loop(fyear=1996,lyear=2011); NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 39.19 seconds cpu time 35.69 seconds