Unsolved
This post is more than 5 years old
2 Posts
0
1034
October 14th, 2017 05:00
Can I export matrix to Excel from SAS University on PC under VMWare.?
I wish to write to Excel on my PC a "big" matrix of p rows and c columns, e.g. 3,000 rows and 20 columns. But it's not easy, and I'm wondering if I can simplify it by using a fixed number for rows and columns instead of:
array mat {&periods,&columns};
Right now, I'm on the free version of SAS called "SAS University Edition", which has only community help.
I would like to output it to Excel, but using VMWARE on a PC to get SAS Studio to run, you can't write directly to disk (although there is a myfolder).
I tried this, but got this error log:
proc export data=WORK.CPAPMONTE1
file= "/folders/myfolders/outfile1.xlsx"
DBMS=xlsx
;
run;
ERROR: XLSX file can not be created -> /folders/myfolders//outfile1.xlsx. Make sure the path name is correct and that you have write permission.
ERROR: Too many variables for the output file
I figure that the 2nd error is just due to the first error, which has a // instead of a /
- I have defined a special folder for my data in SAS University Edition as: /folders/myfolders/CPAP1
but I haven't figured out how to point to there.
speedstep
9 Legend
•
47K Posts
0
October 17th, 2017 10:00
This is not a Dell Hardware support Question.
This is not supported and will not be supported here.