1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 %let outpath=/home/u44636833/EPG1V2/output; 70 71 proc export data=np.storm_final outfile="&outpath.csv" dbms=csv 72 replace; 73 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. 74 /********************************************************************** 75 * PRODUCT: SAS 76 * VERSION: 9.4 77 * CREATOR: External File Interface 78 * DATE: 10SEP23 79 * DESC: Generated SAS Datastep Code 80 * TEMPLATE SOURCE: (None Specified.) 81 ***********************************************************************/ 82 data _null_; 83 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 84 %let _EFIREC_ = 0; /* clear export record count macro variable */ 85 file '/home/u44636833/EPG1V2/outputcsv' delimiter=',' DSD DROPOVER lrecl=32767; 86 if _n_ = 1 then /* write column names or labels */ 87 do; 88 put 89 "Season" 90 ',' 91 "Name" 92 ',' 93 "Basin" 94 ',' 95 "BasinName" 96 ',' 97 "OceanCode" 98 ',' 99 "Ocean" 100 ',' 101 "StormType" 102 ',' 103 "MaxWindMPH" 104 ',' 105 "MaxWindKM" 106 ',' 107 "MinPressure" 108 ',' 109 "StartDate" 110 ',' 111 "EndDate" 112 ',' 113 "StormLength" 114 ',' 115 "Lat" 116 ',' 117 "Lon" 118 ; 119 end; 120 set NP.STORM_FINAL end=EFIEOD; 121 format Season best4. ; 122 format Name $char57. ; 123 format Basin $char2. ; 124 format BasinName $14. ; 125 format OceanCode $2. ; 126 format Ocean $8. ; 127 format StormType $13. ; 128 format MaxWindMPH best12. ; 129 format MaxWindKM 3. ; 130 format MinPressure best12. ; 131 format StartDate date9. ; 132 format EndDate date9. ; 133 format StormLength best12. ; 134 format Lat best12. ; 135 format Lon best12. ; 136 do; 137 EFIOUT + 1; 138 put Season @; 139 put Name $ @; 140 put Basin $ @; 141 put BasinName $ @; 142 put OceanCode $ @; 143 put Ocean $ @; 144 put StormType $ @; 145 put MaxWindMPH @; 146 put MaxWindKM @; 147 put MinPressure @; 148 put StartDate @; 149 put EndDate @; 150 put StormLength @; 151 put Lat @; 152 put Lon ; 153 ; 154 end; 155 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 156 if EFIEOD then call symputx('_EFIREC_',EFIOUT); 157 run; NOTE: The file '/home/u44636833/EPG1V2/outputcsv' is: Filename=/home/u44636833/EPG1V2/outputcsv, Owner Name=u44636833,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=10Sep2023:11:43:26 NOTE: 31 records were written to the file '/home/u44636833/EPG1V2/outputcsv'. The minimum record length was 76. The maximum record length was 124. NOTE: There were 30 observations read from the data set NP.STORM_FINAL. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 10839.37k OS Memory 28960.00k Timestamp 09/10/2023 06:13:26 AM Step Count 18 Switch Count 0 Page Faults 0 Page Reclaims 220 Page Swaps 0 Voluntary Context Switches 6 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 16 30 records created in /home/u44636833/EPG1V2/outputcsv from NP.STORM_FINAL. NOTE: "/home/u44636833/EPG1V2/outputcsv" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.04 seconds user cpu time 0.03 seconds system cpu time 0.02 seconds memory 10839.37k OS Memory 29220.00k Timestamp 09/10/2023 06:13:26 AM Step Count 18 Switch Count 8 Page Faults 0 Page Reclaims 3876 Page Swaps 0 Voluntary Context Switches 86 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 112 158 159 160 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 170
... View more