CODEWITHSUNDEEP
sas
Pranasas
Pranasas

Reputation: 596

SAS ODS (proper data output) with cloud-only access?

So I have SAS Enterprise Guide 6.1 which connects to SAS system via cloud access (main system itself is physically located at my university I think).

Now I want to output a few tables and place them into a LaTeX document. I am unsure how that will work out but some searching yields examples such as

ods tagsets.latex file="C:\SAS\mydata.tex";
proc print data=work.mydata;
...
run;
ods tagsets.latex close;

The obvious problem here is that the remote SAS system does not have access to actually create files freely on my computer (and I don't have access to create files freely on that remote machine).

Could I possibly have the results printed on the screen or some other workaround?

Upvotes: 1

Views: 130

Answers (2)

Joe
Joe

Reputation: 63424

You can store them in the work directory, and then use the "Copy Files" task to download them to your local PC. You define the filename like so:

%let workdir = %sysfunc(getoption(work));
filename tempfile "&workdir.\myfile.ext"; *ext = extension for your file;

Then use that fileref in your ODS statement. Finally, you can use Copy Files to bring it down to your local machine.

See this blog post for more information.

Upvotes: 1

vasja
vasja

Reputation: 4792

Have a look at FILENAME statement (http://support.sas.com/documentation/cdl/en/lestmtsref/65040/HTML/default/viewer.htm#p05r9vhhqbhfzun1qo9mw64s4700.htm).

Candidate methods are URL, FTP, WEBDAV. Also you could create a file and use FILENAME EMAIL to send it.

Quick tip how this could look like:

filename foo url 'http://www.mysite.com/test.tex';

filename foo "%sysfunc(pathname(WORK))\test.tex";/* you should be able to write here */

ods tagsets.latex file=foo;
proc print data=sashelp.class;
run;
ods tagsets.latex close;

filename foo clear;

Upvotes: 1

Related Questions