i am using below code in university sas studio university edition
/* exporting data into excel */
/* this program giving error */
/* exporting data into excel */
/* this program giving error */
libname xlout xlsx "&outpath/cars.xlsx";
data xlout.Asiacars;
set sashelp.cars;
where origin='Asia';
run;
proc means data=sashelp.cars noprint maxdec=1;
where type="SUV";
var Horsepower ;
class Model;
ways 1;
output out=xlout.carinfo mean= Length max= Cylinders;
run;
libname xlout clear;
Logs Error:
76
77 libname xlout xlsx "&outpath/cars.xlsx";
WARNING: Apparent symbolic reference OUTPATH not resolved.
NOTE: Libref XLOUT was successfully assigned as follows:
Engine: XLSX
Physical Name: &outpath/cars.xlsx
78
79 data xlout.Asiacars;
80 set sashelp.cars;
81 where origin='Asia';
82 run;
ERROR: Temporary file for XLSX file can not be created -> &outpath//cars.$$1. Make sure the path name is correct and that you have
write permission.
ERROR: File XLOUT.Asiacars.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set XLOUT.Asiacars was only partially opened and will not be saved.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
83
84 proc means data=sashelp.cars noprint maxdec=1;
85 where type="SUV";
86 var Horsepower ;
87 class Model;
88 ways 1;
89 output out=xlout.carinfo mean= Length max= Cylinders;
90 run;
ERROR: Temporary file for XLSX file can not be created -> &outpath//cars.$$1. Make sure the path name is correct and that you have
write permission.
ERROR: File XLOUT.carinfo.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set XLOUT.carinfo was only partially opened and will not be saved.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
91
92 libname xlout clear;
NOTE: Libref XLOUT has been deassigned.
93
94
