1 The SAS System 16:47 Tuesday, October 11, 2022 NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead. NOTE: All registry changes will be lost at the end of the session. WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session. NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M7) Licensed to US ENVIRONMENTAL PROTECTION AGENCY, Site 70072220. NOTE: This session is executing on the Linux 3.10.0-1160.76.1.el7.x86_64 (LIN X64) platform. NOTE: Analytical products: SAS/STAT 15.2 NOTE: Additional host information: Linux LIN X64 3.10.0-1160.76.1.el7.x86_64 #1 SMP Tue Jul 26 14:15:37 UTC 2022 x86_64 Red Hat Enterprise Linux Server release 7.9 (Maipo) NOTE: SAS initialization used: real time 0.07 seconds cpu time 0.02 seconds 1 %let base=.; 2 3 libname sasd "&base./sasd"; NOTE: Libref SASD was successfully assigned as follows: Engine: V9 Physical Name: /work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/classI_receptors/2.GDIT_2016/3.FINAL_R6_IMPROVE/sasd 4 5 options nosymbolgen mprint mlogic; 6 7 ********************************************************************; 8 9 %MACRO program; 10 11 /****** 12 GDIT_13sites_for_2nd_IMPROVE_Eqn.R6.csv 13 ------------------------------------------------ 14 IMPROVE Monitor SiteCode,SiteName/Class I Area(s),ST,Lat,Lon,Elev,Start,End,Notes in reference to 2016 Baseline,G100 14 ! Natural Conditions dv,mean_ann_temp_c,ss_rayleigh,fRH_sml (Jan) 14 ! FRHS_1,FRHS_2,FRHS_3,FRHS_4,FRHS_5,FRHS_6,FRHS_7,FRHS_8,FRHS_9,FRHS_10,FRHS_11,FRHS_12,fRH_lrg (Jan) 14 ! FRHL_1,FRHL_2,FRHL_3,FRHL_4,FRHL_5,FRHL_6,FRHL_7,FRHL_8,FRHL_9,FRHL_10,FRHL_11,FRHL_12,fRH_ss (Jan) 14 ! FRHSS_1,FRHSS_2,FRHSS_3,FRHSS_4,FRHSS_5,FRHSS_6,FRHSS_7,FRHSS_8,FRHSS_9,FRHSS_10,FRHSS_11,FRHSS_12 15 BAND1,Bandelier Nat'l 15 ! Monument,NM,35.7797,-106.2664,1988,2-Mar-1988,Present,,3.3690,9.67,9,2.66,2.36,2.1,1.77,1.8,1.55,1.93,2.3,2.21,1.87,2.32, 15 ! 2.6,2.1,1.9,1.72,1.51,1.53,1.38,1.63,1.87,1.8,1.59,1.87,2.04,2.91,2.59,2.22,1.87,1.9,1.67,2.11,2.54,2.37,2,2.49,2.78 16 BIBE1,Big Bend 16 ! NP,TX,29.3027,-103.1780,1067,2-Mar-1988,Present,,4.0168,18.89,10,2.03,1.86,1.63,1.54,1.64,1.65,1.81,2.04,2.16,1.89,1.87,1 16 ! .96,1.67,1.57,1.42,1.37,1.45,1.47,1.56,1.72,1.8,1.61,1.6,1.65,2.13,1.97,1.72,1.64,1.82,1.85,2,2.31,2.43,2.07,2.05,2.15 17 BRIS1,Breton Nat'l Wildlife Refuge,LA,30.1086,-89.7617,-7,16-Jan-2008,Present,replaced 17 ! BRET1,8.6706,19.81,11,4.23,3.98,3.97,3.82,4.02,4.22,4.39,4.45,4.27,4.06,4.11,4.22,2.98,2.85,2.84,2.77,2.88,3,3.1,3.12,3.0 17 ! 2,2.89,2.92,2.98,4.21,4.02,4.01,3.94,4.1,4.3,4.44,4.43,4.29,4.09,4.13,4.22 18 WHIT1,White Mountain 18 ! Wilderness,NM,33.4687,-105.5349,2064,3-Dec-2001,Present,,3.3094,10.52,9,2.55,2.19,1.75,1.59,1.66,1.55,1.93,2.19,2.3,1.87, 18 ! 2.07,2.44,2.01,1.79,1.51,1.4,1.45,1.38,1.64,1.81,1.86,1.59,1.72,1.94,2.72,2.37,1.89,1.69,1.78,1.68,2.14,2.46,2.5,2.03,2.2 2 The SAS System 16:47 Tuesday, October 11, 2022 18 ! 5,2.62 19 WHPE1,Wheeler Peak and Pecos Wilderness Areas,NM,36.5854,-105.4520,3366,16-Aug-2000,Present,2 Class I 19 ! Areas,2.3375,2.63,8,2.72,2.5,2.17,1.97,2.02,1.76,1.98,2.42,2.36,2.01,2.48,2.66,2.14,2,1.78,1.65,1.67,1.52,1.66,1.94,1.89, 19 ! 1.68,1.98,2.1,3,2.76,2.35,2.11,2.15,1.92,2.17,2.63,2.52,2.18,2.71,2.93 20 WIMO1,Wichita Mountains Nat'l Wildlife Refuge and 20 ! Wilderness,OK,34.7323,-98.7130,509,2-Mar-2001,Present,,5.0830,15.21,11,3.17,2.94,2.69,2.68,3.15,2.86,2.49,2.7,3.07,2.87,2 20 ! .97,3.2,2.39,2.25,2.1,2.11,2.39,2.24,2.02,2.13,2.35,2.22,2.28,2.41,3.35,3.12,2.91,2.94,3.4,3.21,2.84,3.01,3.32,3.1,3.2,3. 20 ! 4 21 22 IMPROVE_site_frh_2015.csv 23 ------------------------------------------------ 24 SITE,grid_lat,grid_lon,FRHS_1,FRHS_2,FRHS_3,FRHS_4,FRHS_5,FRHS_6,FRHS_7,FRHS_8,FRHS_9,FRHS_10,FRHS_11,FRHS_12,FRHL_1,FRHL 24 ! _2,FRHL_3,FRHL_4,FRHL_5,FRHL_6,FRHL_7,FRHL_8,FRHL_9,FRHL_10,FRHL_11,FRHL_12,FRHSS_1,FRHSS_2,FRHSS_3,FRHSS_4,FRHSS_5,FRHSS 24 ! _6,FRHSS_7,FRHSS_8,FRHSS_9,FRHSS_10,FRHSS_11,FRHSS_12,frh_1,frh_2,frh_3,frh_4,frh_5,frh_6,frh_7,frh_8,frh_9,frh_10,frh_11 24 ! ,frh_12 25 ACAD1,44.38,-68.37,3.82,3.29,3.31,3.73,3.73,3.82,4.29,4.35,4.59,4.11,4.07,4.21,2.75,2.46,2.45,2.67,2.68,2.73,3,3.04,3.17, 25 ! 2.92,2.9,2.97,3.91,3.49,3.4,3.68,3.72,3.82,4.2,4.27,4.44,4.13,4.11,4.2,3.22,2.81,2.81,3.15,3.18,3.26,3.65,3.71,3.88,3.48, 25 ! 3.43,3.53 26 ADPI1,42.13,-77.12,3.56,3.27,3.31,3.09,3.36,3.41,3.63,3.91,4.09,3.69,3.53,3.65,2.63,2.46,2.47,2.33,2.49,2.53,2.66,2.82,2. 26 ! 92,2.69,2.61,2.68,3.79,3.51,3.47,3.23,3.47,3.58,3.8,4.03,4.15,3.82,3.74,3.85,3.05,2.82,2.83,2.65,2.88,2.93,3.1,3.32,3.48, 26 ! 3.19,3.03,3.13 27 AGTI1,33.38,-116.87,2.68,2.61,2.63,2.42,2.4,2.33,2.33,2.45,2.49,2.46,2.29,2.42,2.1,2.08,2.11,1.98,1.98,1.93,1.93,2.01,2.0 27 ! 2,1.99,1.87,1.95,2.94,2.95,3.02,2.85,2.88,2.81,2.78,2.9,2.9,2.83,2.56,2.69,2.39,2.34,2.36,2.19,2.2,2.16,2.16,2.25,2.29,2. 27 ! 24,2.09,2.18 28 YOSE1,37.63,-119.62,3.57,3.35,3.19,2.58,2.4,1.91,1.67,1.63,1.74,2.01,2.62,3.16,2.57,2.46,2.38,2.03,1.92,1.62,1.47,1.44,1. 28 ! 51,1.67,2.04,2.34,3.51,3.37,3.28,2.77,2.61,2.1,1.82,1.75,1.88,2.14,2.74,3.17,3.03,2.85,2.74,2.24,2.1,1.69,1.48,1.45,1.56, 28 ! 1.77,2.27,2.7 29 ZICA1,37.13,-113.12,2.9,2.67,2.19,1.79,1.63,1.35,1.35,1.58,1.6,1.72,2.15,2.58,2.23,2.1,1.79,1.53,1.43,1.24,1.25,1.4,1.41, 29 ! 1.49,1.78,2.05,3.11,2.9,2.36,1.9,1.72,1.41,1.43,1.7,1.68,1.83,2.36,2.84,2.53,2.34,1.93,1.61,1.47,1.26,1.25,1.43,1.45,1.55 29 ! ,1.9,2.27 30 ZION1,37.38,-113.12,3.05,2.81,2.26,1.84,1.67,1.37,1.33,1.54,1.58,1.75,2.25,2.72,2.32,2.18,1.83,1.56,1.45,1.26,1.24,1.38,1 30 ! .4,1.51,1.84,2.14,3.26,3.03,2.44,1.96,1.78,1.44,1.41,1.66,1.67,1.88,2.48,2.98,2.65,2.45,1.99,1.64,1.51,1.27,1.24,1.4,1.43 30 ! ,1.58,1.99,2.39 31 ******/ 32 33 data sasd.v1a_R6_13sites_IMPROVE_data_raw; 34 infile "&base./GDIT_13sites_for_2nd_IMPROVE_Eqn.R6.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; 35 input siteid :$5. classIarea :$40. stabbr :$2. lat lon elev sdate :$11. edate :$11. notes :$20. G100_NC_dv 35 ! mean_ann_temp_c ssray 36 fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12 37 flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12 38 fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12 ; 39 run; 40 proc sort data=sasd.v1a_R6_13sites_IMPROVE_data_raw; by siteid; run; 41 42 data sasd.v1b_R6_13sites_IMPROVE_data(drop=elev sdate edate notes G100_NC_dv mean_ann_temp_c); 43 set sasd.v1a_R6_13sites_IMPROVE_data_raw; 44 run; 45 46 data sasd.v1c_site_frh_only_BART(keep=siteid frh_1 frh_2 frh_3 frh_4 frh_5 frh_6 frh_7 frh_8 frh_9 frh_10 frh_11 frh_12); 47 infile "&base./IMPROVE_site_frh_2015.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; 48 input siteid :$5. grid_lat grid_lon 49 fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12 50 flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12 51 fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12 52 frh_1 frh_2 frh_3 frh_4 frh_5 frh_6 frh_7 frh_8 frh_9 frh_10 frh_11 frh_12; 53 if siteid in ('BAND1','BIBE1','BRIS1','CACR1','GRSA1','GUMO1','HEGL1','MING1','SACR1','UPBU1','WHIT1','WHPE1','WIMO1'); 54 run; 3 The SAS System 16:47 Tuesday, October 11, 2022 55 proc sort data=sasd.v1c_site_frh_only_BART; by siteid; run; 56 57 ******************; 58 59 data sasd.v2_mrg_improve_maskdata; 60 merge sasd.v1b_R6_13sites_IMPROVE_data(in=a) 61 sasd.v1c_site_frh_only_BART(in=b); 62 by siteid; 63 if a and b; 64 run; 65 66 ******************; 67 68 %macro breakout(x,fXrh); 69 70 data sasd.v3&x.1_&fXrh._monthly_cols(keep=siteid lat lon ssray &fXrh._1 &fXrh._2 &fXrh._3 &fXrh._4 &fXrh._5 &fXrh._6 70 ! &fXrh._7 &fXrh._8 &fXrh._9 &fXrh._10 &fXrh._11 &fXrh._12); 71 set sasd.v2_mrg_improve_maskdata; 72 run; 73 74 proc transpose data=sasd.v3&x.1_&fXrh._monthly_cols out=sasd.v3&x.2_&fXrh._transposed; 75 by siteid lat lon ssray; 76 var &fXrh._1 &fXrh._2 &fXrh._3 &fXrh._4 &fXrh._5 &fXrh._6 &fXrh._7 &fXrh._8 &fXrh._9 &fXrh._10 &fXrh._11 &fXrh._12; 77 run; 78 79 data sasd.v3&x.2_&fXrh._transposed(rename=(COL1=&fXrh. _NAME_=&fXrh._mnth)); 80 set sasd.v3&x.2_&fXrh._transposed; 81 run; 82 83 %mend breakout; 84 *********; 85 %breakout(a,fsrh) 86 %breakout(b,flrh) 87 %breakout(c,fssrh) 88 %breakout(d,frh) 89 90 ******************; 91 92 data sasd.v4a_BART_improve_maskdata_grd02; 93 merge sasd.v3a2_fsrh_transposed(in=c) 94 sasd.v3b2_flrh_transposed(in=d) 95 sasd.v3c2_fssrh_transposed(in=e) 96 sasd.v3d2_frh_transposed(in=f); 97 by siteid lat lon ssray; 98 if c and d and e and f; 99 run; 100 101 data sasd.v4b_BART_improve_maskdata_grd02; 102 set sasd.v4a_BART_improve_maskdata_grd02; 103 drop fsrh_mnth flrh_mnth fssrh_mnth frh_mnth; 104 run; 105 106 ******************; 107 108 proc export data=sasd.v4b_BART_improve_maskdata_grd02 109 outfile="&base./improve_maskdata_grd02.2016_BART.with_header.csv" 110 DBMS=CSV REPLACE; 111 run; 4 The SAS System 16:47 Tuesday, October 11, 2022 112 113 proc export data=sasd.v4b_BART_improve_maskdata_grd02 114 outfile="&base./improve_maskdata_grd02.2016_BART.csv" 115 DBMS=CSV REPLACE; 116 putnames=no; 117 run; 118 119 ******************; 120 %MEND program; 121 %program MLOGIC(PROGRAM): Beginning execution. MPRINT(PROGRAM): data sasd.v1a_R6_13sites_IMPROVE_data_raw; MPRINT(PROGRAM): infile "./GDIT_13sites_for_2nd_IMPROVE_Eqn.R6.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; MPRINT(PROGRAM): input siteid :$5. classIarea :$40. stabbr :$2. lat lon elev sdate :$11. edate :$11. notes :$20. G100_NC_dv mean_ann_temp_c ssray fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12 flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12 fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12 ; MPRINT(PROGRAM): run; NOTE: The infile "./GDIT_13sites_for_2nd_IMPROVE_Eqn.R6.csv" is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/classI_receptors/2.GDIT_2016/3.FINAL_R6_IMPROVE/GDIT_13sites_for_2n d_IMPROVE_Eqn.R6.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=11Oct2022:14:32:14, File Size (bytes)=4066 NOTE: 13 records were read from the infile "./GDIT_13sites_for_2nd_IMPROVE_Eqn.R6.csv". The minimum record length was 254. The maximum record length was 304. NOTE: The data set SASD.V1A_R6_13SITES_IMPROVE_DATA_RAW has 13 observations and 48 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MPRINT(PROGRAM): proc sort data=sasd.v1a_R6_13sites_IMPROVE_data_raw; MPRINT(PROGRAM): by siteid; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1A_R6_13SITES_IMPROVE_DATA_RAW. NOTE: The data set SASD.V1A_R6_13SITES_IMPROVE_DATA_RAW has 13 observations and 48 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(PROGRAM): data sasd.v1b_R6_13sites_IMPROVE_data(drop=elev sdate edate notes G100_NC_dv mean_ann_temp_c); MPRINT(PROGRAM): set sasd.v1a_R6_13sites_IMPROVE_data_raw; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1A_R6_13SITES_IMPROVE_DATA_RAW. NOTE: The data set SASD.V1B_R6_13SITES_IMPROVE_DATA has 13 observations and 42 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 5 The SAS System 16:47 Tuesday, October 11, 2022 MPRINT(PROGRAM): data sasd.v1c_site_frh_only_BART(keep=siteid frh_1 frh_2 frh_3 frh_4 frh_5 frh_6 frh_7 frh_8 frh_9 frh_10 frh_11 frh_12); MPRINT(PROGRAM): infile "./IMPROVE_site_frh_2015.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; MPRINT(PROGRAM): input siteid :$5. grid_lat grid_lon fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12 flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12 fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12 frh_1 frh_2 frh_3 frh_4 frh_5 frh_6 frh_7 frh_8 frh_9 frh_10 frh_11 frh_12; MPRINT(PROGRAM): if siteid in ('BAND1','BIBE1','BRIS1','CACR1','GRSA1','GUMO1','HEGL1','MING1','SACR1','UPBU1','WHIT1','WHPE1','WIMO1'); MPRINT(PROGRAM): run; NOTE: The infile "./IMPROVE_site_frh_2015.csv" is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/classI_receptors/2.GDIT_2016/3.FINAL_R6_IMPROVE/IMPROVE_site_frh_20 15.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=14Sep2022:14:59:02, File Size (bytes)=55977 NOTE: 219 records were read from the infile "./IMPROVE_site_frh_2015.csv". The minimum record length was 242. The maximum record length was 259. NOTE: The data set SASD.V1C_SITE_FRH_ONLY_BART has 13 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MPRINT(PROGRAM): proc sort data=sasd.v1c_site_frh_only_BART; MPRINT(PROGRAM): by siteid; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1C_SITE_FRH_ONLY_BART. NOTE: The data set SASD.V1C_SITE_FRH_ONLY_BART has 13 observations and 13 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(PROGRAM): ******************; MPRINT(PROGRAM): data sasd.v2_mrg_improve_maskdata; MPRINT(PROGRAM): merge sasd.v1b_R6_13sites_IMPROVE_data(in=a) sasd.v1c_site_frh_only_BART(in=b); MPRINT(PROGRAM): by siteid; MPRINT(PROGRAM): if a and b; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1B_R6_13SITES_IMPROVE_DATA. NOTE: There were 13 observations read from the data set SASD.V1C_SITE_FRH_ONLY_BART. NOTE: The data set SASD.V2_MRG_IMPROVE_MASKDATA has 13 observations and 54 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.01 seconds MPRINT(PROGRAM): ******************; MPRINT(PROGRAM): *********; 6 The SAS System 16:47 Tuesday, October 11, 2022 MLOGIC(BREAKOUT): Beginning execution. MLOGIC(BREAKOUT): Parameter X has value a MLOGIC(BREAKOUT): Parameter FXRH has value fsrh MPRINT(BREAKOUT): data sasd.v3a1_fsrh_monthly_cols(keep=siteid lat lon ssray fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12); MPRINT(BREAKOUT): set sasd.v2_mrg_improve_maskdata; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V2_MRG_IMPROVE_MASKDATA. NOTE: The data set SASD.V3A1_FSRH_MONTHLY_COLS has 13 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds MPRINT(BREAKOUT): proc transpose data=sasd.v3a1_fsrh_monthly_cols out=sasd.v3a2_fsrh_transposed; MPRINT(BREAKOUT): by siteid lat lon ssray; MPRINT(BREAKOUT): var fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V3A1_FSRH_MONTHLY_COLS. NOTE: The data set SASD.V3A2_FSRH_TRANSPOSED has 156 observations and 6 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MPRINT(BREAKOUT): data sasd.v3a2_fsrh_transposed(rename=(COL1=fsrh _NAME_=fsrh_mnth)); MPRINT(BREAKOUT): set sasd.v3a2_fsrh_transposed; MPRINT(BREAKOUT): run; NOTE: There were 156 observations read from the data set SASD.V3A2_FSRH_TRANSPOSED. NOTE: The data set SASD.V3A2_FSRH_TRANSPOSED has 156 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MLOGIC(BREAKOUT): Ending execution. MLOGIC(BREAKOUT): Beginning execution. MLOGIC(BREAKOUT): Parameter X has value b MLOGIC(BREAKOUT): Parameter FXRH has value flrh MPRINT(BREAKOUT): data sasd.v3b1_flrh_monthly_cols(keep=siteid lat lon ssray flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12); MPRINT(BREAKOUT): set sasd.v2_mrg_improve_maskdata; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V2_MRG_IMPROVE_MASKDATA. NOTE: The data set SASD.V3B1_FLRH_MONTHLY_COLS has 13 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds MPRINT(BREAKOUT): proc transpose data=sasd.v3b1_flrh_monthly_cols out=sasd.v3b2_flrh_transposed; MPRINT(BREAKOUT): by siteid lat lon ssray; MPRINT(BREAKOUT): var flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12; MPRINT(BREAKOUT): run; 7 The SAS System 16:47 Tuesday, October 11, 2022 NOTE: There were 13 observations read from the data set SASD.V3B1_FLRH_MONTHLY_COLS. NOTE: The data set SASD.V3B2_FLRH_TRANSPOSED has 156 observations and 6 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MPRINT(BREAKOUT): data sasd.v3b2_flrh_transposed(rename=(COL1=flrh _NAME_=flrh_mnth)); MPRINT(BREAKOUT): set sasd.v3b2_flrh_transposed; MPRINT(BREAKOUT): run; NOTE: There were 156 observations read from the data set SASD.V3B2_FLRH_TRANSPOSED. NOTE: The data set SASD.V3B2_FLRH_TRANSPOSED has 156 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MLOGIC(BREAKOUT): Ending execution. MLOGIC(BREAKOUT): Beginning execution. MLOGIC(BREAKOUT): Parameter X has value c MLOGIC(BREAKOUT): Parameter FXRH has value fssrh MPRINT(BREAKOUT): data sasd.v3c1_fssrh_monthly_cols(keep=siteid lat lon ssray fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12); MPRINT(BREAKOUT): set sasd.v2_mrg_improve_maskdata; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V2_MRG_IMPROVE_MASKDATA. NOTE: The data set SASD.V3C1_FSSRH_MONTHLY_COLS has 13 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MPRINT(BREAKOUT): proc transpose data=sasd.v3c1_fssrh_monthly_cols out=sasd.v3c2_fssrh_transposed; MPRINT(BREAKOUT): by siteid lat lon ssray; MPRINT(BREAKOUT): var fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V3C1_FSSRH_MONTHLY_COLS. NOTE: The data set SASD.V3C2_FSSRH_TRANSPOSED has 156 observations and 6 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(BREAKOUT): data sasd.v3c2_fssrh_transposed(rename=(COL1=fssrh _NAME_=fssrh_mnth)); MPRINT(BREAKOUT): set sasd.v3c2_fssrh_transposed; MPRINT(BREAKOUT): run; NOTE: There were 156 observations read from the data set SASD.V3C2_FSSRH_TRANSPOSED. NOTE: The data set SASD.V3C2_FSSRH_TRANSPOSED has 156 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 8 The SAS System 16:47 Tuesday, October 11, 2022 MLOGIC(BREAKOUT): Ending execution. MLOGIC(BREAKOUT): Beginning execution. MLOGIC(BREAKOUT): Parameter X has value d MLOGIC(BREAKOUT): Parameter FXRH has value frh MPRINT(BREAKOUT): data sasd.v3d1_frh_monthly_cols(keep=siteid lat lon ssray frh_1 frh_2 frh_3 frh_4 frh_5 frh_6 frh_7 frh_8 frh_9 frh_10 frh_11 frh_12); MPRINT(BREAKOUT): set sasd.v2_mrg_improve_maskdata; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V2_MRG_IMPROVE_MASKDATA. NOTE: The data set SASD.V3D1_FRH_MONTHLY_COLS has 13 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds MPRINT(BREAKOUT): proc transpose data=sasd.v3d1_frh_monthly_cols out=sasd.v3d2_frh_transposed; MPRINT(BREAKOUT): by siteid lat lon ssray; MPRINT(BREAKOUT): var frh_1 frh_2 frh_3 frh_4 frh_5 frh_6 frh_7 frh_8 frh_9 frh_10 frh_11 frh_12; MPRINT(BREAKOUT): run; NOTE: There were 13 observations read from the data set SASD.V3D1_FRH_MONTHLY_COLS. NOTE: The data set SASD.V3D2_FRH_TRANSPOSED has 156 observations and 6 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.04 seconds cpu time 0.00 seconds MPRINT(BREAKOUT): data sasd.v3d2_frh_transposed(rename=(COL1=frh _NAME_=frh_mnth)); MPRINT(BREAKOUT): set sasd.v3d2_frh_transposed; MPRINT(BREAKOUT): run; NOTE: There were 156 observations read from the data set SASD.V3D2_FRH_TRANSPOSED. NOTE: The data set SASD.V3D2_FRH_TRANSPOSED has 156 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.02 seconds MLOGIC(BREAKOUT): Ending execution. MPRINT(PROGRAM): ******************; MPRINT(PROGRAM): data sasd.v4a_BART_improve_maskdata_grd02; MPRINT(PROGRAM): merge sasd.v3a2_fsrh_transposed(in=c) sasd.v3b2_flrh_transposed(in=d) sasd.v3c2_fssrh_transposed(in=e) sasd.v3d2_frh_transposed(in=f); MPRINT(PROGRAM): by siteid lat lon ssray; MPRINT(PROGRAM): if c and d and e and f; MPRINT(PROGRAM): run; NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 156 observations read from the data set SASD.V3A2_FSRH_TRANSPOSED. NOTE: There were 156 observations read from the data set SASD.V3B2_FLRH_TRANSPOSED. NOTE: There were 156 observations read from the data set SASD.V3C2_FSSRH_TRANSPOSED. NOTE: There were 156 observations read from the data set SASD.V3D2_FRH_TRANSPOSED. NOTE: The data set SASD.V4A_BART_IMPROVE_MASKDATA_GRD02 has 156 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.00 seconds 9 The SAS System 16:47 Tuesday, October 11, 2022 MPRINT(PROGRAM): data sasd.v4b_BART_improve_maskdata_grd02; MPRINT(PROGRAM): set sasd.v4a_BART_improve_maskdata_grd02; MPRINT(PROGRAM): drop fsrh_mnth flrh_mnth fssrh_mnth frh_mnth; MPRINT(PROGRAM): run; NOTE: There were 156 observations read from the data set SASD.V4A_BART_IMPROVE_MASKDATA_GRD02. NOTE: The data set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02 has 156 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds MPRINT(PROGRAM): ******************; MPRINT(PROGRAM): proc export data=sasd.v4b_BART_improve_maskdata_grd02 outfile="./improve_maskdata_grd02.2016_BART.with_header.csv" DBMS=CSV REPLACE; MPRINT(PROGRAM): ADLM; MPRINT(PROGRAM): run; ERROR: Expecting page 1, got page -1 instead. ERROR: Page validation error while reading SASUSER.PROFILE.CATALOG. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. 122 /********************************************************************** 123 * PRODUCT: SAS 124 * VERSION: 9.4 125 * CREATOR: External File Interface 126 * DATE: 11OCT22 127 * DESC: Generated SAS Datastep Code 128 * TEMPLATE SOURCE: (None Specified.) 129 ***********************************************************************/ 130 data _null_; MPRINT(PROGRAM): data _null_; 131 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 132 %let _EFIREC_ = 0; /* clear export record count macro variable */ 133 file './improve_maskdata_grd02.2016_BART.with_header.csv' delimiter=',' DSD DROPOVER lrecl=32767; MPRINT(PROGRAM): file './improve_maskdata_grd02.2016_BART.with_header.csv' delimiter=',' DSD DROPOVER lrecl=32767; 134 if _n_ = 1 then /* write column names or labels */ 135 do; MPRINT(PROGRAM): if _n_ = 1 then do; 136 put 137 "siteid" 138 ',' 139 "lat" 140 ',' 141 "lon" 142 ',' 143 "ssray" 144 ',' 145 "fsrh" 146 ',' 147 "flrh" 148 ',' 149 "fssrh" 150 ',' 151 "frh" 152 ; MPRINT(PROGRAM): put "siteid" ',' "lat" ',' "lon" ',' "ssray" ',' "fsrh" ',' "flrh" ',' "fssrh" ',' "frh" ; 10 The SAS System 16:47 Tuesday, October 11, 2022 153 end; MPRINT(PROGRAM): end; 154 set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02 end=EFIEOD; MPRINT(PROGRAM): set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02 end=EFIEOD; 155 format siteid $5. ; MPRINT(PROGRAM): format siteid $5. ; 156 format lat best12. ; MPRINT(PROGRAM): format lat best12. ; 157 format lon best12. ; MPRINT(PROGRAM): format lon best12. ; 158 format ssray best12. ; MPRINT(PROGRAM): format ssray best12. ; 159 format fsrh best12. ; MPRINT(PROGRAM): format fsrh best12. ; 160 format flrh best12. ; MPRINT(PROGRAM): format flrh best12. ; 161 format fssrh best12. ; MPRINT(PROGRAM): format fssrh best12. ; 162 format frh best12. ; MPRINT(PROGRAM): format frh best12. ; 163 do; MPRINT(PROGRAM): do; 164 EFIOUT + 1; MPRINT(PROGRAM): EFIOUT + 1; 165 put siteid $ @; MPRINT(PROGRAM): put siteid $ @; 166 put lat @; MPRINT(PROGRAM): put lat @; 167 put lon @; MPRINT(PROGRAM): put lon @; 168 put ssray @; MPRINT(PROGRAM): put ssray @; 169 put fsrh @; MPRINT(PROGRAM): put fsrh @; 170 put flrh @; MPRINT(PROGRAM): put flrh @; 171 put fssrh @; MPRINT(PROGRAM): put fssrh @; 172 put frh ; MPRINT(PROGRAM): put frh ; 173 ; MPRINT(PROGRAM): ; 174 end; MPRINT(PROGRAM): end; 175 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ MPRINT(PROGRAM): if _ERROR_ then call symputx('_EFIERR_',1); 176 if EFIEOD then call symputx('_EFIREC_',EFIOUT); MPRINT(PROGRAM): if EFIEOD then call symputx('_EFIREC_',EFIOUT); 177 run; MPRINT(PROGRAM): run; NOTE: The file './improve_maskdata_grd02.2016_BART.with_header.csv' is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/classI_receptors/2.GDIT_2016/3.FINAL_R6_IMPROVE/improve_maskdata_gr d02.2016_BART.with_header.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=11Oct2022:16:47:40 11 The SAS System 16:47 Tuesday, October 11, 2022 NOTE: 157 records were written to the file './improve_maskdata_grd02.2016_BART.with_header.csv'. The minimum record length was 40. The maximum record length was 46. NOTE: There were 156 observations read from the data set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 156 records created in ./improve_maskdata_grd02.2016_BART.with_header.csv from SASD.V4B_BART_IMPROVE_MASKDATA_GRD02. NOTE: "./improve_maskdata_grd02.2016_BART.with_header.csv" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.10 seconds cpu time 0.05 seconds MPRINT(PROGRAM): ; MPRINT(PROGRAM): proc export data=sasd.v4b_BART_improve_maskdata_grd02 outfile="./improve_maskdata_grd02.2016_BART.csv" DBMS=CSV REPLACE; MPRINT(PROGRAM): ADLM; MPRINT(PROGRAM): putnames=no; MPRINT(PROGRAM): run; 178 /********************************************************************** 179 * PRODUCT: SAS 180 * VERSION: 9.4 181 * CREATOR: External File Interface 182 * DATE: 11OCT22 183 * DESC: Generated SAS Datastep Code 184 * TEMPLATE SOURCE: (None Specified.) 185 ***********************************************************************/ 186 data _null_; MPRINT(PROGRAM): data _null_; 187 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 188 %let _EFIREC_ = 0; /* clear export record count macro variable */ 189 file './improve_maskdata_grd02.2016_BART.csv' delimiter=',' DSD DROPOVER lrecl=32767; MPRINT(PROGRAM): file './improve_maskdata_grd02.2016_BART.csv' delimiter=',' DSD DROPOVER lrecl=32767; 190 set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02 end=EFIEOD; MPRINT(PROGRAM): set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02 end=EFIEOD; 191 format siteid $5. ; MPRINT(PROGRAM): format siteid $5. ; 192 format lat best12. ; MPRINT(PROGRAM): format lat best12. ; 193 format lon best12. ; MPRINT(PROGRAM): format lon best12. ; 194 format ssray best12. ; MPRINT(PROGRAM): format ssray best12. ; 195 format fsrh best12. ; MPRINT(PROGRAM): format fsrh best12. ; 196 format flrh best12. ; MPRINT(PROGRAM): format flrh best12. ; 197 format fssrh best12. ; MPRINT(PROGRAM): format fssrh best12. ; 198 format frh best12. ; MPRINT(PROGRAM): format frh best12. ; 12 The SAS System 16:47 Tuesday, October 11, 2022 199 do; MPRINT(PROGRAM): do; 200 EFIOUT + 1; MPRINT(PROGRAM): EFIOUT + 1; 201 put siteid $ @; MPRINT(PROGRAM): put siteid $ @; 202 put lat @; MPRINT(PROGRAM): put lat @; 203 put lon @; MPRINT(PROGRAM): put lon @; 204 put ssray @; MPRINT(PROGRAM): put ssray @; 205 put fsrh @; MPRINT(PROGRAM): put fsrh @; 206 put flrh @; MPRINT(PROGRAM): put flrh @; 207 put fssrh @; MPRINT(PROGRAM): put fssrh @; 208 put frh ; MPRINT(PROGRAM): put frh ; 209 ; MPRINT(PROGRAM): ; 210 end; MPRINT(PROGRAM): end; 211 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ MPRINT(PROGRAM): if _ERROR_ then call symputx('_EFIERR_',1); 212 if EFIEOD then call symputx('_EFIREC_',EFIOUT); MPRINT(PROGRAM): if EFIEOD then call symputx('_EFIREC_',EFIOUT); 213 run; MPRINT(PROGRAM): run; NOTE: The file './improve_maskdata_grd02.2016_BART.csv' is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/classI_receptors/2.GDIT_2016/3.FINAL_R6_IMPROVE/improve_maskdata_gr d02.2016_BART.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=11Oct2022:16:47:40 NOTE: 156 records were written to the file './improve_maskdata_grd02.2016_BART.csv'. The minimum record length was 40. The maximum record length was 46. NOTE: There were 156 observations read from the data set SASD.V4B_BART_IMPROVE_MASKDATA_GRD02. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 156 records created in ./improve_maskdata_grd02.2016_BART.csv from SASD.V4B_BART_IMPROVE_MASKDATA_GRD02. NOTE: "./improve_maskdata_grd02.2016_BART.csv" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.04 seconds cpu time 0.02 seconds MPRINT(PROGRAM): ; 13 The SAS System 16:47 Tuesday, October 11, 2022 MPRINT(PROGRAM): ******************; MLOGIC(PROGRAM): Ending execution. ERROR: Errors printed on page 9. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 0.98 seconds cpu time 0.21 seconds