topic Re: Filename inODS in ODS and Base Reporting

Filename inODS

Flip — Tue, 01 Sep 2009 19:54:47 GMT

OK my brain seems to be dead. I am writing a spreadsheet out but I only have a library reference not a path. So if I write a file by datastep I put
Data _null_;
file library(filename);

Now if I want to use ODS I have

ODS excelxp file = ??? ...

using the syntax library(filename) does not work here. How is this accomplished.

Re: Filename inODS

sbb — Tue, 01 Sep 2009 20:27:11 GMT

The only OS where I have ever seen such FILE statement syntax is z/OS (MVS) where you have a pre-defined JCL DD statement pointing to a PDS or PDSE library, or you have a SAS-defined FILENAME pointing to the library and the member name is placed inside the parentheses. If you have a predefined FILENAME (or an external JCL DD on MVS) and you do not want a PDS (or if it is not an MVS environment), you specify the SAS FILENAME or the FILE statement with the complete file name defined in quotes. And when using ODS, you would specify FILE= parameter.

Scott Barry
SBBWorks, Inc.

Re: Filename inODS

Flip — Tue, 01 Sep 2009 21:55:40 GMT

> The only OS where I have ever seen such FILE
> statement syntax is z/OS (MVS)
>
> Scott Barry
> SBBWorks, Inc.

In that case here.

http://support.sas.com/documentation/cdl/en/hostunx/61879/HTML/default/specaggs.htm

Now back to the question. The environment I am working in assigns the library where the text files are to be placed (which of course changes between Development and Production environments) but not the path for this library. Sure I would change that if I could, and I may have to. But it would be more consistant with the structure I am working in to be able to reference the file by fileref and filename rather than fully qualified name.

Re: Filename inODS

ballardw — Tue, 01 Sep 2009 23:08:28 GMT

Not really eligant but you could pull the PATHNAME value from DICTIONARY.LIBNAMES into a macro variable with SQL for the given library.

Re: Filename inODS

Flip — Tue, 01 Sep 2009 23:13:02 GMT

I was thinking that something like that might be neccessary. I was hoping someone here had the silver bullet for this.

Re: Filename inODS

data_null__ — Wed, 02 Sep 2009 03:18:46 GMT

Don't know if this is silver bullet but it seems obvious.

Since the parenthesized file name syntax does not work, don’t use it. You have the FILEREF to the aggregate location so just make a new FILEREF using the information you have plus the file you want to create.

[pre]
filename FT29F001 '.';

filename FT30F001 "%sysfunc(pathname(FT29F001,F))\dummy.xls";

ods tagsets.excelxp file=FT30F001;
proc print data=sashelp.class;
run;
ods tagsets.excelxp close;
[/pre]

Re: Filename inODS

Flip — Wed, 02 Sep 2009 12:03:37 GMT

Poifect.

That was exactly what my tired brain was searching for.