topic Re: Error while exporting a SAS table in SAS Programming

Error while exporting a SAS table

BhavukZutshi — Fri, 05 Feb 2016 07:46:41 GMT

While exporting my data set from SAS to a preferred location I am getting an error " Server file missing or invalid"

Code is given below :

proc export data= class2.grocery_coupons
outfile= "D:\SASExport\grocery_coupons.xls";
run;

I am new to SAS ,so help me in this regard.

Re: Error while exporting a SAS table

mohamed_zaki — Fri, 05 Feb 2016 09:40:08 GMT

If you are using SAS University, you can not use your "local" computer location in your file reference. And also specify your engine. So you need something like this:


proc export data=class2.grocery_coupons 
DBMS=xls
outfile="/folders/myfolders/grocery_coupons.xls";
run;

Re: Error while exporting a SAS table

LinusH — Fri, 05 Feb 2016 16:23:03 GMT

Also, make sure that you have the license for SAS/ACCESS to PC File Formats.