CODEWITHSUNDEEP
sasenterprise-guide
Christoffer
Christoffer

Reputation: 346

SAS Enterprise Guide export as step in process path selection

As part of the SAS Enterprise Guide export as a step in process the outhput file location is very tedious to select. Is there any faster way to do it than clicking through all the folders on my harddrive for every export. The path is shown but I am not able to edit the path or paste a path here:

enter image description here

And when i press browse I am still not able to paste a path: enter image description here

Am I doing something wrong, missing a setting or is there some kind of workaround.

Temporary question to Joe: Like this? enter image description here

Upvotes: 0

Views: 857

Answers (2)

Joe
Joe

Reputation: 63434

You should be able to paste a full path into the filename box, just as with any other "save" dialog. This certainly works with the current version (Enterprise Guide 8.3), but should work with older versions as well.

Upvotes: 1

Negdo
Negdo

Reputation: 532

Here is the most basic example of a macro, that can export your tables as excel files:

%macro ExportExcel(path,file_name,tab_name);
proc export data=&tab_name
    outfile="&path.&file_name..xlsx"
    dbms=xlsx
    replace;
run;
%mend;

You can just paste your path, or better yet, make it a macro variable using %let statement.

But depending on your needs you can make this macro way more complicated. You can put more than one table into a single .xlsx file on different sheets, using a sheet statement. You can export every table from a whole library. It really depends on what you want.

Upvotes: 2

Related Questions