activity p106a2

gswn — Wed, 03 Jul 2019 10:18:06 GMT

on doing this activity i get the following and i don't know how to solve this error message.... help is appreciated

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 proc export data=pg1.storm_final outfile="&outpath/storm_final.csv" dbms=csv;

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: 03JUL19

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 'C:/Users/Z1gs/stack/SASUniversityEdition/folders/myfolders/EPG194/output/storm_final.csv' delimiter=',' DSD

86 ! 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;

ERROR: Physical file does not exist,

/opt/sasinside/SASConfig/Lev1/SASApp/C:/Users/Z1gs/stack/SASUniversityEdition/folders/myfolders/EPG194/output/storm_final.csv

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set PG1.STORM_FINAL.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

0 records created in C:/Users/Z1gs/stack/SASUniversityEdition/folders/myfolders/EPG194/output/storm_final.csv from PG1.STORM_FINAL.

NOTE: "C:/Users/Z1gs/stack/SASUniversityEdition/folders/myfolders/EPG194/output/storm_final.csv" file was successfully created.

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.07 seconds

cpu time 0.05 seconds

159

160 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: activity p106a2

Kurt_Bremser — Wed, 03 Jul 2019 10:26:19 GMT

You need to use a UNIX path in UE. Windows paths are considered "relative", and the SAS process starts to search in its current working directory.

Use this in macro variable outpath:

/folders/myfolders/EPG194

Note the leading slash. This is necessary to create an "absolute" path.

topic activity p106a2 in Programming 1 and 2

activity p106a2

Re: activity p106a2