1 The SAS System 23:17 Wednesday, October 12, 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.05 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/natural_conditions/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 23:17 Wednesday, October 12, 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 Natural_Conditions_tabulated_fromMF.csv 23 ------------------------------------------------ 24 Class I Area,(1/Mm),dv 25 BAND,14.00281,3.366726 26 BIBE,14.9402,4.014705 27 BOAP,15.16274,4.162559 28 WHIT,13.92185,3.308748 29 WHPE,12.6323,2.336718 30 WIMO,16.62253,5.081742 31 32 nc2_4_20.csv 33 ------------------------------------------------ 34 site,Group,n_years,sea_salt_mass,fine_soil_mass,ammonium_nitrate_mass,ammonium_sulfate_mass,organic_mass,elemental_carbon 34 ! _mass,coarse_mass,SIA_Ammonium_Sulfate_Ext,SIA_Ammonium_Nitrate_Ext,SIA_Organic_ext,SIA_Elemental_Carbon_Ext,SIA_Fine_Soi 34 ! l_Ext,SIA_Sea_Salt_Ext,SIA_Coarse_Ext,SIA_Natural_Ext,rayleigh_ext,Nat_DV,NAT_SVR,method,NC_first_year 35 ACAD1,10,5,0.028150906,0.104311233,0.029175328,0.088654459,0.683410498,0.00835176,0.939454123,0.759453964,0.27296902,2.00 35 ! 0489744,0.083517598,0.104311233,0.186287624,0.563672474,15.97070166,12,4.660356803,281.4771419,RHR_Baseline, 36 ACAD1,50,5,0.112226399,0.186530818,0.078965819,0.160102062,1.35687059,0.015814905,2.04652147,1.377310061,0.735231292,4.13 36 ! 2402587,0.158149052,0.186530818,0.744643673,1.227912882,20.56218036,12,7.19310039,211.4471325,RHR_Baseline, 37 ACAD1,90,5,0.322978837,0.517074274,0.208481466,0.526873722,3.318951262,0.039835447,3.621094004,4.79378245,1.972499457,11. 37 ! 80595962,0.398354467,0.517074274,2.126614905,2.172656402,35.78694157,12,12.43373718,122.9461467,RHR_Baseline, 38 ACAD1,100,5,0.145983616,0.247100745,0.1,0.23,1.666966007,0.02,2.137782727,2.036258418,0.934333805,5.432542826,0.2,0.24710 38 ! 0745,0.959297517,1.282669637,23.09220295,12,7.880220807,205.5476534,RHR_Baseline, 39 ZION1,10,3,0.005083516,0.143861624,0.040422147,0.049606162,0.267164746,0.013059004,1.007109454,0.24760278,0.239445352,0.7 39 ! 62603765,0.130590039,0.143861624,0.02142823,0.604265672,12.14979746,10,1.937974026,322.4177118,RHR_Baseline, 40 ZION1,50,3,0.003109267,0.41239759,0.091368238,0.120409047,0.508180825,0.018413861,2.532421867,0.47676842,0.490761439,1.47 40 ! 1999521,0.184138612,0.41239759,0.013699839,1.51945312,14.56921854,10,3.758585893,268.6253373,RHR_Baseline, 41 ZION1,90,3,0.00676419,1.128539356,0.149173624,0.170094491,1.216205891,0.029891344,6.279866542,0.609429067,0.816136591,3.7 41 ! 57195021,0.298913441,1.128539356,0.019425758,3.767919925,20.39755916,10,6.987669103,196.7918992,RHR_Baseline, 42 ZION1,100,3,0.005705263,0.5,0.1,0.115,0.5994,0.02,3,0.460185595,0.564940479,1.781856319,0.2,0.5,0.021769134,1.8,15.328751 42 ! 53,10,4.078404244,264.3878426,RHR_Baseline, 43 ******/ 44 45 data sasd.v1a1_R6_13sites_IMPROVE_data_raw; 46 infile "&base./GDIT_13sites_for_2nd_IMPROVE_Eqn.R6.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; 47 input siteid :$5. classIarea :$40. stabbr :$2. lat lon elev sdate :$11. edate :$11. notes :$20. NCdv_R6_G100 47 ! mean_ann_temp_c ssray 48 fsrh_1 fsrh_2 fsrh_3 fsrh_4 fsrh_5 fsrh_6 fsrh_7 fsrh_8 fsrh_9 fsrh_10 fsrh_11 fsrh_12 49 flrh_1 flrh_2 flrh_3 flrh_4 flrh_5 flrh_6 flrh_7 flrh_8 flrh_9 flrh_10 flrh_11 flrh_12 50 fssrh_1 fssrh_2 fssrh_3 fssrh_4 fssrh_5 fssrh_6 fssrh_7 fssrh_8 fssrh_9 fssrh_10 fssrh_11 fssrh_12 ; 51 run; 52 proc sort data=sasd.v1a1_R6_13sites_IMPROVE_data_raw; by siteid; run; 53 54 data sasd.v1a2_R6_13sites_IMPROVE_data(keep=c1aID siteid classIarea stabbr notes NCdv_R6_G100); 55 length c1aID $4.; 56 set sasd.v1a1_R6_13sites_IMPROVE_data_raw; 57 c1aID = substr(siteid,1,4); 58 run; 59 3 The SAS System 23:17 Wednesday, October 12, 2022 60 *********; 61 62 data sasd.v1b1_NatCon_fromMF; 63 infile "&base./Natural_Conditions_tabulated_fromMF.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; 64 input c1aID :$4. NatExt_MF NCdv_MF; 65 run; 66 proc sort data=sasd.v1b1_NatCon_fromMF; by c1aID; run; 67 68 data sasd.v1b2_NatCon_fromMF_BART; 69 set sasd.v1b1_NatCon_fromMF; 70 if c1aID eq 'BRET' then c1aID = 'BRIS'; 71 if c1aID in ('BAND','BIBE','BRIS','CACR','GRSA','GUMO','HEGL','MING','SACR','UPBU','WHIT','WHPE','WIMO'); 72 run; 73 74 *********; 75 76 data sasd.v1c1_nc2_4_20_raw; 77 infile "&base./nc2_4_20.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; 78 input siteid :$5. Group n_years sea_salt_mass fine_soil_mass ammonium_nitrate_mass ammonium_sulfate_mass 79 organic_mass elemental_carbon_mass coarse_mass SIA_Ammonium_Sulfate_Ext SIA_Ammonium_Nitrate_Ext 80 SIA_Organic_ext SIA_Elemental_Carbon_Ext SIA_Fine_Soil_Ext SIA_Sea_Salt_Ext SIA_Coarse_Ext 81 SIA_Natural_Ext rayleigh_ext Nat_DV NAT_SVR method :$12. NC_first_year; 82 run; 83 proc sort data=sasd.v1c1_nc2_4_20_raw; by siteid; run; 84 85 data sasd.v1c2_nc2_4_20_BART(keep=c1aID siteid Group NatExt_nc20 NCdv_nc20); 86 length c1aID $4. siteid $5. Group NatExt_nc20 NCdv_nc20 8.; 87 set sasd.v1c1_nc2_4_20_raw; 88 c1aID = substr(siteid,1,4); 89 NatExt_nc20 = SIA_Natural_Ext; 90 NCdv_nc20 = Nat_DV; 91 if Group eq 100; 92 if c1aID in ('BAND','BIBE','BRIS','CACR','GRSA','GUMO','HEGL','MING','SACR','UPBU','WHIT','WHPE','WIMO'); 93 run; 94 95 ************************************; 96 97 data sasd.v2a_mrg_natcon; 98 length c1aID $4. siteid $5. classIarea $40. stabbr $2. notes $20. Group NatExt_MF NatExt_nc20 NCdv_MF NCdv_nc20 98 ! NCdv_R6_G100 8.; 99 merge sasd.v1a2_R6_13sites_IMPROVE_data(in=a) 100 sasd.v1b2_NatCon_fromMF_BART(in=b) 101 sasd.v1c2_nc2_4_20_BART(in=c); 102 by c1aID; 103 if a and b and c; 104 run; 105 106 proc export data=sasd.v2a_mrg_natcon 107 outfile="&base./NatCon_merged_for_comparison.MF_nc20.csv" 108 DBMS=CSV REPLACE; 109 run; 110 111 *********; 112 113 data sasd.v2b_natcon_for_csv(keep=c1aID NatExt_nc20 NCdv_nc20); 114 set sasd.v2a_mrg_natcon; 115 format NatExt_nc20 f8.5 NCdv_nc20 f8.6; 116 run; 4 The SAS System 23:17 Wednesday, October 12, 2022 117 118 *********; 119 120 data sasd.v2c_natcon_colocated; 121 set sasd.v2b_natcon_for_csv; 122 if c1aID eq 'GUMO' then c1aID = 'CAVE'; 123 if c1aID eq 'WHPE' then c1aID = 'PECO'; 124 if c1aID in ('CAVE','PECO'); 125 run; 126 proc sort data=sasd.v2c_natcon_colocated; by c1aID; run; 127 128 *********; 129 130 data sasd.v2d_natcon_for_csv; 131 set sasd.v2b_natcon_for_csv 132 sasd.v2c_natcon_colocated; 133 by c1aID; 134 run; 135 136 data _null_; 137 set sasd.v2d_natcon_for_csv; 138 file "&base./Natural_Conditions.nc2_4_20.csv" DLM=','; 139 if _n_ eq 1 then put 'Class I Area,(1/Mm),dv'; 140 put c1aID NatExt_nc20 NCdv_nc20; 141 run; 142 143 ************************************; 144 145 ******************; 146 %MEND program; 147 %program MLOGIC(PROGRAM): Beginning execution. MPRINT(PROGRAM): data sasd.v1a1_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. NCdv_R6_G100 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/natural_conditions/GDIT_13sites_for_2nd_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.V1A1_R6_13SITES_IMPROVE_DATA_RAW has 13 observations and 48 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.01 seconds MPRINT(PROGRAM): proc sort data=sasd.v1a1_R6_13sites_IMPROVE_data_raw; MPRINT(PROGRAM): by siteid; 5 The SAS System 23:17 Wednesday, October 12, 2022 MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1A1_R6_13SITES_IMPROVE_DATA_RAW. NOTE: The data set SASD.V1A1_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.v1a2_R6_13sites_IMPROVE_data(keep=c1aID siteid classIarea stabbr notes NCdv_R6_G100); MPRINT(PROGRAM): length c1aID $4.; MPRINT(PROGRAM): set sasd.v1a1_R6_13sites_IMPROVE_data_raw; MPRINT(PROGRAM): c1aID = substr(siteid,1,4); MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1A1_R6_13SITES_IMPROVE_DATA_RAW. NOTE: The data set SASD.V1A2_R6_13SITES_IMPROVE_DATA has 13 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MPRINT(PROGRAM): *********; MPRINT(PROGRAM): data sasd.v1b1_NatCon_fromMF; MPRINT(PROGRAM): infile "./Natural_Conditions_tabulated_fromMF.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; MPRINT(PROGRAM): input c1aID :$4. NatExt_MF NCdv_MF; MPRINT(PROGRAM): run; NOTE: The infile "./Natural_Conditions_tabulated_fromMF.csv" is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/natural_conditions/Natural_Conditions_tabulated_fromMF.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=11Oct2022:14:32:14, File Size (bytes)=455 NOTE: 19 records were read from the infile "./Natural_Conditions_tabulated_fromMF.csv". The minimum record length was 21. The maximum record length was 22. NOTE: The data set SASD.V1B1_NATCON_FROMMF has 19 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(PROGRAM): proc sort data=sasd.v1b1_NatCon_fromMF; MPRINT(PROGRAM): by c1aID; MPRINT(PROGRAM): run; NOTE: There were 19 observations read from the data set SASD.V1B1_NATCON_FROMMF. NOTE: The data set SASD.V1B1_NATCON_FROMMF has 19 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MPRINT(PROGRAM): data sasd.v1b2_NatCon_fromMF_BART; MPRINT(PROGRAM): set sasd.v1b1_NatCon_fromMF; MPRINT(PROGRAM): if c1aID eq 'BRET' then c1aID = 'BRIS'; 6 The SAS System 23:17 Wednesday, October 12, 2022 MPRINT(PROGRAM): if c1aID in ('BAND','BIBE','BRIS','CACR','GRSA','GUMO','HEGL','MING','SACR','UPBU','WHIT','WHPE','WIMO'); MPRINT(PROGRAM): run; NOTE: There were 19 observations read from the data set SASD.V1B1_NATCON_FROMMF. NOTE: The data set SASD.V1B2_NATCON_FROMMF_BART has 13 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(PROGRAM): *********; MPRINT(PROGRAM): data sasd.v1c1_nc2_4_20_raw; MPRINT(PROGRAM): infile "./nc2_4_20.csv" DLM=',' DSD MISSOVER FIRSTOBS=2; MPRINT(PROGRAM): input siteid :$5. Group n_years sea_salt_mass fine_soil_mass ammonium_nitrate_mass ammonium_sulfate_mass organic_mass elemental_carbon_mass coarse_mass SIA_Ammonium_Sulfate_Ext SIA_Ammonium_Nitrate_Ext SIA_Organic_ext SIA_Elemental_Carbon_Ext SIA_Fine_Soil_Ext SIA_Sea_Salt_Ext SIA_Coarse_Ext SIA_Natural_Ext rayleigh_ext Nat_DV NAT_SVR method :$12. NC_first_year; MPRINT(PROGRAM): run; NOTE: The infile "./nc2_4_20.csv" is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/natural_conditions/nc2_4_20.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=12Oct2022:17:05:20, File Size (bytes)=164481 NOTE: 756 records were read from the infile "./nc2_4_20.csv". The minimum record length was 154. The maximum record length was 235. NOTE: The data set SASD.V1C1_NC2_4_20_RAW has 756 observations and 23 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MPRINT(PROGRAM): proc sort data=sasd.v1c1_nc2_4_20_raw; MPRINT(PROGRAM): by siteid; MPRINT(PROGRAM): run; NOTE: There were 756 observations read from the data set SASD.V1C1_NC2_4_20_RAW. NOTE: The data set SASD.V1C1_NC2_4_20_RAW has 756 observations and 23 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(PROGRAM): data sasd.v1c2_nc2_4_20_BART(keep=c1aID siteid Group NatExt_nc20 NCdv_nc20); MPRINT(PROGRAM): length c1aID $4. siteid $5. Group NatExt_nc20 NCdv_nc20 8.; MPRINT(PROGRAM): set sasd.v1c1_nc2_4_20_raw; MPRINT(PROGRAM): c1aID = substr(siteid,1,4); MPRINT(PROGRAM): NatExt_nc20 = SIA_Natural_Ext; MPRINT(PROGRAM): NCdv_nc20 = Nat_DV; MPRINT(PROGRAM): if Group eq 100; MPRINT(PROGRAM): if c1aID in ('BAND','BIBE','BRIS','CACR','GRSA','GUMO','HEGL','MING','SACR','UPBU','WHIT','WHPE','WIMO'); MPRINT(PROGRAM): run; NOTE: There were 756 observations read from the data set SASD.V1C1_NC2_4_20_RAW. NOTE: The data set SASD.V1C2_NC2_4_20_BART has 13 observations and 5 variables. 7 The SAS System 23:17 Wednesday, October 12, 2022 NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds MPRINT(PROGRAM): ************************************; MPRINT(PROGRAM): data sasd.v2a_mrg_natcon; MPRINT(PROGRAM): length c1aID $4. siteid $5. classIarea $40. stabbr $2. notes $20. Group NatExt_MF NatExt_nc20 NCdv_MF NCdv_nc20 NCdv_R6_G100 8.; MPRINT(PROGRAM): merge sasd.v1a2_R6_13sites_IMPROVE_data(in=a) sasd.v1b2_NatCon_fromMF_BART(in=b) sasd.v1c2_nc2_4_20_BART(in=c); MPRINT(PROGRAM): by c1aID; MPRINT(PROGRAM): if a and b and c; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V1A2_R6_13SITES_IMPROVE_DATA. NOTE: There were 13 observations read from the data set SASD.V1B2_NATCON_FROMMF_BART. NOTE: There were 13 observations read from the data set SASD.V1C2_NC2_4_20_BART. NOTE: The data set SASD.V2A_MRG_NATCON has 13 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.01 seconds MPRINT(PROGRAM): proc export data=sasd.v2a_mrg_natcon outfile="./NatCon_merged_for_comparison.MF_nc20.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. 148 /********************************************************************** 149 * PRODUCT: SAS 150 * VERSION: 9.4 151 * CREATOR: External File Interface 152 * DATE: 12OCT22 153 * DESC: Generated SAS Datastep Code 154 * TEMPLATE SOURCE: (None Specified.) 155 ***********************************************************************/ 156 data _null_; MPRINT(PROGRAM): data _null_; 157 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 158 %let _EFIREC_ = 0; /* clear export record count macro variable */ 159 file './NatCon_merged_for_comparison.MF_nc20.csv' delimiter=',' DSD DROPOVER lrecl=32767; MPRINT(PROGRAM): file './NatCon_merged_for_comparison.MF_nc20.csv' delimiter=',' DSD DROPOVER lrecl=32767; 160 if _n_ = 1 then /* write column names or labels */ 161 do; MPRINT(PROGRAM): if _n_ = 1 then do; 162 put 163 "c1aID" 164 ',' 165 "siteid" 166 ',' 167 "classIarea" 168 ',' 169 "stabbr" 170 ',' 171 "notes" 8 The SAS System 23:17 Wednesday, October 12, 2022 172 ',' 173 "Group" 174 ',' 175 "NatExt_MF" 176 ',' 177 "NatExt_nc20" 178 ',' 179 "NCdv_MF" 180 ',' 181 "NCdv_nc20" 182 ',' 183 "NCdv_R6_G100" 184 ; MPRINT(PROGRAM): put "c1aID" ',' "siteid" ',' "classIarea" ',' "stabbr" ',' "notes" ',' "Group" ',' "NatExt_MF" ',' "NatExt_nc20" ',' "NCdv_MF" ',' "NCdv_nc20" ',' "NCdv_R6_G100" ; 185 end; MPRINT(PROGRAM): end; 186 set SASD.V2A_MRG_NATCON end=EFIEOD; MPRINT(PROGRAM): set SASD.V2A_MRG_NATCON end=EFIEOD; 187 format c1aID $4. ; MPRINT(PROGRAM): format c1aID $4. ; 188 format siteid $5. ; MPRINT(PROGRAM): format siteid $5. ; 189 format classIarea $40. ; MPRINT(PROGRAM): format classIarea $40. ; 190 format stabbr $2. ; MPRINT(PROGRAM): format stabbr $2. ; 191 format notes $20. ; MPRINT(PROGRAM): format notes $20. ; 192 format Group best12. ; MPRINT(PROGRAM): format Group best12. ; 193 format NatExt_MF best12. ; MPRINT(PROGRAM): format NatExt_MF best12. ; 194 format NatExt_nc20 best12. ; MPRINT(PROGRAM): format NatExt_nc20 best12. ; 195 format NCdv_MF best12. ; MPRINT(PROGRAM): format NCdv_MF best12. ; 196 format NCdv_nc20 best12. ; MPRINT(PROGRAM): format NCdv_nc20 best12. ; 197 format NCdv_R6_G100 best12. ; MPRINT(PROGRAM): format NCdv_R6_G100 best12. ; 198 do; MPRINT(PROGRAM): do; 199 EFIOUT + 1; MPRINT(PROGRAM): EFIOUT + 1; 200 put c1aID $ @; MPRINT(PROGRAM): put c1aID $ @; 201 put siteid $ @; MPRINT(PROGRAM): put siteid $ @; 202 put classIarea $ @; MPRINT(PROGRAM): put classIarea $ @; 203 put stabbr $ @; MPRINT(PROGRAM): put stabbr $ @; 204 put notes $ @; MPRINT(PROGRAM): put notes $ @; 205 put Group @; MPRINT(PROGRAM): put Group @; 206 put NatExt_MF @; 9 The SAS System 23:17 Wednesday, October 12, 2022 MPRINT(PROGRAM): put NatExt_MF @; 207 put NatExt_nc20 @; MPRINT(PROGRAM): put NatExt_nc20 @; 208 put NCdv_MF @; MPRINT(PROGRAM): put NCdv_MF @; 209 put NCdv_nc20 @; MPRINT(PROGRAM): put NCdv_nc20 @; 210 put NCdv_R6_G100 ; MPRINT(PROGRAM): put NCdv_R6_G100 ; 211 ; MPRINT(PROGRAM): ; 212 end; MPRINT(PROGRAM): end; 213 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ MPRINT(PROGRAM): if _ERROR_ then call symputx('_EFIERR_',1); 214 if EFIEOD then call symputx('_EFIREC_',EFIOUT); MPRINT(PROGRAM): if EFIEOD then call symputx('_EFIREC_',EFIOUT); 215 run; MPRINT(PROGRAM): run; NOTE: The file './NatCon_merged_for_comparison.MF_nc20.csv' is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/natural_conditions/NatCon_merged_for_comparison.MF_nc20.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=12Oct2022:23:17:23 NOTE: 14 records were written to the file './NatCon_merged_for_comparison.MF_nc20.csv'. The minimum record length was 78. The maximum record length was 123. NOTE: There were 13 observations read from the data set SASD.V2A_MRG_NATCON. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 13 records created in ./NatCon_merged_for_comparison.MF_nc20.csv from SASD.V2A_MRG_NATCON. NOTE: "./NatCon_merged_for_comparison.MF_nc20.csv" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.08 seconds cpu time 0.04 seconds MPRINT(PROGRAM): ; MPRINT(PROGRAM): *********; MPRINT(PROGRAM): data sasd.v2b_natcon_for_csv(keep=c1aID NatExt_nc20 NCdv_nc20); MPRINT(PROGRAM): set sasd.v2a_mrg_natcon; MPRINT(PROGRAM): format NatExt_nc20 f8.5 NCdv_nc20 f8.6; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V2A_MRG_NATCON. NOTE: The data set SASD.V2B_NATCON_FOR_CSV has 13 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MPRINT(PROGRAM): *********; 10 The SAS System 23:17 Wednesday, October 12, 2022 MPRINT(PROGRAM): data sasd.v2c_natcon_colocated; MPRINT(PROGRAM): set sasd.v2b_natcon_for_csv; MPRINT(PROGRAM): if c1aID eq 'GUMO' then c1aID = 'CAVE'; MPRINT(PROGRAM): if c1aID eq 'WHPE' then c1aID = 'PECO'; MPRINT(PROGRAM): if c1aID in ('CAVE','PECO'); MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V2B_NATCON_FOR_CSV. NOTE: The data set SASD.V2C_NATCON_COLOCATED has 2 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds MPRINT(PROGRAM): proc sort data=sasd.v2c_natcon_colocated; MPRINT(PROGRAM): by c1aID; MPRINT(PROGRAM): run; NOTE: There were 2 observations read from the data set SASD.V2C_NATCON_COLOCATED. NOTE: The data set SASD.V2C_NATCON_COLOCATED has 2 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds MPRINT(PROGRAM): *********; MPRINT(PROGRAM): data sasd.v2d_natcon_for_csv; MPRINT(PROGRAM): set sasd.v2b_natcon_for_csv sasd.v2c_natcon_colocated; MPRINT(PROGRAM): by c1aID; MPRINT(PROGRAM): run; NOTE: There were 13 observations read from the data set SASD.V2B_NATCON_FOR_CSV. NOTE: There were 2 observations read from the data set SASD.V2C_NATCON_COLOCATED. NOTE: The data set SASD.V2D_NATCON_FOR_CSV has 15 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.00 seconds MPRINT(PROGRAM): data _null_; MPRINT(PROGRAM): set sasd.v2d_natcon_for_csv; MPRINT(PROGRAM): file "./Natural_Conditions.nc2_4_20.csv" DLM=','; MPRINT(PROGRAM): if _n_ eq 1 then put 'Class I Area,(1/Mm),dv'; MPRINT(PROGRAM): put c1aID NatExt_nc20 NCdv_nc20; MPRINT(PROGRAM): run; NOTE: The file "./Natural_Conditions.nc2_4_20.csv" is: Filename=/work/ROMO/users/hou/400.1/16s1_PSAT_v7.10/0.prep/natural_conditions/Natural_Conditions.nc2_4_20.csv, Owner Name=hou,Group Name=romo, Access Permission=-rw-r--r--, Last Modified=12Oct2022:23:17:23 NOTE: 16 records were written to the file "./Natural_Conditions.nc2_4_20.csv". The minimum record length was 22. The maximum record length was 22. NOTE: There were 15 observations read from the data set SASD.V2D_NATCON_FOR_CSV. NOTE: DATA statement used (Total process time): real time 0.01 seconds 11 The SAS System 23:17 Wednesday, October 12, 2022 cpu time 0.00 seconds MPRINT(PROGRAM): ************************************; MPRINT(PROGRAM): ******************; MLOGIC(PROGRAM): 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.74 seconds cpu time 0.16 seconds