topic SAS Studio questions in SAS Studio

SAS Studio questions

karachi007 — Fri, 22 Jun 2018 14:54:13 GMT

2Qs; 1. How do I export output data? and search on the output data columns I'm new to SAS studio. Please advise

Re: SAS Studio questions

Reeza — Fri, 22 Jun 2018 14:59:53 GMT

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

Re: SAS Studio questions

karachi007 — Fri, 22 Jun 2018 15:16:23 GMT

no luck

Re: SAS Studio questions

Reeza — Fri, 22 Jun 2018 15:19:56 GMT

What did you do and what does that mean?

@karachi007 wrote:
no luck

Re: SAS Studio questions

karachi007 — Fri, 22 Jun 2018 15:25:17 GMT

right click on the data set and export but I don't see any code for export

Re: SAS Studio questions

Reeza — Fri, 22 Jun 2018 15:34:49 GMT

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.

https://video.sas.com/detail/video/4664327156001/reading-and-generating-csv-files-using-snippets-in-sas-studio?autoStart=true&q=export

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

Re: SAS Studio questions

karachi007 — Fri, 22 Jun 2018 16:43:27 GMT

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;

71 proc export data=work.import DBMS=xlsx

73 outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx";

75 run;

ERROR: Temporary file for XLSX file can not be created -> /Program Files/SASUniversityEdition/myfolders//wf.$$1. Make sure the

path name is correct and that you have write permission.

Re: SAS Studio questions

Reeza — Fri, 22 Jun 2018 16:55:57 GMT

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;

70

71 proc export data=work.import DBMS=xlsx

72

73 outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx";

74

75 run;

ERROR: Temporary file for XLSX file can not be created -> /Program Files/SASUniversityEdition/myfolders//wf.$$1. Make sure the

path name is correct and that you have write permission.
 

Re: SAS Studio questions

karachi007 — Fri, 22 Jun 2018 19:59:50 GMT

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 and

that you have write permission.

Re: SAS Studio questions

Reeza — Fri, 22 Jun 2018 20:09:01 GMT

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 and

that you have write permission.
 
sx

Re: SAS Studio questions

karachi007 — Fri, 22 Jun 2018 20:13:33 GMT

I'm using SAS® OnDemand for Academics

Re: SAS Studio questions

Reeza — Fri, 22 Jun 2018 20:15:03 GMT

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