export to xls on mac problem ??

20107589 — Sat, 06 Feb 2016 16:26:35 GMT

hey guys, hope you can help.

i get the error File= or Table= is required and must be specified, and i cant figure out what the problem is ? please help

proc freq data=data4;
tables still*aar/out=histo;
run;

proc export data=histo
OUTFILE="folder/myfolder/ex1.xls"
DBMS=XLS REPLACE;
SHEET="tilstande";
run;

Re: export to xls on mac problem ??

Cynthia_sas — Sat, 06 Feb 2016 17:27:37 GMT

Hi: Please refer to some of the previous posts about using SAS University Edition and the way you reference your shared folder. Typically, you are instructed to set up a subdirectory called "myfolders" under your root, SASUniversity Edition shared folder. You show the string "/myfolder" in your code and SAS University Edition REALLY, REALLY, wants that folder to be named "/myfolders" -- so whether you are on a Mac or a PC is irrelevant -- what did you name your shared folder??? "myfolder" or "myfolders"
1) if you named it "myfolder" go back to your Mac OS directory structure and rename it to "myfolders" (with an s on the end) and then make sure that your virtualization software has the correct path name defined as the shared folder location or
2) if your Mac drive shows that you created /myfolders and you shared it as that, then change your code to add the s

Bottom line -- when I do an export, using SAS University Edition, I need to use:
OUTFILE="/folders/myfolders/mywb.xls"

Please note the leading slash in front of the path...and note that I have /folders (there is an s on the end of the high-level path, too).

Here are some previous postings:
https://communities.sas.com/t5/SAS-Analytics-U/Export-dataset-from-SAS-university-edition-to-excel/m-p/208923/highlight/true#M2137 (this one is the most relevant and shows many PROC EXPORT examples)
and...
https://communities.sas.com/t5/Base-SAS-Programming/How-do-I-reference-SAS-data-from-within-a-SAS-program-on-Mac/m-p/230432/highlight/true#M41784

https://communities.sas.com/t5/SAS-Analytics-U/Library-does-not-exist-despite-using-Unix-forward-slashes/m-p/200417/highlight/true#M1838
http://support.sas.com/software/products/university-edition/faq/trouble_invalid_path_error.htm

cynthia

topic export to xls on mac problem ?? in SAS Procedures

export to xls on mac problem ??

Re: export to xls on mac problem ??