2Qs; 1. How do I export output data? and search on the output data columns I'm new to SAS studio. Please advise
Right click the data set in your library and select Export.
Write a PROC EXPORT statement.
Use a Task to write the export code for you.
@karachi007 wrote:
2Qs; 1. How do I export output data? and search on the output data columns I'm new to SAS studio. Please advise
this is my export code still getting errors:
proc export data=work.import DBMS=xlsx
outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx";
run;
error;
The path has to start with the '/folders/myfolders/' portion because it's not running off your computer, it's running on a virtual machine that's on your computer and the path is different.
Try the exact code I posted. Then change things one at a time and see what you can get.
@karachi007 wrote:
this is my export code still getting errors:
proc export data=work.import DBMS=xlsx
outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx";
run;
error;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;7071 proc export data=work.import DBMS=xlsx7273 outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx";7475 run;ERROR: Temporary file for XLSX file can not be created -> /Program Files/SASUniversityEdition/myfolders//wf.$$1. Make sure thepath name is correct and that you have write permission.
right click on the data set and export but I don't see any code for export
You won't see code but you can save it via point and click.
What format are you trying to export it to?
Here's a video on CSV exports.
Page 102 in the User Guide:
http://documentation.sas.com/api/docsets/webeditorug/3.7/content/webeditorug.pdf?locale=en
proc export out=sashelp.class datafile="/folders/myfolders/demo.xlsx" dbms=xlsx replace; run;
@karachi007 wrote:
right click on the data set and export but I don't see any code for export
this is the code and error. I'm trying to export in xlsx.
proc export data=work.import DBMS=xlsx
outfile="/folders/myfolders/thesis.xlsx";
run;
sx
I'm assuming you're using SAS UE, is that correct?
Did you set up the myfolders folder as per the installation guide/instructions?
If so, navigate to the folder under Servers Folders pane and right click it and verify the path. If you didn't set it up, you'll need to add it in your VM settings.
Also please post the exact code and log.
@karachi007 wrote:
this is the code and error. I'm trying to export in xlsx.
proc export data=work.import DBMS=xlsx
outfile="/folders/myfolders/thesis.xlsx";
run;ERROR: Temporary file for XLSX file can not be created -> /folders/myfolders//thesis.$$1. Make sure the path name is correct andthat you have write permission.sx
I'm using SAS® OnDemand for Academics
Ok. Then you need to find the path to a folder you can export to, same idea as before go to server panes and folders. Export to one of the paths you have. Then you need to right click the file to download it to your local machine, since everything in SAS AoD is in the cloud.
@karachi007 wrote:
I'm using SAS® OnDemand for Academics
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.