Hi @ivarenho , could you try the code as follows and see what happen? The correct code should be this and there should be no problem, when I run this code before (for pg1 activity6.02) it works well.
libname pg1 "S:/workshop/EPG1V2/data";
%let outpath=s:/workshop/output;
proc export data=pg1.storm_final
outfile="&outpath/storm_final.csv"
dbms=csv replace;
run;
Regarding the other two of your posts, I tried the code (which in fact is identical to the code above) I got similar problem (the csv file was created successfully though), I do not know that happened (got those odd message, I copied them here), hope there are experts who can help explain what happened (it looks like I got something odd when export dataset to csv files at the moment). The code and log message are as follows:
the code:
libname pg1 "~/LWPG1V2/data";
%let outpath=~/LWPG1V2;
proc export data=pg1.storm_final
outfile="&outpath/storm_final.csv"
dbms=csv replace;
run;
the log message:
69 libname pg1 "~/LWPG1V2/data";
NOTE: Libref PG1 was successfully assigned as follows:
70 %let outpath=~/LWPG1V2;
71 proc export data=pg1.storm_final
72 outfile="&outpath/storm_final.csv"
73 dbms=csv replace;
74 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.
75 /**********************************************************************
76 * PRODUCT: SAS
77 * VERSION: 9.4
78 * CREATOR: External File Interface
79 * DATE: 13MAY26
80 * DESC: Generated SAS Datastep Code
81 * TEMPLATE SOURCE: (None Specified.)
82 ***********************************************************************/
83 data _null_;
84 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
85 %let _EFIREC_ = 0; /* clear export record count macro variable */
86 file '~/LWPG1V2/storm_final.csv' delimiter=',' DSD DROPOVER lrecl=32767;
87 if _n_ = 1 then /* write column names or labels */
88 do;
89 put
90 "Season"
91 ','
92 "Name"
93 ','
94 "Basin"
95 ','
96 "BasinName"
97 ','
98 "OceanCode"
99 ','
100 "Ocean"
101 ','
102 "StormType"
103 ','
104 "MaxWindMPH"
105 ','
106 "MaxWindKM"
107 ','
108 "MinPressure"
109 ','
110 "StartDate"
111 ','
112 "EndDate"
113 ','
114 "StormLength"
115 ','
116 "Lat"
117 ','
118 "Lon"
119 ;
120 end;
121 set PG1.STORM_FINAL end=EFIEOD;
122 format Season best4. ;
123 format Name $char57. ;
124 format Basin $char2. ;
125 format BasinName $14. ;
126 format OceanCode $2. ;
127 format Ocean $8. ;
128 format StormType $13. ;
129 format MaxWindMPH best12. ;
130 format MaxWindKM 3. ;
131 format MinPressure best12. ;
132 format StartDate date9. ;
133 format EndDate date9. ;
134 format StormLength best12. ;
135 format Lat best12. ;
136 format Lon best12. ;
137 do;
138 EFIOUT + 1;
139 put Season @;
140 put Name $ @;
141 put Basin $ @;
142 put BasinName $ @;
143 put OceanCode $ @;
144 put Ocean $ @;
145 put StormType $ @;
146 put MaxWindMPH @;
147 put MaxWindKM @;
148 put MinPressure @;
149 put StartDate @;
150 put EndDate @;
151 put StormLength @;
152 put Lat @;
153 put Lon ;
154 ;
155 end;
156 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
157 if EFIEOD then call symputx('_EFIREC_',EFIOUT);
158 run;
NOTE: The file '~/LWPG1V2/storm_final.csv' is:
Access Permission=-rw-r--r--,
Last Modified=13May2026:10:31:24
NOTE: 3093 records were written to the file '~/LWPG1V2/storm_final.csv'.
The minimum record length was 69.
The maximum record length was 124.
NOTE: There were 3092 observations read from the data set PG1.STORM_FINAL.
