export the file form sas studio to local machine

daoud_028 — Sat, 06 Feb 2021 19:35:26 GMT

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

Re: export the file form sas studio to local machine

tarheel13 — Sat, 06 Feb 2021 20:16:55 GMT

&outpath is a macro variable. Did you assign it anywhere?

topic Re: export the file form sas studio to local machine in SAS Programming

export the file form sas studio to local machine

Re: export the file form sas studio to local machine