1 The SAS System 15:26 Wednesday, February 28, 2018 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M4) Licensed to . NOTE: This session is executing on the Linux 2.6.32-696.18.7.el6.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.2 SAS/ETS 14.2 SAS/OR 14.2 SAS/IML 14.2 NOTE: Additional host information: Linux LIN X64 2.6.32-696.18.7.el6.x86_64 #1 SMP Thu Dec 28 20:15:47 EST 2017 x86_64 Red Hat Enterprise Linux Server release 6.9 (Santiago) 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 MLOGIC(COMPTAB): Beginning execution. MPRINT(COMPTAB): libname test "/sasdata/seats/oct/test"; NOTE: Libref TEST was successfully assigned as follows: Engine: V9 Physical Name: /sasdata/seats/oct/test MPRINT(COMPTAB): libname prod "/sasdata/seats/oct/prod"; NOTE: Libref PROD was successfully assigned as follows: Engine: V9 Physical Name: /sasdata/seats/oct/prod MPRINT(COMPTAB): libname testspc '/sasdata/special'; NOTE: Libref TESTSPC was successfully assigned as follows: Engine: V9 Physical Name: /sasdata/special MPRINT(COMPTAB): data combine; MPRINT(COMPTAB): length naicstab $10; MPRINT(COMPTAB): merge prod.t_n_sa_concurrent_f (in=a rename=(_07_2017=mon1 _08_2017=mon2 _09_2017=mon3 _10_2017=mon4)) test.t_n_sa_concurrent_f (in=b rename=(_07_2017=mon5 _08_2017=mon6 _09_2017=mon7 _10_2017=mon8)); MPRINT(COMPTAB): by naicstab14 closing nsacell esttype; MPRINT(COMPTAB): if closing='P'; MPRINT(COMPTAB): naicstab=substr(naicstab14,1,10); MPRINT(COMPTAB): datatype=substr(naicstab14,12,2); MPRINT(COMPTAB): otm1=mon2 - mon1; MPRINT(COMPTAB): otm2=mon3 - mon2; MPRINT(COMPTAB): otm3=mon4 - mon3; MPRINT(COMPTAB): otm4=mon6 - mon5; MPRINT(COMPTAB): otm5=mon7 - mon6; MPRINT(COMPTAB): otm6=mon8 - mon7; MPRINT(COMPTAB): diff1=otm4 - otm1; MPRINT(COMPTAB): diff2=otm5 - otm2; MPRINT(COMPTAB): diff3=otm6 - otm3; MPRINT(COMPTAB): if datatype in ('01','02','06','07','10') then do; MPRINT(COMPTAB): diff1=round(diff1,.1); MPRINT(COMPTAB): diff2=round(diff2,.1); MPRINT(COMPTAB): diff3=round(diff3,.1); MPRINT(COMPTAB): end; MPRINT(COMPTAB): if datatype in ('03','08') then do; MPRINT(COMPTAB): diff1=round(diff1,.01); MPRINT(COMPTAB): diff2=round(diff2,.01); MPRINT(COMPTAB): diff3=round(diff3,.01); MPRINT(COMPTAB): end; MPRINT(COMPTAB): run; NOTE: There were 882 observations read from the data set PROD.T_N_SA_CONCURRENT_F. NOTE: There were 882 observations read from the data set TEST.T_N_SA_CONCURRENT_F. NOTE: The data set WORK.COMBINE has 441 observations and 23 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(COMPTAB): data titles (keep=naicstab tabtitle); MPRINT(COMPTAB): set testspc.naicstabcode; MPRINT(COMPTAB): if nsacell not in ('N',' ') and nsapub ne ' '; MPRINT(COMPTAB): run; 6 The SAS System 15:26 Wednesday, February 28, 2018 NOTE: There were 5332 observations read from the data set TESTSPC.NAICSTABCODE. NOTE: The data set WORK.TITLES has 916 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(COMPTAB): proc sort data=titles; MPRINT(COMPTAB): by naicstab; MPRINT(COMPTAB): run; NOTE: There were 916 observations read from the data set WORK.TITLES. NOTE: The data set WORK.TITLES has 916 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(COMPTAB): data combined; MPRINT(COMPTAB): merge combine (in=a) titles (in=b); MPRINT(COMPTAB): by naicstab; MPRINT(COMPTAB): if a and b; MPRINT(COMPTAB): run; NOTE: There were 441 observations read from the data set WORK.COMBINE. NOTE: There were 916 observations read from the data set WORK.TITLES. NOTE: The data set WORK.COMBINED has 441 observations and 24 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(COMPTAB): proc sort data=combined; MPRINT(COMPTAB): by datatype naicstab; MPRINT(COMPTAB): run; NOTE: There were 441 observations read from the data set WORK.COMBINED. NOTE: The data set WORK.COMBINED has 441 observations and 24 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(COMPTAB): proc format; MPRINT(COMPTAB): value $dtype '01' = 'All employees' '02' = 'Average weekly hours for all employees' '03' = 'Average hourly earnings for all employees' '04' = 'Average weekly overtime hours for all employees' '06' = 'Production employees' '07' = 'Average weekly hours for production employees' '08' = 'Average hourly earnings for production employees' '09' = 'Average weekly overtime hours for production employees' '10' = 'Women employees'; NOTE: Format $DTYPE has been output. MPRINT(COMPTAB): run; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds MPRINT(COMPTAB): options nodate nonumber orientation=landscape nobyline missing='-' leftmargin=.1 rightmargin=.1 ; The SAS System MPRINT(COMPTAB): ods escapechar='^'; MPRINT(COMPTAB): ods listing close; MPRINT(COMPTAB): ods html close; MPRINT(COMPTAB): ods pdf file="/reports/sa_compare_x11_seats_oct.pdf" notoc; ERROR: . MLOGIC(COMPTAB): %PUT syserr before PROC REPORT: &SYSERR. syserr before PROC REPORT: 0 MPRINT(COMPTAB): PROC REPORT DATA = combined nowd style(column)={font_size=1} style(report)={font_size=1 cellpadding=3 cellspacing=3 borderwidth=0} style(header)={font_size=1 cellpadding=3 cellspacing=3 background=#CCCCCC} ; MPRINT(COMPTAB): COLUMNS NAICSTAB TABTITLE ('X11' mon1 mon2 mon3 mon4) ('SEATS' mon5 mon6 mon7 mon8) ('OTM X11' otm1 otm2 otm3) ('OTM SEATS' otm4 otm5 otm6) ('OTM Difference' diff1 diff2 diff3) pct1 pct2 pct3; MPRINT(COMPTAB): DEFINE diff1 / DISPLAY missing; MPRINT(COMPTAB): DEFINE diff2 / DISPLAY missing; MPRINT(COMPTAB): DEFINE diff3 / DISPLAY missing; MPRINT(COMPTAB): DEFINE otm1 / DISPLAY missing; MPRINT(COMPTAB): DEFINE otm2 / DISPLAY missing; MPRINT(COMPTAB): DEFINE otm3 / DISPLAY missing; MPRINT(COMPTAB): DEFINE pct1 / NOPRINT COMPUTED missing; MPRINT(COMPTAB): DEFINE pct2 / NOPRINT COMPUTED missing; MPRINT(COMPTAB): DEFINE pct3 / NOPRINT COMPUTED missing; MPRINT(COMPTAB): BY DATATYPE; MPRINT(COMPTAB): COMPUTE NAICSTAB; MPRINT(COMPTAB): COUNT+1; MPRINT(COMPTAB): IF (MOD(COUNT, 2)) THEN DO; MPRINT(COMPTAB): CALL DEFINE(_ROW_,'STYLE','style=[background=#E6E6E6]'); MPRINT(COMPTAB): END; MPRINT(COMPTAB): ENDCOMP; MPRINT(COMPTAB): COMPUTE pct1; MPRINT(COMPTAB): if (missing(otm1) or otm1 = 0) then do; MPRINT(COMPTAB): pct1 = .; MPRINT(COMPTAB): end; MPRINT(COMPTAB): else do; MPRINT(COMPTAB): pct1=diff1/otm1; MPRINT(COMPTAB): end; MPRINT(COMPTAB): IF pct1 > .5 then do; MPRINT(COMPTAB): CALL DEFINE("diff1","style","STYLE=[BACKGROUND=LIGHTRED]"); MPRINT(COMPTAB): END; MPRINT(COMPTAB): ENDCOMP; MPRINT(COMPTAB): COMPUTE pct2; MPRINT(COMPTAB): if (missing(otm2) or otm2 = 0) then do; MPRINT(COMPTAB): pct2 = .; MPRINT(COMPTAB): end; MPRINT(COMPTAB): else do; MPRINT(COMPTAB): pct2=diff2/otm2; MPRINT(COMPTAB): end; MPRINT(COMPTAB): IF pct2 > .5 then do; MPRINT(COMPTAB): CALL DEFINE("diff2","style","STYLE=[BACKGROUND=LIGHTRED]"); MPRINT(COMPTAB): END; MPRINT(COMPTAB): ENDCOMP; MPRINT(COMPTAB): COMPUTE pct3; MPRINT(COMPTAB): if (missing(otm3) or otm3 = 0) then do; MPRINT(COMPTAB): pct3 = .; MPRINT(COMPTAB): end; MPRINT(COMPTAB): else do; MPRINT(COMPTAB): pct3=diff3/otm3; MPRINT(COMPTAB): end; MPRINT(COMPTAB): IF pct3 > .5 then do; MPRINT(COMPTAB): CALL DEFINE("diff3","style","STYLE=[BACKGROUND=LIGHTRED]"); The SAS System MPRINT(COMPTAB): END; MPRINT(COMPTAB): ENDCOMP; MPRINT(COMPTAB): FORMAT DATATYPE $DTYPE. DIFF1-DIFF3 BEST12.; MPRINT(COMPTAB): LABEL naicstab= 'Tabcode' mon1= "July 2017" mon2= "August 2017" mon3= "September 2017" mon4= "October 2017" mon5= "July 2017" mon6= "August 2017" mon7= "September 2017" mon8= "October 2017" otm1= "August 2017" otm2= "September 2017" otm3= "October 2017" otm4= "August 2017" otm5= "September 2017" otm6= "October 2017" diff1= "August 2017" diff2= "September 2017" diff3= "October 2017"; MPRINT(COMPTAB): TITLE1 BOLD FONT='TIMES NEW ROMAN' "Seasonal Adjustment Comparison X11 vs SEATS Method"; MPRINT(COMPTAB): TITLE3 FONT='TIMES NEW ROMAN' "#BYVAL(DATATYPE)"; MPRINT(COMPTAB): FOOTNOTE1 FONT='TIMES NEW ROMAN' COLOR='DARKRED' "Differences greater than 50% are highlighted"; MPRINT(COMPTAB): FOOTNOTE3 FONT='TIMES NEW ROMAN' HEIGHT=1 JUSTIFY=CENTER "-^{thispage}-"; MPRINT(COMPTAB): RUN; NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set. NOTE: PROCEDURE REPORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(COMPTAB): %PUT syserr after PROC REPORT: &SYSERR. syserr after PROC REPORT: 2000 MPRINT(COMPTAB): ods pdf close; MPRINT(COMPTAB): ods listing; MLOGIC(COMPTAB): Ending execution. ERROR: Errors printed on page 7. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 0.19 seconds cpu time 0.15 seconds