NOTE: The data set WORK.T_TYPE_CODES has 5 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
123410 ;;;;
123411
123412 /*************************************************
123413 Build storm.xlsx
123414 2. Export
123415 PG1.STORM_SUMMARY to tab Storm_Summary
123416 PG1.STORM_DETAIL to tab Storm_Detail
123417 PG1.STORM_DAMAGE to tab Storm_Damage
123418 PG1.STORM_RANGE to tab Storm_Range
123419 PG1.STORM_2017 to tab Storm_2017
123420 PG1.STORM_BASINCODES to tab Basin_Codes
123421 PG1.STORM_SUBBASINCODES to tab SubBasin_Codes
123422 PG1.STORM_BASINCODES to tab Basin_Codes
123423 WORK.T_TYPE_CODES to tab Type_Codes
123424 *************************************************/
123425 LIBNAME xl XLSX "&path/storm.xlsx";
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
123426 libname pg1 "&path";
NOTE: Libref PG1 refers to the same physical library as WORK.
NOTE: Libref PG1 was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\mona\AppData\Local\Temp\SEG12912\SAS Temporary Files\_TD15744_CONTROLLINGPC_\Prc2
123427 options validvarname=any;
123428 data xl.'Storm_Summary'n;
123429 set pg1.storm_summary(rename=(Hem_NS='Hem NS'n Hem_EW='Hem EW'n));
123430 Basin=upcase(basin);
123431 run;
ERROR: Libref XL is not assigned.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
123432 data xl.'Storm_Detail'n;
123433 set pg1.storm_detail;
123434 run;
ERROR: Libref XL is not assigned.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
123435 data xl.'Storm_Damage'n;
123436 set pg1.storm_damage;
123437 format date date9. cost comma15.;
123438 run; Hi! I would like to take the SAS Programming 1: Essentials Course in SAS Enterprise Guide. In the first section I downloaded, extracted and saved the zip. When I pg1v2_eg code, it says "The XLSX engine cannot be found" and "Libref XL is not assigned" What can I do?
... View more